diff options
author | Oleksandr Byelkin <sanja@mariadb.com> | 2017-03-14 11:52:00 +0100 |
---|---|---|
committer | Oleksandr Byelkin <sanja@mariadb.com> | 2017-03-14 11:52:00 +0100 |
commit | 05d3c3d3f748f74bbd12924d090f882c5c928249 (patch) | |
tree | d15b528bced3ab5b1ce86ea0569eeba2efe67115 /mysql-test/r/having.result | |
parent | e43156e1a679c95413aab2c4bf9523da7947fc18 (diff) | |
download | mariadb-git-05d3c3d3f748f74bbd12924d090f882c5c928249.tar.gz |
MDEV-10141: Add support for INTERSECT (and common parts for EXCEPT)
MDEV-10140: Add support for EXCEPT
Diffstat (limited to 'mysql-test/r/having.result')
-rw-r--r-- | mysql-test/r/having.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/having.result b/mysql-test/r/having.result index 18fb5e2de72..4a429e1b119 100644 --- a/mysql-test/r/having.result +++ b/mysql-test/r/having.result @@ -631,7 +631,7 @@ id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY t1 index NULL f10 4 NULL 2 100.00 Using index 2 DEPENDENT SUBQUERY t3 ALL NULL NULL NULL NULL 2 100.00 Using where Warnings: -Note 1003 select min(`test`.`t1`.`f10`) AS `field1` from `test`.`t1` where <expr_cache><7>(<in_optimizer>(7,<exists>(select `test`.`t3`.`f3` from `test`.`t3` where <cache>(7) = `test`.`t3`.`f3`))) having <cache>(`field1`) < 's' +Note 1003 /* select#1 */ select min(`test`.`t1`.`f10`) AS `field1` from `test`.`t1` where <expr_cache><7>(<in_optimizer>(7,<exists>(/* select#2 */ select `test`.`t3`.`f3` from `test`.`t3` where <cache>(7) = `test`.`t3`.`f3`))) having <cache>(`field1`) < 's' set optimizer_switch=@save_optimizer_switch; drop table t1,t2,t3; End of 5.2 tests |