diff options
| author | Alexander Barkov <bar@mariadb.org> | 2014-11-03 21:45:06 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2014-11-03 21:45:06 +0400 |
| commit | 43f185e171eecdce41e71c548ce0bc2bd6969c0f (patch) | |
| tree | ef2a7c8ea219bb66aeb1532eedfae9268f9f3ae1 /mysql-test/r/old-mode.result | |
| parent | a245543bc8821b15409b839197d911302fb5bfb0 (diff) | |
| download | mariadb-git-43f185e171eecdce41e71c548ce0bc2bd6969c0f.tar.gz | |
MDEV-5528 Command line variable to choose MariaDB-5.3 vs MySQL-5.6 temporal data formats
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 4f650c3c781..c2ee3324ede 100644 --- a/mysql-test/r/old-mode.result +++ b/mysql-test/r/old-mode.result @@ -104,6 +104,7 @@ DROP TABLE t1; # # MDEV-6649 Different warnings for TIME and TIME(N) when @@old_mode=zero_date_time_cast # +SET @@global.mysql56_temporal_format=true; 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'); @@ -114,3 +115,15 @@ 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; +SET @@global.mysql56_temporal_format=false; +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; +SET @@global.mysql56_temporal_format=DEFAULT; |