diff options
Diffstat (limited to 'mysql-test/main/explain_json.result')
| -rw-r--r-- | mysql-test/main/explain_json.result | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/mysql-test/main/explain_json.result b/mysql-test/main/explain_json.result index bb9f0c4d3a2..f3ee13ee17f 100644 --- a/mysql-test/main/explain_json.result +++ b/mysql-test/main/explain_json.result @@ -902,17 +902,19 @@ EXPLAIN "access_type": "ALL", "rows": 2, "filtered": 100, - "attached_condition": "!<in_optimizer>(t1.a,t1.a in (subquery#2))" + "attached_condition": "!<in_optimizer>(t1.a,<exists>(subquery#2))" }, "subqueries": [ { "query_block": { "select_id": 2, + "having_condition": "trigcond(t2.b is null)", "table": { "table_name": "t2", "access_type": "ALL", "rows": 2, - "filtered": 100 + "filtered": 100, + "attached_condition": "trigcond(<cache>(t1.a) = t2.b or t2.b is null)" } } } |