summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_str.result
diff options
context:
space:
mode:
authorunknown <sanja@askmonty.org>2014-06-04 13:03:55 +0300
committerunknown <sanja@askmonty.org>2014-06-04 13:03:55 +0300
commit113333d44725fe35a5eb52c7df58140e1cce45f8 (patch)
tree39712e607c3b3cd247950886e6e74c3df565053e /mysql-test/r/func_str.result
parent67bf16a48b7e12090e0c02aeafdac0e08c95ea78 (diff)
downloadmariadb-git-113333d44725fe35a5eb52c7df58140e1cce45f8.tar.gz
MDEV-6046: MySQL Bug#11766684 59851: UNINITIALISED VALUE IN ITEM_FUNC_LIKE::SELECT_OPTIMIZE WITH SUBQUERY AND
Diffstat (limited to 'mysql-test/r/func_str.result')
-rw-r--r--mysql-test/r/func_str.result11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result
index 2f820dfc0a9..e5edabb0130 100644
--- a/mysql-test/r/func_str.result
+++ b/mysql-test/r/func_str.result
@@ -2658,6 +2658,17 @@ group_concat( i ) field
NULL NULL
8
drop table t1;
+#
+# Bug#11766684 59851: UNINITIALISED VALUE IN ITEM_FUNC_LIKE::SELECT_OPTIMIZE WITH SUBQUERY AND
+#
+CREATE TABLE t2(a INT, KEY(a));
+INSERT INTO t2 VALUES (1),(2);
+CREATE TABLE t1(b INT, PRIMARY KEY(b));
+INSERT INTO t1 VALUES (0),(254);
+SELECT 1 FROM t2 WHERE a LIKE
+(SELECT EXPORT_SET(1, b, b, b, b) FROM t1 LIMIT 1);
+1
+DROP TABLE t1, t2;
End of 5.1 tests
#
# Start of 5.3 tests