summaryrefslogtreecommitdiff
path: root/mysql-test/r/subselect_sj_mat.result
diff options
context:
space:
mode:
authorSergei Golubchik <sergii@pisem.net>2012-02-21 20:51:56 +0100
committerSergei Golubchik <sergii@pisem.net>2012-02-21 20:51:56 +0100
commitedab37cd680ebcca999d989c34251f6be1115c54 (patch)
tree9a960e6324916997d8efa87ce8d48d099d78cab8 /mysql-test/r/subselect_sj_mat.result
parent5bf311e1e853457c31dbadd3d130b2569a867d80 (diff)
parent446554a15bd84f39ec4a8163e9f4456fa9be8fb2 (diff)
downloadmariadb-git-edab37cd680ebcca999d989c34251f6be1115c54.tar.gz
5.3 merge
Diffstat (limited to 'mysql-test/r/subselect_sj_mat.result')
-rw-r--r--mysql-test/r/subselect_sj_mat.result13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_sj_mat.result b/mysql-test/r/subselect_sj_mat.result
index b3a205eb071..e3c5926ffee 100644
--- a/mysql-test/r/subselect_sj_mat.result
+++ b/mysql-test/r/subselect_sj_mat.result
@@ -1885,6 +1885,19 @@ a b
7 5
3 3
drop table t1,t2;
+#
+# BUG#933407: Valgrind warnings in mark_as_null_row with materialization+semijoin, STRAIGHT_JOIN, impossible WHERE
+#
+CREATE TABLE t1 (a INT);
+INSERT INTO t1 VALUES (0),(8);
+SELECT STRAIGHT_JOIN MIN(a) FROM t1
+WHERE a IN (
+SELECT a FROM t1
+WHERE 'condition'='impossible'
+ );
+MIN(a)
+NULL
+DROP TABLE t1;
# This must be at the end:
set optimizer_switch=@subselect_sj_mat_tmp;
set join_cache_level=@save_join_cache_level;