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/t/old-mode.test | |
| 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/t/old-mode.test')
| -rw-r--r-- | mysql-test/t/old-mode.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/old-mode.test b/mysql-test/t/old-mode.test index 483549886db..c2a43f91ecb 100644 --- a/mysql-test/t/old-mode.test +++ b/mysql-test/t/old-mode.test @@ -64,3 +64,12 @@ INSERT INTO t1 VALUES (NULL, '00:20:12'); INSERT INTO t1 VALUES (NULL, '-00:20:12'); SELECT IF(1,ADDDATE(IFNULL(a,b),0),1) FROM t1; DROP TABLE t1; + +--echo # +--echo # MDEV-6649 Different warnings for TIME and TIME(N) when @@old_mode=zero_date_time_cast +--echo # +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; +DROP TABLE t1; |