diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2018-03-23 17:40:53 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2018-03-23 17:40:53 +0100 |
| commit | febe1e850342ea52ce0900ba5767852b0aa42dc7 (patch) | |
| tree | af188bde7aff4951c9f845a5c22912222b6ca888 /mysql-test/r/subselect4.result | |
| parent | d3681c18f96ebf9b66c7541459b2eb34a4827734 (diff) | |
| parent | a2e47f8c41e60fb0eeaa01cdd41fc07b9c963768 (diff) | |
| download | mariadb-git-febe1e850342ea52ce0900ba5767852b0aa42dc7.tar.gz | |
Merge branch '10.0' into 10.1
Diffstat (limited to 'mysql-test/r/subselect4.result')
| -rw-r--r-- | mysql-test/r/subselect4.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/subselect4.result b/mysql-test/r/subselect4.result index 4e70615120f..2ae8ff3ba1b 100644 --- a/mysql-test/r/subselect4.result +++ b/mysql-test/r/subselect4.result @@ -2489,6 +2489,17 @@ FROM t2 WHERE b <= 'quux' GROUP BY field; field COUNT(DISTINCT c) 0 1 drop table t1,t2; +# +# MDEV-15555: select from DUAL where false yielding wrong result when in a IN +# +explain +SELECT 2 IN (SELECT 2 from DUAL WHERE 1 != 1); +id select_type table type possible_keys key key_len ref rows Extra +1 PRIMARY NULL NULL NULL NULL NULL NULL NULL No tables used +2 SUBQUERY NULL NULL NULL NULL NULL NULL NULL Impossible WHERE +SELECT 2 IN (SELECT 2 from DUAL WHERE 1 != 1); +2 IN (SELECT 2 from DUAL WHERE 1 != 1) +0 SET optimizer_switch= @@global.optimizer_switch; set @@tmp_table_size= @@global.tmp_table_size; # |