Bug #3156 GROUPING() Feature request
Submitted: 12 Mar 2004 8:07 Modified: 14 Oct 2009 9:03
Reporter: [ name withheld ] Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server: DML Severity:S4 (Feature request)
Version:4. OS:Microsoft Windows (windows)
Assigned to: CPU Architecture:Any

[12 Mar 2004 8:07] [ name withheld ]
Tried to post this as a comment on the manual - got a 'it a f-r' relpy.

At least I think it's a feature request... err happier still if it's just
that I didn't RTFM.

Support for a GROUPING() function as in T-SQL And Oracle SQL. With ROLLUP,
with CUBE is next to useless without a way of programmatically determining
row type (ie 0 or 1). Really really would like to be able to do (as your
own docs say) some OLAPish stuff with your excellent product.

How to repeat:
Um try to effectively use ROLLUP

Suggested fix:
Incorporate GROUPING FUNCTION() similar to Oracle 9 + MSSQL/Sybase
[22 Jun 2004 12:08] [ name withheld ]
Really wondering if someone could comment on this 3 months gone now......
[16 Jul 2004 13:32] Sergei Golubchik
I'll add it to our TODO list, thanks !
[2 Dec 2005 16:41] Valeriy Kravchuk
Thank you for a reasonable feature rtequest. This feature will be implemented in the next versions of MySQL server.
[25 Aug 2006 16:03] [ name withheld ]
I am wondering on the status of this and if it will be implemented.
[13 Sep 2006 18:01] Peter Gulutzan
[14 Oct 2009 9:03] Valeriy Kravchuk
We have a patch for this contributed in frames of Bug #46053. So, let's call this report a duplicate.