diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2013-03-17 11:41:25 +0100 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2013-03-17 11:41:25 +0100 |
| commit | 495fd27c0e3781013904666f302a3d3e4f011e50 (patch) | |
| tree | 53422be325dfde77ac5b01cdc5929bbd701d6638 /mysql-test/r/func_date_add.result | |
| parent | ecd4bf62d439b300facb4d5758c4670e6c96b7c5 (diff) | |
| download | mariadb-git-495fd27c0e3781013904666f302a3d3e4f011e50.tar.gz | |
MDEV-4284 Assertion `cmp_items[(uint)cmp_type]' fails in sql/item_cmpfunc.cc
Flip the switch and create Item_cache based on the argument's cmp_type, not argument's result_type().
Fix subselect_engine to calculate cmp_type correctly
sql/item_subselect.h:
mdev:4284
Diffstat (limited to 'mysql-test/r/func_date_add.result')
| -rw-r--r-- | mysql-test/r/func_date_add.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/func_date_add.result b/mysql-test/r/func_date_add.result index a7f2383848d..e8fbba786a4 100644 --- a/mysql-test/r/func_date_add.result +++ b/mysql-test/r/func_date_add.result @@ -96,3 +96,9 @@ b + interval a day 2002-02-04 drop table t1; End of 5.0 tests +create table t1 (a varchar(10)); +insert t1 values ('2000-12-03'),('2008-05-03'); +select * from t1 where case a when adddate( '2012-12-12', 7 ) then true end; +a +drop table t1; +End of 5.5 tests |