From 216fbe2af3c8dc81f492af79dee61d6a3d333678 Mon Sep 17 00:00:00 2001 From: Alexander Barkov Date: Fri, 6 Jun 2014 10:29:52 +0400 Subject: 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 --- mysql-test/r/old-mode.result | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'mysql-test/r/old-mode.result') 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; -- cgit v1.2.1