MySQL Bugs: #29438: rollup with multiple "group by" column repeats last grouping column final rollup

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

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

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.

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".