Bug #29438 rollup with multiple "group by" column repeats last grouping column final rollup
Submitted: 29 Jun 2007 3:36 Modified: 29 Jul 2007 8:21
Reporter: avi weiss Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:5.0.41 OS:Any
Assigned to: CPU Architecture:Any

[29 Jun 2007 3:36] avi weiss
Description:
if multiple columns are used in a "group by with rollup", the final rollup repeats the previously "rolled up" column instead of being "null"

select a, b, count(*) c group by b,a with rollup

a    |  b | c |
----------------
joe  | NY | 5
bill | NY | 7
sam  | NY | 6
null | NY | 18
joe  | CA | 10
bill | CA | 5
sam  | CA | 8
null | CA | 23
joe  | FL | 12
bill | FL | 15
sam  | FL | 6
null | FL | 33
null | FL | 74

How to repeat:
* create table with two columns that can be grouped by and rolled up
* create query as above

second group by column will be repeated in total rollup
[29 Jun 2007 3:44] avi weiss
d
[29 Jun 2007 8:21] Sveta Smirnova
Thank you for the report.

I can not repeat the issue with test data. Please provide repeatable test case: output of SHOW CREATE TABLE problem_table, dump of data from problem table and query.
[29 Jul 2007 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".