[Commits] Rev 2869: Make suite/optimizer_unfixed_bugs/t/bug43618.test work in any timezone. in file:///home/psergey/dev2/maria-5.3-mwl128-dsmrr-cpk/

Sergey Petrunya psergey at askmonty.org
Mon Nov 29 21:13:17 EET 2010


At file:///home/psergey/dev2/maria-5.3-mwl128-dsmrr-cpk/

------------------------------------------------------------
revno: 2869
revision-id: psergey at askmonty.org-20101129191316-4vqhmpo6tty0rsx7
parent: psergey at askmonty.org-20101129164732-p0gn3ymyhh3v9mh4
committer: Sergey Petrunya <psergey at askmonty.org>
branch nick: maria-5.3-mwl128-dsmrr-cpk
timestamp: Mon 2010-11-29 22:13:16 +0300
message:
  Make suite/optimizer_unfixed_bugs/t/bug43618.test work in any timezone.
=== modified file 'mysql-test/suite/optimizer_unfixed_bugs/r/bug43618.result'
--- a/mysql-test/suite/optimizer_unfixed_bugs/r/bug43618.result	2009-12-15 07:16:46 +0000
+++ b/mysql-test/suite/optimizer_unfixed_bugs/r/bug43618.result	2010-11-29 19:13:16 +0000
@@ -1,3 +1,5 @@
+set @save_time_zone= @@time_zone;
+set time_zone='+03:00';
 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP NULL, c3 DATE, c4 DATETIME, PRIMARY KEY(c1), UNIQUE INDEX(c2));
 INSERT INTO t1 VALUES('98-12-31 11:30:45','98.12.31 11+30+45','98-12-31 11:30:45','98.12.31 11+30+45'),('98/12/30 11*30*45','98 at 12@30 11^30^45','98/12/30 11*30*45','98 at 12@30 11^30^45'),('98-12-29','98.12.29','98-12-29','98.12.29'),('98/12/28','98 at 12@28','98/12/28','98 at 12@28');
 Warnings:
@@ -52,3 +54,4 @@
 Warning	1292	Incorrect datetime value: '2010-10-00 00:00:00' for column 'c2' at row 1
 Warning	1292	Incorrect datetime value: '2010-10-00 00:00:00' for column 'c2' at row 1
 DROP TABLE t1;
+set time_zone= @save_time_zone;

=== modified file 'mysql-test/suite/optimizer_unfixed_bugs/t/bug43618.test'
--- a/mysql-test/suite/optimizer_unfixed_bugs/t/bug43618.test	2009-12-15 07:16:46 +0000
+++ b/mysql-test/suite/optimizer_unfixed_bugs/t/bug43618.test	2010-11-29 19:13:16 +0000
@@ -3,6 +3,8 @@
 
 --source include/have_debug.inc
 
+set @save_time_zone= @@time_zone;
+set time_zone='+03:00';
 # bug goes away with
 #set session debug="+d,optimizer_no_icp";
 
@@ -43,4 +45,5 @@
 SELECT * FROM t1 WHERE c1 BETWEEN '0000-00-00' AND '2010-00-01 00:00:00' ORDER BY c1 DESC LIMIT 2;
 SELECT * FROM t1 WHERE c2 BETWEEN '1971-01-01 00:00:01' AND '2010-10-00 00:00:00' ORDER BY c2 DESC LIMIT 2;
 DROP TABLE t1;
+set time_zone= @save_time_zone;
 



More information about the commits mailing list