diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2017-06-20 14:55:30 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2017-06-21 13:46:27 +0200 |
| commit | f7fde4e26f2bff2bccda9d33654db3c49cc4b9cf (patch) | |
| tree | b463fff59a1f7096fb371ce11675b29cf3bdc287 /mysql-test/r/explain_json.result | |
| parent | 056bab0880544d91ea67d18fe8db65b4f6625482 (diff) | |
| download | mariadb-git-bb-10.1-MDEV-10880.tar.gz | |
MDEV-10880: Assertions `keypart_map' or `prebuilt->search_tuple->n_fields > 0' fail on DISTINCT and GROUP BY constantbb-10.1-MDEV-10880
add_group_and_distinct_keys() should take into account JOIN::simple_group.
Diffstat (limited to 'mysql-test/r/explain_json.result')
| -rw-r--r-- | mysql-test/r/explain_json.result | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/mysql-test/r/explain_json.result b/mysql-test/r/explain_json.result index 568373f1e16..a46a3bcefa5 100644 --- a/mysql-test/r/explain_json.result +++ b/mysql-test/r/explain_json.result @@ -1030,10 +1030,10 @@ Table Op Msg_type Msg_text test.t1 analyze status Table is already up to date explain select count(distinct a1,a2,b) from t1 where (a2 >= 'b') and (b = 'a'); id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range NULL idx_t1_1 147 NULL 17 Using where; Using index for group-by +1 SIMPLE t1 index NULL idx_t1_2 147 NULL 128 Using where; Using index explain select count(distinct a1,a2,b,c) from t1 where (a2 >= 'b') and (b = 'a') and (c = 'i121'); id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range NULL idx_t1_1 163 NULL 65 Using where; Using index for group-by (scanning) +1 SIMPLE t1 index NULL idx_t1_1 163 NULL 128 Using where; Using index explain format=json select count(distinct a1,a2,b) from t1 where (a2 >= 'b') and (b = 'a'); EXPLAIN { @@ -1041,14 +1041,14 @@ EXPLAIN "select_id": 1, "table": { "table_name": "t1", - "access_type": "range", - "key": "idx_t1_1", + "access_type": "index", + "key": "idx_t1_2", "key_length": "147", "used_key_parts": ["a1", "a2", "b"], - "rows": 17, + "rows": 128, "filtered": 100, "attached_condition": "((t1.b = 'a') and (t1.a2 >= 'b'))", - "using_index_for_group_by": true + "using_index": true } } } @@ -1059,14 +1059,14 @@ EXPLAIN "select_id": 1, "table": { "table_name": "t1", - "access_type": "range", + "access_type": "index", "key": "idx_t1_1", "key_length": "163", "used_key_parts": ["a1", "a2", "b", "c"], - "rows": 65, + "rows": 128, "filtered": 100, "attached_condition": "((t1.b = 'a') and (t1.c = 'i121') and (t1.a2 >= 'b'))", - "using_index_for_group_by": "scanning" + "using_index": true } } } |