diff options
author | Mattias Jonsson <mattias.jonsson@sun.com> | 2009-11-03 09:22:01 +0100 |
---|---|---|
committer | Mattias Jonsson <mattias.jonsson@sun.com> | 2009-11-03 09:22:01 +0100 |
commit | b35feb1ed0aa934ea244163ecea54b5e45157138 (patch) | |
tree | 5caa9e3f10f8eb59e55a71c26719cf2f46a79f3b /storage | |
parent | 64badb5f269850d0111aec29788aff7e181c195d (diff) | |
download | mariadb-git-b35feb1ed0aa934ea244163ecea54b5e45157138.tar.gz |
Bug#46923: select count(*) from partitioned table fails with
ONLY_FULL_GROUP_BY
Problem was that during checking and preparation of the
partitioining function as a side effect in fix_fields
the full_group_by_flag was changed.
Solution was to set it back to its original value after
calling fix_fields.
Updated patch, to also exclude allow_sum_func from being
affected of fix_fields, as requested by reviewer.
mysql-test/r/partition.result:
Bug#46923: select count(*) from partitioned table fails with
ONLY_FULL_GROUP_BY
Updated result file
mysql-test/t/partition.test:
Bug#46923: select count(*) from partitioned table fails with
ONLY_FULL_GROUP_BY
Extended test case to cover this bug
sql/sql_partition.cc:
Bug#46923: select count(*) from partitioned table fails with
ONLY_FULL_GROUP_BY
Resetting full_group_by_flag and allow_sum_func
back to their original values,
not conflicting with the sql_mode 'ONLY_FULL_GROUP_BY'
Diffstat (limited to 'storage')
0 files changed, 0 insertions, 0 deletions