diff options
author | Oleksandr Byelkin <sanja@mariadb.com> | 2017-01-22 12:31:32 +0100 |
---|---|---|
committer | Oleksandr Byelkin <sanja@mariadb.com> | 2017-03-13 12:07:47 +0100 |
commit | 7aa09a5ed2480f2459d52833772bb5b7677c2add (patch) | |
tree | 5e80c81104489f93296871be0225028000a823b5 /mysql-test/r/subselect_cache.result | |
parent | a4652c3b1a2a366065dbac3a7570e3cac09870ad (diff) | |
download | mariadb-git-7aa09a5ed2480f2459d52833772bb5b7677c2add.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/subselect_cache.result')
-rw-r--r-- | mysql-test/r/subselect_cache.result | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/mysql-test/r/subselect_cache.result b/mysql-test/r/subselect_cache.result index 5c74555af00..813d668c88c 100644 --- a/mysql-test/r/subselect_cache.result +++ b/mysql-test/r/subselect_cache.result @@ -135,6 +135,7 @@ ANALYZE { "query_block": { "select_id": 4, + "operation": "UNION", "table": { "message": "No tables used" } @@ -237,6 +238,7 @@ EXPLAIN { "query_block": { "select_id": 4, + "operation": "UNION", "table": { "message": "No tables used" } @@ -3613,7 +3615,7 @@ id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 2 100.00 Using where 2 DEPENDENT SUBQUERY t2 ALL NULL NULL NULL NULL 2 100.00 Using where Warnings: -Note 1003 select `test`.`t1`.`a` AS `a` from `test`.`t1` where <expr_cache><`test`.`t1`.`a`>(<in_optimizer>(`test`.`t1`.`a`,<exists>(select `test`.`t2`.`b` from `test`.`t2` where <cache>(`test`.`t1`.`a`) = `test`.`t2`.`b`))) +Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` where <expr_cache><`test`.`t1`.`a`>(<in_optimizer>(`test`.`t1`.`a`,<exists>(/* select#2 */ select `test`.`t2`.`b` from `test`.`t2` where <cache>(`test`.`t1`.`a`) = `test`.`t2`.`b`))) drop table t1,t2; set @@optimizer_switch= default; # LP BUG#615760 (part 2: incorrect heap table index flags) |