diff options
author | unknown <sergefp@mysql.com> | 2007-09-14 14:53:13 +0400 |
---|---|---|
committer | unknown <sergefp@mysql.com> | 2007-09-14 14:53:13 +0400 |
commit | 466747d57081b4bdfe166ff16da8ac9da99900e4 (patch) | |
tree | 366498aa227f237ef0ac7c133a28cc69a402fdb3 /support-files/my-innodb-heavy-4G.cnf.sh | |
parent | ee0b7d895d42b0e3c93bdbffa7c4d3f51c1f60c2 (diff) | |
download | mariadb-git-466747d57081b4bdfe166ff16da8ac9da99900e4.tar.gz |
BUG#30324: Grouping queries with COUNT(DISTINCT bit column) return wrong results
- The bug was caused by COUNT(DISTINCT ...) code using Unique object in
a way that assumed that BIT(N) column occupies a contiguous space in
temp_table->record[0] buffer.
- The fix is to make COUNT(DISTINCT ...) code instruct create_tmp_table to
create temporary table with column of type BIGINT, not BIT(N).
mysql-test/r/type_bit.result:
BUG#30324: Grouping queries with COUNT(DISTINCT bit column) return wrong results
- Testcase
mysql-test/t/type_bit.test:
BUG#30324: Grouping queries with COUNT(DISTINCT bit column) return wrong results
- Testcase
sql/item_sum.cc:
BUG#30324: Grouping queries with COUNT(DISTINCT bit column) return wrong results
- Make COUNT(DISTINCT ...) code instruct create_tmp_table to create
temporary table with BIGINT, not BIT(N) column.
Diffstat (limited to 'support-files/my-innodb-heavy-4G.cnf.sh')
0 files changed, 0 insertions, 0 deletions