diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2018-07-26 08:54:44 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2018-07-26 09:19:52 +0300 |
| commit | 93b6552182740d1a66cf41c30811e7275d31b07f (patch) | |
| tree | 96341a5a841bfd6b53981b9b96b1cd5ef6e7f3d5 /mysql-test/main/subselect.test | |
| parent | 294a426088bd7167f42388e7e76ff8d42df7d6be (diff) | |
| parent | 0f90728bc0f8bc946a61500801b23f8a316e73d5 (diff) | |
| download | mariadb-git-93b6552182740d1a66cf41c30811e7275d31b07f.tar.gz | |
Merge 10.2 into 10.3
Diffstat (limited to 'mysql-test/main/subselect.test')
| -rw-r--r-- | mysql-test/main/subselect.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/main/subselect.test b/mysql-test/main/subselect.test index c5cec99cebf..189dde382dd 100644 --- a/mysql-test/main/subselect.test +++ b/mysql-test/main/subselect.test @@ -6104,6 +6104,21 @@ and t1.a in (select `test`.`t3`.`c` from `test`.`t3`); SET @@optimizer_switch= @optimiser_switch_save; DROP TABLE t1, t2, t3; +--echo # +--echo # MDEV-16820: impossible where with inexpensive subquery +--echo # + +create table t1 (a int) engine=myisam; +insert into t1 values (3), (1), (7); + +create table t2 (b int, index idx(b)); +insert into t2 values (2), (5), (3), (2); + +explain select * from t1 where (select max(b) from t2) = 10; +explain select * from t1 where (select max(b) from t2) = 10 and t1.a > 3; + +drop table t1,t2; + --echo End of 5.5 tests --echo # End of 10.0 tests |