diff options
Diffstat (limited to 'mysql-test/r/old-mode.result')
| -rw-r--r-- | mysql-test/r/old-mode.result | 26 |
1 files changed, 16 insertions, 10 deletions
diff --git a/mysql-test/r/old-mode.result b/mysql-test/r/old-mode.result index c2ee3324ede..d4844ec640c 100644 --- a/mysql-test/r/old-mode.result +++ b/mysql-test/r/old-mode.result @@ -30,30 +30,34 @@ Warnings: Warning 1292 Truncated incorrect datetime value: '-10:30:30' SELECT CAST(TIME'10:20:30' AS DATETIME); CAST(TIME'10:20:30' AS DATETIME) -0000-00-00 10:20:30 +NULL +Warnings: +Warning 1292 Truncated incorrect datetime value: '10:20:30' SELECT CAST(TIME'830:20:30' AS DATETIME); CAST(TIME'830:20:30' AS DATETIME) 0000-01-03 14:20:30 CREATE TABLE t1 (a DATETIME); -INSERT INTO t1 VALUES (TIME'-10:20:30'); +INSERT IGNORE INTO t1 VALUES (TIME'-10:20:30'); +Warnings: +Warning 1265 Data truncated for column 'a' at row 1 +INSERT IGNORE INTO t1 VALUES (TIME'10:20:30'); Warnings: Warning 1265 Data truncated for column 'a' at row 1 -INSERT INTO t1 VALUES (TIME'10:20:30'); INSERT INTO t1 VALUES (TIME'830:20:30'); SELECT * FROM t1; a 0000-00-00 00:00:00 -0000-00-00 10:20:30 +0000-00-00 00:00:00 0000-01-03 14:20:30 DROP TABLE t1; CREATE TABLE t1 (a TIMESTAMP); -INSERT INTO t1 VALUES (TIME'-10:20:30'); +INSERT IGNORE INTO t1 VALUES (TIME'-10:20:30'); Warnings: Warning 1265 Data truncated for column 'a' at row 1 -INSERT INTO t1 VALUES (TIME'10:20:30'); +INSERT IGNORE INTO t1 VALUES (TIME'10:20:30'); Warnings: Warning 1265 Data truncated for column 'a' at row 1 -INSERT INTO t1 VALUES (TIME'830:20:30'); +INSERT IGNORE INTO t1 VALUES (TIME'830:20:30'); Warnings: Warning 1264 Out of range value for column 'a' at row 1 SELECT * FROM t1; @@ -69,13 +73,15 @@ INSERT INTO t1 VALUES (TIME'830:20:30'); SELECT a, CAST(a AS DATETIME), TO_DAYS(a) FROM t1; a CAST(a AS DATETIME) TO_DAYS(a) -10:20:30 NULL NULL -10:20:30 0000-00-00 10:20:30 NULL -830:20:30 0000-01-03 14:20:30 NULL +10:20:30 NULL NULL +830:20:30 NULL NULL Warnings: -Warning 1292 Truncated incorrect datetime value: '-10:20:30' Warning 1264 Out of range value for column 'a' at row 1 +Warning 1264 Out of range value for column 'a' at row 1 +Warning 1264 Out of range value for column 'a' at row 2 Warning 1264 Out of range value for column 'a' at row 2 Warning 1264 Out of range value for column 'a' at row 3 +Warning 1264 Out of range value for column 'a' at row 3 DROP TABLE t1; SELECT TO_DAYS(TIME'-10:20:30'); TO_DAYS(TIME'-10:20:30') |