diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2011-03-17 18:19:47 +0100 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2011-03-17 18:19:47 +0100 |
| commit | ddb7d04d6e6352d3a4871cdf25aeefc89cb511a5 (patch) | |
| tree | 1f89523b951f2f1936d11f474adfe9e36d167922 /mysql-test/t/func_time.test | |
| parent | b37d333e389d64e236f29b85f7d5c8ef4c3a9e54 (diff) | |
| download | mariadb-git-ddb7d04d6e6352d3a4871cdf25aeefc89cb511a5.tar.gz | |
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.
Diffstat (limited to 'mysql-test/t/func_time.test')
| -rw-r--r-- | mysql-test/t/func_time.test | 2 |
1 files changed, 1 insertions, 1 deletions
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; # |