diff options
author | Oleksandr Byelkin <sanja@mariadb.com> | 2017-04-25 16:30:39 +0200 |
---|---|---|
committer | Oleksandr Byelkin <sanja@mariadb.com> | 2017-04-25 16:30:39 +0200 |
commit | 49552cf1f7adb3f3b7bb53696cc178363e4d9cb2 (patch) | |
tree | 1f8fe7b3b30e6d3a1bce69913d144200e8ab272a /mysql-test/r/subselect_innodb.result | |
parent | 57fea99eeb80829828d43a048d31c46c30684738 (diff) | |
parent | 2e7ba70a94b5950a7d1d733c177d1b2a24916213 (diff) | |
download | mariadb-git-49552cf1f7adb3f3b7bb53696cc178363e4d9cb2.tar.gz |
Merge branch '5.5' into bb-10.0-merge-5.5bb-10.0-merge-5.5
Diffstat (limited to 'mysql-test/r/subselect_innodb.result')
-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 be666547f26..15f1d6377e3 100644 --- a/mysql-test/r/subselect_innodb.result +++ b/mysql-test/r/subselect_innodb.result @@ -511,6 +511,20 @@ 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; +# # MDEV-6041: ORDER BY+subqueries: subquery_table.key=outer_table.col is not recongized as binding # create table t1(a int) engine=innodb; |