summaryrefslogtreecommitdiff
path: root/mysql-test/t/case.test
diff options
context:
space:
mode:
authorunknown <sanja@montyprogram.com>2012-06-21 18:47:13 +0300
committerunknown <sanja@montyprogram.com>2012-06-21 18:47:13 +0300
commit60561ae6133cf40f4fc445e1d6e8f395a20b2573 (patch)
treeb45c0166a329abe7f84e6b036e9953fa446e18f3 /mysql-test/t/case.test
parentd9c3a3e39e4c5a6f060b7bbc1646ca74c123fbab (diff)
downloadmariadb-git-60561ae6133cf40f4fc445e1d6e8f395a20b2573.tar.gz
Fix for LP bug#1001505 and LP bug#1001510
We set correct cmp_context during preparation to avoid changing it later by Item_field::equal_fields_propagator. (see mysql bugs #57135 #57692 during merging)
Diffstat (limited to 'mysql-test/t/case.test')
-rw-r--r--mysql-test/t/case.test10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/case.test b/mysql-test/t/case.test
index 028c64d6de7..81855dfc97f 100644
--- a/mysql-test/t/case.test
+++ b/mysql-test/t/case.test
@@ -170,3 +170,13 @@ select t1.a, (case t1.a when 0 then 0 else t1.b end) d from t1
drop table t1, t2;
--echo End of 5.0 tests
+
+#
+# LP BUG#1001510
+# Bug #11764313 57135: CRASH IN ITEM_FUNC_CASE::FIND_ITEM WITH CASE WHEN
+# ELSE CLAUSE
+#
+
+CREATE TABLE t1(a YEAR);
+SELECT 1 FROM t1 WHERE a=1 AND CASE 1 WHEN a THEN 1 ELSE 1 END;
+DROP TABLE t1;