diff options
| author | Alexander Barkov <bar@mariadb.org> | 2014-11-03 19:05:16 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2014-11-03 19:05:16 +0400 |
| commit | a245543bc8821b15409b839197d911302fb5bfb0 (patch) | |
| tree | 94dfc087f1a0f6462742d2cabb42ccdfc6caef2c /mysql-test/r/old-mode.result | |
| parent | cb37c557688e2f7f0381d02f78976a1b7d1bfd65 (diff) | |
| download | mariadb-git-a245543bc8821b15409b839197d911302fb5bfb0.tar.gz | |
MDEV-6649 Different warnings for TIME and TIME(N) when @@old_mode=zero_date_time_cast
Merging from 10.0 (pre-requisite for MDEV-5528)
Diffstat (limited to 'mysql-test/r/old-mode.result')
| -rw-r--r-- | mysql-test/r/old-mode.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/old-mode.result b/mysql-test/r/old-mode.result index 7f3339e7ce4..4f650c3c781 100644 --- a/mysql-test/r/old-mode.result +++ b/mysql-test/r/old-mode.result @@ -101,3 +101,16 @@ Warnings: Warning 1292 Incorrect datetime value: '0000-00-00 00:20:12' Warning 1292 Truncated incorrect datetime value: '-00:20:12' DROP TABLE t1; +# +# MDEV-6649 Different warnings for TIME and TIME(N) when @@old_mode=zero_date_time_cast +# +SET @@old_mode=zero_date_time_cast; +CREATE TABLE t1 (a TIME,b TIME(1)); +INSERT INTO t1 VALUES (TIME'830:20:30',TIME'830:20:30'); +SELECT TO_DAYS(a), TO_DAYS(b) FROM t1; +TO_DAYS(a) TO_DAYS(b) +NULL NULL +Warnings: +Warning 1264 Out of range value for column 'a' at row 1 +Warning 1264 Out of range value for column 'b' at row 1 +DROP TABLE t1; |