diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2014-03-25 11:09:12 +0100 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2014-03-25 11:09:12 +0100 |
| commit | 21a17536c6aa440ff86705e9f99f9dded0c70e64 (patch) | |
| tree | 4258e38f6a651b4e51b022b1bd72b791968f395e /mysql-test/t/subselect_sj_mat.test | |
| parent | 434bbc34ad1a4307d596907a08e5eca9cb996107 (diff) | |
| parent | 63d0918807739dd19578ce9db80acbfd8ea158e6 (diff) | |
| download | mariadb-git-21a17536c6aa440ff86705e9f99f9dded0c70e64.tar.gz | |
5.3 merge
Diffstat (limited to 'mysql-test/t/subselect_sj_mat.test')
| -rw-r--r-- | mysql-test/t/subselect_sj_mat.test | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/t/subselect_sj_mat.test b/mysql-test/t/subselect_sj_mat.test index 52a73d24822..91b69a6a09c 100644 --- a/mysql-test/t/subselect_sj_mat.test +++ b/mysql-test/t/subselect_sj_mat.test @@ -1745,6 +1745,24 @@ EXECUTE stmt; DROP TABLE t1, t2; DROP VIEW v2; +--echo # +--echo # MDEV-5811: Server crashes in best_access_path with materialization+semijoin and big_tables=ON +--echo # +SET @tmp_mdev5811= @@big_tables; +SET big_tables = ON; + +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES (1),(2); + +CREATE TABLE t2 (b INT); +INSERT INTO t2 VALUES (3),(4); + +SELECT * FROM t1 AS t1_1, t1 AS t1_2 + WHERE ( t1_1.a, t1_2.a ) IN ( SELECT MAX(b), MIN(b) FROM t2 ); + +DROP TABLE t1,t2; +SET big_tables=@tmp_mdev5811; + --echo # End of 5.3 tests |