diff options
author | Nirbhay Choubey <nirbhay@mariadb.com> | 2017-01-18 11:44:47 -0500 |
---|---|---|
committer | Nirbhay Choubey <nirbhay@mariadb.com> | 2017-01-18 11:44:47 -0500 |
commit | a3a91332d006fd39a32e1f6d4663e11515ea944b (patch) | |
tree | 560c152c9f8146a4c1bcd52ad2a2fa454be48aec /mysql-test/t/group_by.test | |
parent | 2805baf06c31dac21604148ec089300461790e3d (diff) | |
download | mariadb-git-bb-10.2-mdev7635.saved.tar.gz |
MDEV-7635: Update tests to adapt to the new default sql_modebb-10.2-mdev7635.savedbb-10.2-mdev7635.final
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); |