diff options
| author | unknown <sergefp@mysql.com> | 2005-03-30 15:57:42 +0400 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2005-03-30 15:57:42 +0400 |
| commit | 5ac4670bf7f17374e8bae1bd27625ccabc1eac82 (patch) | |
| tree | f1b5f4d005ed6b67c11d3881df26610ec2f06acc /sql/table.h | |
| parent | 633a2468ec3407d1900b6cce276cc80a89d978a6 (diff) | |
| download | mariadb-git-5ac4670bf7f17374e8bae1bd27625ccabc1eac82.tar.gz | |
Fix for BUG#9213: GROUP BY returns wrong query results:
Make test_if_skip_sort_order() rebuild tab->ref if it decides to use an index
different from the index join optimizer has choosen.
mysql-test/r/group_by.result:
Testcase for BUG#9213
mysql-test/t/group_by.test:
Testcase for BUG#9213
sql/table.h:
Added comments about TABLE::used_keys
Diffstat (limited to 'sql/table.h')
| -rw-r--r-- | sql/table.h | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/sql/table.h b/sql/table.h index eed9969dac8..054f24267b7 100644 --- a/sql/table.h +++ b/sql/table.h @@ -90,7 +90,9 @@ struct st_table { uint null_fields; /* number of null fields */ uint blob_fields; /* number of blob fields */ key_map keys_in_use, keys_for_keyread, read_only_keys; - key_map quick_keys, used_keys, keys_in_use_for_query; + key_map quick_keys; + key_map used_keys; /* keys that cover all used table fields */ + key_map keys_in_use_for_query; KEY *key_info; /* data of keys in database */ TYPELIB keynames; /* Pointers to keynames */ ha_rows max_rows; /* create information */ |