diff options
Diffstat (limited to 'mysql-test/t/subselect_sj_mat.test')
| -rw-r--r-- | mysql-test/t/subselect_sj_mat.test | 34 |
1 files changed, 32 insertions, 2 deletions
diff --git a/mysql-test/t/subselect_sj_mat.test b/mysql-test/t/subselect_sj_mat.test index 2ba075a047d..ef4a40172e2 100644 --- a/mysql-test/t/subselect_sj_mat.test +++ b/mysql-test/t/subselect_sj_mat.test @@ -1349,8 +1349,6 @@ WHERE t2.a = ALL ( DROP TABLE t2,t3,t4,t5; -set optimizer_switch=@subselect_sj_mat_tmp; - --echo # --echo # BUG#860300: Second crash with get_fanout_with_deps() with semijoin + materialization --echo # @@ -1399,3 +1397,35 @@ SELECT * FROM t4; DROP TABLE t1, t2, t3, t4; set optimizer_switch=@tmp_860535; +--echo # +--echo # BUG#860553: Crash in create_ref_for_key with semijoin + materialization +--echo # +CREATE TABLE t1 (f1 int) ; +CREATE TABLE t2 (f5 varchar(52) NOT NULL) ; + +CREATE TABLE t3 (f1 varchar(3), f4 varchar(52) , KEY (f4), PRIMARY KEY (f1)); + +CREATE TABLE t4 (f3 int, KEY (f3)); +INSERT INTO t4 VALUES (17),(20); + +CREATE TABLE t5 (f2 int); +INSERT INTO t5 VALUES (0),(0); + +SELECT * +FROM t1 +JOIN t2 +ON ( t2.f5 ) IN ( + SELECT t3.f4 + FROM t3 + WHERE ( 1 ) IN ( + SELECT t4.f3 + FROM t4 , t5 + ) +); + +DROP TABLE t1, t2, t3, t4, t5; + + +--echo # This must be at the end: +set optimizer_switch=@subselect_sj_mat_tmp; + |