diff options
Diffstat (limited to 'mysql-test/t/group_by.test')
| -rw-r--r-- | mysql-test/t/group_by.test | 12 |
1 files changed, 8 insertions, 4 deletions
diff --git a/mysql-test/t/group_by.test b/mysql-test/t/group_by.test index a97d8ef4248..b0949cfef03 100644 --- a/mysql-test/t/group_by.test +++ b/mysql-test/t/group_by.test @@ -21,10 +21,10 @@ CREATE TABLE t1 ( date date ); -INSERT INTO t1 VALUES (1,1,1,'','0000-00-00'); -INSERT INTO t1 VALUES (2,2,2,'','0000-00-00'); -INSERT INTO t1 VALUES (2,1,1,'','0000-00-00'); -INSERT INTO t1 VALUES (3,3,3,'','0000-00-00'); +INSERT IGNORE INTO t1 VALUES (1,1,1,'','0000-00-00'); +INSERT IGNORE INTO t1 VALUES (2,2,2,'','0000-00-00'); +INSERT IGNORE INTO t1 VALUES (2,1,1,'','0000-00-00'); +INSERT IGNORE INTO t1 VALUES (3,3,3,'','0000-00-00'); CREATE TABLE t2 ( userID int(10) unsigned NOT NULL auto_increment, @@ -59,6 +59,7 @@ drop table t1,t2; # Bug in GROUP BY, by Nikki Chumakov <nikki@saddam.cityline.ru> # +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; CREATE TABLE t1 ( PID int(10) unsigned NOT NULL auto_increment, payDate date DEFAULT '0000-00-00' NOT NULL, @@ -78,6 +79,7 @@ CREATE TABLE t1 ( KEY method (method), KEY payDate (payDate) ); +SET sql_mode = DEFAULT; INSERT INTO t1 VALUES (1,'1970-01-01','1997-10-17 00:00:00',2529,1,21000,11886,'check',0,'F',16200,6); @@ -127,6 +129,7 @@ drop table t1; # Test of group by bug in bugzilla # +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; CREATE TABLE t1 ( bug_id mediumint(9) NOT NULL auto_increment, groupset bigint(20) DEFAULT '0' NOT NULL, @@ -167,6 +170,7 @@ CREATE TABLE t1 ( KEY qa_contact (qa_contact), KEY votes (votes) ); +SET sql_mode = DEFAULT; INSERT INTO t1 VALUES (1,0,0,'','normal','','2000-02-10 09:25:12',20000321114747,'','','Linux','P1','TestProduct','PC',3,'other','TestComponent','','M1',0,'',0); INSERT INTO t1 VALUES (9,0,0,'','enhancement','','2000-03-10 11:49:36',20000321114747,'','','All','P5','AAAAA','PC',3,'2.00 CD - Pre','BBBBBBBBBBBBB - conversion','','',0,'',0); |