summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_like.result
diff options
context:
space:
mode:
authorRamil Kalimullin <ramil@mysql.com>2010-06-24 15:29:53 +0400
committerRamil Kalimullin <ramil@mysql.com>2010-06-24 15:29:53 +0400
commita23729ad385b940f52d35e6074a5e2a2e7250996 (patch)
treed8fb0bddfcc57680aab7f6b55f99bc800b5521c0 /mysql-test/r/func_like.result
parent1970da07168afc7fb5e1500614dae0391bc67bd8 (diff)
parentf4420a3b90e57c68cc72606b4ecb240266260861 (diff)
downloadmariadb-git-a23729ad385b940f52d35e6074a5e2a2e7250996.tar.gz
Automerge.
Diffstat (limited to 'mysql-test/r/func_like.result')
-rw-r--r--mysql-test/r/func_like.result14
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/func_like.result b/mysql-test/r/func_like.result
index 8d0f34f3bda..552ff564a89 100644
--- a/mysql-test/r/func_like.result
+++ b/mysql-test/r/func_like.result
@@ -169,3 +169,17 @@ select 'andre%' like 'andreÊ%' escape 'Ê';
select _cp1251'andre%' like convert('andreÊ%' using cp1251) escape 'Ê';
_cp1251'andre%' like convert('andreÊ%' using cp1251) escape 'Ê'
1
+End of 4.1 tests
+#
+# Bug #54575: crash when joining tables with unique set column
+#
+CREATE TABLE t1(a SET('a') NOT NULL, UNIQUE KEY(a));
+CREATE TABLE t2(b INT PRIMARY KEY);
+INSERT INTO t1 VALUES ();
+Warnings:
+Warning 1364 Field 'a' doesn't have a default value
+INSERT INTO t2 VALUES (1), (2), (3);
+SELECT 1 FROM t2 JOIN t1 ON 1 LIKE a GROUP BY a;
+1
+DROP TABLE t1, t2;
+End of 5.1 tests