diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2011-09-07 20:39:47 +0200 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2011-09-07 20:39:47 +0200 |
| commit | 3e97aeafd65b2b05a7a33ba21420bfa85208e820 (patch) | |
| tree | 4d8570144b981d437cce7422c0ef8e2316b404fa /mysql-test/t/join.test | |
| parent | ee66fbb40275fd1b97cdee2fac7fb5c784e054c3 (diff) | |
| download | mariadb-git-3e97aeafd65b2b05a7a33ba21420bfa85208e820.tar.gz | |
lp:839387 Assertion `(Item_result)i != TIME_RESULT' failed with CASE + datetime
remove incorrect DBUG_ASSERT().
Fix incorrectly used cmp_item::get_comparator() in Item_func_case and Item_equal
Diffstat (limited to 'mysql-test/t/join.test')
| -rw-r--r-- | mysql-test/t/join.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/join.test b/mysql-test/t/join.test index c4f2b6cb61f..82e67904e9f 100644 --- a/mysql-test/t/join.test +++ b/mysql-test/t/join.test @@ -1015,3 +1015,13 @@ SELECT STRAIGHT_JOIN * FROM t1 JOIN t2 ON t2.f2 = t1.f1 DROP TABLE t1,t2; +# +# Item_equal used cmp_item::get_comparator() incorrectly +# +create table t1 (i time key); +insert into t1 values ('1:1:1'), ('2:2:2'); +create table t2 (i time); +insert into t2 values ('1:1:1'); +select t2.i from t1 left join t2 on t2.i = t1.i where t1.i = '1:1:1'; +drop table t1,t2; + |