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

Sergey Petrunya psergey at askmonty.org
Mon Nov 29 18:47:32 EET 2010


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

------------------------------------------------------------
revno: 2868
revision-id: psergey at askmonty.org-20101129164732-p0gn3ymyhh3v9mh4
parent: psergey at askmonty.org-20101129160032-c57opgqyogv5r23t
committer: Sergey Petrunya <psergey at askmonty.org>
branch nick: maria-5.3-mwl128-dsmrr-cpk-r2
timestamp: Mon 2010-11-29 19:47:32 +0300
message:
  Make suite/optimizer_unfixed_bugs/t/bug43617.test work in any timezone.
=== modified file 'mysql-test/suite/optimizer_unfixed_bugs/r/bug43617.result'
--- a/mysql-test/suite/optimizer_unfixed_bugs/r/bug43617.result	2009-12-15 07:16:46 +0000
+++ b/mysql-test/suite/optimizer_unfixed_bugs/r/bug43617.result	2010-11-29 16:47:32 +0000
@@ -1,4 +1,6 @@
 set storage_engine=innodb;
+set @save_time_zone= @@time_zone;
+set time_zone='+03:00';
 set session debug="+d,optimizer_innodb_icp";
 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');
@@ -95,3 +97,4 @@
 c1	c2	c3	c4
 2038-01-09 03:14:07	2038-01-09 03:14:07	2009-01-05	2009-01-06 00:00:00
 DROP TABLE t1;
+set time_zone= @save_time_zone;

=== modified file 'mysql-test/suite/optimizer_unfixed_bugs/t/bug43617.test'
--- a/mysql-test/suite/optimizer_unfixed_bugs/t/bug43617.test	2009-12-15 07:16:46 +0000
+++ b/mysql-test/suite/optimizer_unfixed_bugs/t/bug43617.test	2010-11-29 16:47:32 +0000
@@ -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 ########
@@ -81,3 +82,5 @@
 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;
+



More information about the commits mailing list