diff options
Diffstat (limited to 'mysql-test/r/timezone2.result')
| -rw-r--r-- | mysql-test/r/timezone2.result | 28 |
1 files changed, 14 insertions, 14 deletions
diff --git a/mysql-test/r/timezone2.result b/mysql-test/r/timezone2.result index bb1d764ac8c..6fd67d00259 100644 --- a/mysql-test/r/timezone2.result +++ b/mysql-test/r/timezone2.result @@ -70,7 +70,7 @@ i ts 1067129999 2003-10-26 00:59:59 1067137200 2003-10-26 03:00:00 1067129999 2003-10-26 00:59:59 -delete from t1; +truncate table t1; set time_zone='Europe/Moscow'; insert into t1 (i, ts) values (unix_timestamp('2004-01-01 00:00:00'),'2004-01-01 00:00:00'), @@ -85,7 +85,7 @@ i ts 1080428400 2004-03-28 03:00:00 1091304000 2003-08-01 00:00:00 1099175400 2004-10-31 02:30:00 -delete from t1; +truncate table t1; set time_zone='leap/Europe/Moscow'; insert into t1 (i, ts) values (unix_timestamp('2004-01-01 00:00:00'),'2004-01-01 00:00:00'), @@ -100,7 +100,7 @@ i ts 1080428422 2004-03-28 03:00:00 1091304022 2003-08-01 00:00:00 1099175422 2004-10-31 02:30:00 -delete from t1; +truncate table t1; insert into t1 (i, ts) values (unix_timestamp('1981-07-01 03:59:59'),'1981-07-01 03:59:59'), (unix_timestamp('1981-07-01 04:00:00'),'1981-07-01 04:00:00'); @@ -118,9 +118,9 @@ insert into t1 values ('0000-00-00 00:00:00'),('1969-12-31 23:59:59'), ('1970-01-01 00:00:00'),('1970-01-01 00:00:01'), ('2038-01-19 03:14:07'),('2038-01-19 03:14:08'); Warnings: -Warning 1264 Out of range value adjusted for column 'ts' at row 2 -Warning 1264 Out of range value adjusted for column 'ts' at row 3 -Warning 1264 Out of range value adjusted for column 'ts' at row 6 +Warning 1264 Out of range value for column 'ts' at row 2 +Warning 1264 Out of range value for column 'ts' at row 3 +Warning 1264 Out of range value for column 'ts' at row 6 select * from t1; ts 0000-00-00 00:00:00 @@ -129,15 +129,15 @@ ts 1970-01-01 00:00:01 2038-01-19 03:14:07 0000-00-00 00:00:00 -delete from t1; +truncate table t1; set time_zone='MET'; insert into t1 values ('0000-00-00 00:00:00'),('1970-01-01 00:30:00'), ('1970-01-01 01:00:00'),('1970-01-01 01:00:01'), ('2038-01-19 04:14:07'),('2038-01-19 04:14:08'); Warnings: -Warning 1264 Out of range value adjusted for column 'ts' at row 2 -Warning 1264 Out of range value adjusted for column 'ts' at row 3 -Warning 1264 Out of range value adjusted for column 'ts' at row 6 +Warning 1264 Out of range value for column 'ts' at row 2 +Warning 1264 Out of range value for column 'ts' at row 3 +Warning 1264 Out of range value for column 'ts' at row 6 select * from t1; ts 0000-00-00 00:00:00 @@ -146,15 +146,15 @@ ts 1970-01-01 01:00:01 2038-01-19 04:14:07 0000-00-00 00:00:00 -delete from t1; +truncate table t1; set time_zone='+01:30'; insert into t1 values ('0000-00-00 00:00:00'),('1970-01-01 01:00:00'), ('1970-01-01 01:30:00'),('1970-01-01 01:30:01'), ('2038-01-19 04:44:07'),('2038-01-19 04:44:08'); Warnings: -Warning 1264 Out of range value adjusted for column 'ts' at row 2 -Warning 1264 Out of range value adjusted for column 'ts' at row 3 -Warning 1264 Out of range value adjusted for column 'ts' at row 6 +Warning 1264 Out of range value for column 'ts' at row 2 +Warning 1264 Out of range value for column 'ts' at row 3 +Warning 1264 Out of range value for column 'ts' at row 6 select * from t1; ts 0000-00-00 00:00:00 |