diff options
| author | unknown <jani@hynda.(none)> | 2003-03-22 20:34:20 +0200 |
|---|---|---|
| committer | unknown <jani@hynda.(none)> | 2003-03-22 20:34:20 +0200 |
| commit | c1719ad057d0bfa3bc4a40d01c604193c91a5659 (patch) | |
| tree | 1b9e4699601c329a0eab8e8bccb8e0fdb7d74b3f /mysql-test/t/group_by.test | |
| parent | ebedd1521c19f9a6a2025d5c1c5be751cdb7b636 (diff) | |
| download | mariadb-git-c1719ad057d0bfa3bc4a40d01c604193c91a5659.tar.gz | |
Changed some tests to pass with new auto_increment handling,
e.g. default value is not accepted with auto_increment anymore.
Diffstat (limited to 'mysql-test/t/group_by.test')
| -rw-r--r-- | mysql-test/t/group_by.test | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/t/group_by.test b/mysql-test/t/group_by.test index ab5d6062daf..5875f9a9ba9 100644 --- a/mysql-test/t/group_by.test +++ b/mysql-test/t/group_by.test @@ -17,7 +17,7 @@ INSERT INTO t1 VALUES (2,1,1,'','0000-00-00'); INSERT INTO t1 VALUES (3,3,3,'','0000-00-00'); CREATE TABLE t2 ( - userID int(10) unsigned DEFAULT '0' NOT NULL auto_increment, + userID int(10) unsigned NOT NULL auto_increment, niName char(15), passwd char(8), mail char(50), @@ -47,7 +47,7 @@ drop table test.t1,test.t2; # CREATE TABLE t1 ( - PID int(10) unsigned DEFAULT '0' NOT NULL auto_increment, + PID int(10) unsigned NOT NULL auto_increment, payDate date DEFAULT '0000-00-00' NOT NULL, recDate datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, URID int(10) unsigned DEFAULT '0' NOT NULL, @@ -79,7 +79,7 @@ drop table t1; # CREATE TABLE t1 ( - cid mediumint(9) DEFAULT '0' NOT NULL auto_increment, + cid mediumint(9) NOT NULL auto_increment, firstname varchar(32) DEFAULT '' NOT NULL, surname varchar(32) DEFAULT '' NOT NULL, PRIMARY KEY (cid) @@ -88,7 +88,7 @@ INSERT INTO t1 VALUES (1,'That','Guy'); INSERT INTO t1 VALUES (2,'Another','Gent'); CREATE TABLE t2 ( - call_id mediumint(8) DEFAULT '0' NOT NULL auto_increment, + call_id mediumint(8) NOT NULL auto_increment, contact_id mediumint(8) DEFAULT '0' NOT NULL, PRIMARY KEY (call_id), KEY contact_id (contact_id) @@ -114,7 +114,7 @@ unlock tables; # CREATE TABLE t1 ( - bug_id mediumint(9) DEFAULT '0' NOT NULL auto_increment, + bug_id mediumint(9) NOT NULL auto_increment, groupset bigint(20) DEFAULT '0' NOT NULL, assigned_to mediumint(9) DEFAULT '0' NOT NULL, bug_file_loc text, |