diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2010-11-29 22:13:16 +0300 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2010-11-29 22:13:16 +0300 |
| commit | acb9ba8a4f00864d76c290866a0484faf2d64c35 (patch) | |
| tree | 0a4886eb77d6a6866a53ee66d099e6ef7f269ba1 /mysql-test/suite/optimizer_unfixed_bugs/r | |
| parent | f2abf5f6b14a9b9cb62f0f90ec38464e42f0004f (diff) | |
| download | mariadb-git-acb9ba8a4f00864d76c290866a0484faf2d64c35.tar.gz | |
Make suite/optimizer_unfixed_bugs/t/bug43618.test work in any timezone.
Diffstat (limited to 'mysql-test/suite/optimizer_unfixed_bugs/r')
| -rw-r--r-- | mysql-test/suite/optimizer_unfixed_bugs/r/bug43618.result | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/suite/optimizer_unfixed_bugs/r/bug43618.result b/mysql-test/suite/optimizer_unfixed_bugs/r/bug43618.result index ee5a8bebf4d..4350c912a31 100644 --- a/mysql-test/suite/optimizer_unfixed_bugs/r/bug43618.result +++ b/mysql-test/suite/optimizer_unfixed_bugs/r/bug43618.result @@ -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@12@30 11^30^45','98/12/30 11*30*45','98@12@30 11^30^45'),('98-12-29','98.12.29','98-12-29','98.12.29'),('98/12/28','98@12@28','98/12/28','98@12@28'); Warnings: @@ -52,3 +54,4 @@ Warnings: 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; |