diff options
Diffstat (limited to 'mysql-test/main/timezone2.result')
| -rw-r--r-- | mysql-test/main/timezone2.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/main/timezone2.result b/mysql-test/main/timezone2.result index 31b17fbc0d9..72dbd5ed990 100644 --- a/mysql-test/main/timezone2.result +++ b/mysql-test/main/timezone2.result @@ -120,7 +120,7 @@ insert into t1 values ('0000-00-00 00:00:00'),('1969-12-31 23:59:59'), Warnings: 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 +Warning 1292 Truncated incorrect timestamp value: '2038-01-19 03:14:08' select * from t1; ts 0000-00-00 00:00:00 @@ -128,7 +128,7 @@ ts 0000-00-00 00:00:00 1970-01-01 00:00:01 2038-01-19 03:14:07 -0000-00-00 00:00:00 +2038-01-19 03:14:07 truncate table t1; set time_zone='MET'; insert into t1 values ('0000-00-00 00:00:00'),('1970-01-01 00:30:00'), @@ -137,7 +137,7 @@ insert into t1 values ('0000-00-00 00:00:00'),('1970-01-01 00:30:00'), Warnings: 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 +Warning 1292 Truncated incorrect timestamp value: '2038-01-19 04:14:08' select * from t1; ts 0000-00-00 00:00:00 @@ -145,7 +145,7 @@ ts 0000-00-00 00:00:00 1970-01-01 01:00:01 2038-01-19 04:14:07 -0000-00-00 00:00:00 +2038-01-19 04:14:07 truncate table t1; set time_zone='+01:30'; insert into t1 values ('0000-00-00 00:00:00'),('1970-01-01 01:00:00'), @@ -154,7 +154,7 @@ insert into t1 values ('0000-00-00 00:00:00'),('1970-01-01 01:00:00'), Warnings: 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 +Warning 1292 Truncated incorrect timestamp value: '2038-01-19 04:44:08' select * from t1; ts 0000-00-00 00:00:00 @@ -162,7 +162,7 @@ ts 0000-00-00 00:00:00 1970-01-01 01:30:01 2038-01-19 04:44:07 -0000-00-00 00:00:00 +2038-01-19 04:44:07 drop table t1; show variables like 'time_zone'; Variable_name Value |