diff options
| author | Sergei Krivonos <sergei.krivonos@mariadb.com> | 2021-12-14 03:21:46 +0200 |
|---|---|---|
| committer | Sergei Krivonos <sergei.krivonos@mariadb.com> | 2021-12-14 03:36:41 +0200 |
| commit | 4f4f6b59e219b9a65312db016d370d9c51e28476 (patch) | |
| tree | 194a94cc1c5a5eb1eb31dc163e56f22741a7c65a | |
| parent | 1ebeab3d422541e3c7141784406fab3836e3fae6 (diff) | |
| download | mariadb-git-10.8-selectivity.tar.gz | |
Update explain_json result10.8-selectivity
| -rw-r--r-- | mysql-test/main/explain_json.result | 26 |
1 files changed, 12 insertions, 14 deletions
diff --git a/mysql-test/main/explain_json.result b/mysql-test/main/explain_json.result index a107fa3a6ff..284fa7ce421 100644 --- a/mysql-test/main/explain_json.result +++ b/mysql-test/main/explain_json.result @@ -962,20 +962,18 @@ EXPLAIN "having_condition": "trigcond(t1.a is null)", "nested_loop": [ { - "full-scan-on-null_key": { - "table": { - "table_name": "t1", - "access_type": "ref_or_null", - "possible_keys": ["a"], - "key": "a", - "key_length": "5", - "used_key_parts": ["a"], - "ref": ["func"], - "rows": 2, - "filtered": 100, - "attached_condition": "trigcond(<cache>(outer_t1.a) = t1.a or t1.a is null)", - "using_index": true - } + "table": { + "table_name": "t1", + "access_type": "ref_or_null", + "possible_keys": ["a"], + "key": "a", + "key_length": "5", + "used_key_parts": ["a"], + "ref": ["func"], + "rows": 2, + "filtered": 100, + "attached_condition": "trigcond(<cache>(outer_t1.a) = t1.a or t1.a is null)", + "using_index": true } }, { |