diff options
author | Sergei Golubchik <sergii@pisem.net> | 2012-02-21 20:51:56 +0100 |
---|---|---|
committer | Sergei Golubchik <sergii@pisem.net> | 2012-02-21 20:51:56 +0100 |
commit | edab37cd680ebcca999d989c34251f6be1115c54 (patch) | |
tree | 9a960e6324916997d8efa87ce8d48d099d78cab8 /mysql-test/r/subselect_sj_mat.result | |
parent | 5bf311e1e853457c31dbadd3d130b2569a867d80 (diff) | |
parent | 446554a15bd84f39ec4a8163e9f4456fa9be8fb2 (diff) | |
download | mariadb-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.result | 13 |
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; |