diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-10-20 08:02:31 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-10-20 08:02:31 -0700 |
| commit | b117a3c453a9a8a67906aa2bb06648c213a85b35 (patch) | |
| tree | b1f98a256e21b36ad667dc586f0bfc178cad1a92 /mysql-test/t/derived_view.test | |
| parent | e7a7e2a036ada1f3b9715fc6e889dbc29768feea (diff) | |
| download | mariadb-git-b117a3c453a9a8a67906aa2bb06648c213a85b35.tar.gz | |
Added a test case for LP bug #873263 fixed by the patch for bug 874006.
Diffstat (limited to 'mysql-test/t/derived_view.test')
| -rw-r--r-- | mysql-test/t/derived_view.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/t/derived_view.test b/mysql-test/t/derived_view.test index d6ec40670af..ff7491b38fb 100644 --- a/mysql-test/t/derived_view.test +++ b/mysql-test/t/derived_view.test @@ -947,6 +947,26 @@ DROP VIEW v1; DROP TABLE t1,t2,t3; --echo # +--echo # LP bug #873263: materialized view used in correlated IN subquery +--echo # + +CREATE TABLE t1 (a int, b int) ; +INSERT INTO t1 VALUES (5,4), (9,8); + +CREATE TABLE t2 (a int, b int) ; +INSERT INTO t2 VALUES (4,5), (5,1); + +CREATE ALGORITHM=TEMPTABLE VIEW v2 AS SELECT * FROM t2; + +SET SESSION optimizer_switch='derived_with_keys=on'; +EXPLAIN +SELECT * FROM t1 WHERE t1.b IN (SELECT v2.a FROM v2 WHERE v2.b = t1.a); +SELECT * FROM t1 WHERE t1.b IN (SELECT v2.a FROM v2 WHERE v2.b = t1.a); + +DROP VIEW v2; +DROP TABLE t1,t2; + +--echo # --echo # LP bug #877316: query over a view with correlated subquery in WHERE --echo # |