From ddb7d04d6e6352d3a4871cdf25aeefc89cb511a5 Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Thu, 17 Mar 2011 18:19:47 +0100 Subject: lp:736370 Datetime functions in subquery context cause wrong result and bogus warnings in mysql-5.1-micro Don't cache temporal value in an Item_string, it is compared differently. --- mysql-test/t/func_time.test | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'mysql-test/t/func_time.test') diff --git a/mysql-test/t/func_time.test b/mysql-test/t/func_time.test index 646b55ad25a..669da515e49 100644 --- a/mysql-test/t/func_time.test +++ b/mysql-test/t/func_time.test @@ -922,7 +922,7 @@ select convert_tz(timediff('0000-00-00 00:00:00', cast('2008-03-26 07:09:06' as # create table t1 (f1 integer, f2 date); insert into t1 values (1,'2011-05-05'),(2,'2011-05-05'),(3,'2011-05-05'),(4,'2011-05-05'),(5,'2011-05-05'); -select * from t1 where (f1, f2) in (select f1, makedate(2011 , 125) from t1); +select * from t1 where 1 and concat(f2)=MAKEDATE(2011, 125); drop table t1; # -- cgit v1.2.1