diff options
| author | Sachin Setiya <sachin.setiya@mariadb.com> | 2017-05-03 10:16:15 +0530 |
|---|---|---|
| committer | Sachin Setiya <sachin.setiya@mariadb.com> | 2017-05-03 10:16:15 +0530 |
| commit | 1c142800486f58653aac007b0873d8c1aa712960 (patch) | |
| tree | 512bb39b1227ca564ab77b4f085c7f9e541b26ba /mysql-test/r | |
| parent | f359f664e9e4de804ffd33e222d00c6140655452 (diff) | |
| parent | dbe2c3c5f21fd479fbe0993b045c0c30493ca07a (diff) | |
| download | mariadb-git-1c142800486f58653aac007b0873d8c1aa712960.tar.gz | |
Merge tag 'mariadb-5.5.56' into 5.5-galera
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/subselect_innodb.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_innodb.result b/mysql-test/r/subselect_innodb.result index 06cfb8b45d2..f92615f22cf 100644 --- a/mysql-test/r/subselect_innodb.result +++ b/mysql-test/r/subselect_innodb.result @@ -469,3 +469,17 @@ f1 f2 set join_cache_level = default; drop view v1; drop table t1,t2; +# +# MDEV-10693: cost-based choice between materialization and in-to-exists +# for a subquery from the expression used in ref access +# +CREATE TABLE t1 (i1 INT PRIMARY KEY) ENGINE=InnoDB; +INSERT INTO t1 VALUES (1),(2); +CREATE TABLE t2 (i2 INT) ENGINE=InnoDB; +CREATE TABLE t3 (i3 INT PRIMARY KEY) ENGINE=InnoDB; +INSERT INTO t3 VALUES (3); +SELECT * FROM t1 +WHERE NULL IN ( SELECT i2 FROM t2 +WHERE i1 IN ( i2 IN ( SELECT i3 FROM t3 ) ) AND i2 = 2 ); +i1 +DROP TABLE t1,t2,t3; |