diff options
Diffstat (limited to 'mysql-test/main/subselect_no_semijoin.result')
| -rw-r--r-- | mysql-test/main/subselect_no_semijoin.result | 50 |
1 files changed, 31 insertions, 19 deletions
diff --git a/mysql-test/main/subselect_no_semijoin.result b/mysql-test/main/subselect_no_semijoin.result index a06a4aef99b..88f8f78019e 100644 --- a/mysql-test/main/subselect_no_semijoin.result +++ b/mysql-test/main/subselect_no_semijoin.result @@ -7415,34 +7415,46 @@ EXPLAIN { "query_block": { "select_id": 1, - "table": { - "table_name": "t1", - "access_type": "ALL", - "rows": 2, - "filtered": 100 - }, + "nested_loop": [ + { + "table": { + "table_name": "t1", + "access_type": "ALL", + "rows": 2, + "filtered": 100 + } + } + ], "subqueries": [ { "query_block": { "select_id": 2, "pseudo_bits_condition": "1 = t1.a or <in_optimizer>(1,<exists>(subquery#3))", - "table": { - "table_name": "t2", - "access_type": "system", - "rows": 1, - "filtered": 100 - }, + "nested_loop": [ + { + "table": { + "table_name": "t2", + "access_type": "system", + "rows": 1, + "filtered": 100 + } + } + ], "subqueries": [ { "query_block": { "select_id": 3, - "table": { - "table_name": "t3", - "access_type": "ALL", - "rows": 2, - "filtered": 100, - "attached_condition": "1 = t3.c" - } + "nested_loop": [ + { + "table": { + "table_name": "t3", + "access_type": "ALL", + "rows": 2, + "filtered": 100, + "attached_condition": "1 = t3.c" + } + } + ] } } ] |