summaryrefslogtreecommitdiff
path: root/mysql-test/r/old-mode.result
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.org>2014-06-06 10:29:52 +0400
committerAlexander Barkov <bar@mariadb.org>2014-06-06 10:29:52 +0400
commit216fbe2af3c8dc81f492af79dee61d6a3d333678 (patch)
tree8fc7a2b00b5fe229d79d2b4216d236debd201fa1 /mysql-test/r/old-mode.result
parentd8edb88cb15c3341a7686eb5909dde6deac16674 (diff)
downloadmariadb-git-216fbe2af3c8dc81f492af79dee61d6a3d333678.tar.gz
MDEV-6102 Comparison between TIME and DATETIME does not use CURRENT_DATE
MDEV-6101 Hybrid functions do not add CURRENT_DATE when converting TIME to DATETIME
Diffstat (limited to 'mysql-test/r/old-mode.result')
-rw-r--r--mysql-test/r/old-mode.result3
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/r/old-mode.result b/mysql-test/r/old-mode.result
index b7e1ee26391..7f3339e7ce4 100644
--- a/mysql-test/r/old-mode.result
+++ b/mysql-test/r/old-mode.result
@@ -95,8 +95,9 @@ 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;
IF(1,ADDDATE(IFNULL(a,b),0),1)
-0000-00-00 00:20:12
+NULL
NULL
Warnings:
+Warning 1292 Incorrect datetime value: '0000-00-00 00:20:12'
Warning 1292 Truncated incorrect datetime value: '-00:20:12'
DROP TABLE t1;