diff options
Diffstat (limited to 'mysql-test/suite/optimizer_unfixed_bugs/t/bug43617.test')
-rw-r--r-- | mysql-test/suite/optimizer_unfixed_bugs/t/bug43617.test | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/mysql-test/suite/optimizer_unfixed_bugs/t/bug43617.test b/mysql-test/suite/optimizer_unfixed_bugs/t/bug43617.test index 6446ce36f5d..2b3b65577af 100644 --- a/mysql-test/suite/optimizer_unfixed_bugs/t/bug43617.test +++ b/mysql-test/suite/optimizer_unfixed_bugs/t/bug43617.test @@ -4,7 +4,8 @@ --source include/have_innodb.inc set storage_engine=innodb; - +set @save_time_zone= @@time_zone; +set time_zone='+03:00'; set session debug="+d,optimizer_innodb_icp"; ######## Running INSERT tests for TIMESTAMP ######## @@ -42,10 +43,10 @@ SELECT * FROM t1; # Test 'INSERT IGNORE' with the same rows that reported constraint violation above # Ignore pk constraint -INSERT IGNORE INTO t1(c1,c2) VALUES('20070525','20070527') /* doesn't throw error */; +INSERT IGNORE INTO t1(c1,c2) VALUES('20070525','20070527') /* doesnt throw error */; # Ignore unique constraint -INSERT IGNORE INTO t1(c1,c2) VALUES(19840905,830907) /* doesn't throw error */; +INSERT IGNORE INTO t1(c1,c2) VALUES(19840905,830907) /* doesnt throw error */; # Test 'INSERT ON DUPLICATE KEY UPDATE' with single column PK SELECT * FROM t1 WHERE c1='20070527' /* Returns no rows */; @@ -81,3 +82,5 @@ SELECT * FROM t1 WHERE c2 IN ('1971-01-01 00:00:01','2038-01-09 03:14:07') ORDER SELECT * FROM t1 WHERE c2 IN ('1971-01-01 00:00:01','2038-01-09 03:14:07') ORDER BY c2 DESC LIMIT 2; DROP TABLE t1; +set time_zone= @save_time_zone; + |