diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2012-03-21 11:18:20 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2012-03-21 11:18:20 +0400 |
| commit | 1153d656a99d5b927e4308653d81bb7ef1a7ad46 (patch) | |
| tree | b339f4be461f1fdd9867a830a1484ce0f97ae24d /mysql-test/r/subselect_sj.result | |
| parent | 357331af8a450dfc975575e99c640b8f6893360b (diff) | |
| parent | 5805908bf98b1de5c1fefed4778dcc22bb70c6fd (diff) | |
| download | mariadb-git-1153d656a99d5b927e4308653d81bb7ef1a7ad46.tar.gz | |
Merge BUG#952372
Diffstat (limited to 'mysql-test/r/subselect_sj.result')
| -rw-r--r-- | mysql-test/r/subselect_sj.result | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_sj.result b/mysql-test/r/subselect_sj.result index 96ddb12521b..d17af2ae092 100644 --- a/mysql-test/r/subselect_sj.result +++ b/mysql-test/r/subselect_sj.result @@ -2639,4 +2639,26 @@ INSERT INTO t1 SELECT * FROM ( SELECT * FROM t1 ) AS alias WHERE a IN ( SELECT b FROM t2 ); DROP TABLE t1, t2; +# +# BUG#952372: Server crashes on 2nd execution of PS in find_field_in_tables with semijoin+materialization +# +CREATE TABLE t1 ( a INT ); +INSERT INTO t1 VALUES (2),(3); +CREATE VIEW v1 AS SELECT * FROM t1; +CREATE TABLE t2 ( b VARCHAR(1) ); +INSERT INTO t2 VALUES ('v'),('v'); +PREPARE pstmt FROM +'SELECT DISTINCT a FROM v1, t2 + WHERE b IN ( SELECT MIN(b) FROM t2 )'; +EXECUTE pstmt; +a +2 +3 +EXECUTE pstmt; +a +2 +3 +DEALLOCATE PREPARE pstmt; +DROP VIEW v1; +DROP TABLE t1, t2; set optimizer_switch=@subselect_sj_tmp; |