Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Grouping Sets: Fix unrecognized node type bug - Mailing list pgsql-bugs

From Jeevan Chalke
Subject Re: [HACKERS] Grouping Sets: Fix unrecognized node type bug
Date
Msg-id CAM2+6=XPRgumbqWTsczbECC3xjv4zH1ryQ3fwds5uajON1iq2A@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Grouping Sets: Fix unrecognized node type bug  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Responses Re: [HACKERS] Grouping Sets: Fix unrecognized node type bug  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
Re: [HACKERS] Grouping Sets: Fix unrecognized node type bug  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs
Tree view


On Wed, Jul 15, 2015 at 10:21 PM, Andrew Gierth <andrew@tao11.riddles.org.uk> wrote:
>>>>> "Jeevan" == Jeevan Chalke <jeevan.chalke@enterprisedb.com> writes:

 Jeevan> Hi,
 Jeevan> It looks like we do support nested GROUPING SETS, I mean Sets
 Jeevan> withing Sets, not other types.  However this nesting is broken.

Good catch, but I'm not yet sure your fix is correct; I'll need to look
into that.

Sure. Thanks.

However I wonder why we are supporting GROUPING SETS inside GROUPING SETS.
On Oracle, it is throwing an error.
We are not trying to be Oracle compatible, but just curious to know.

I have tried restricting it in attached patch.

But it may require few comment adjustment.

Thanks

--
Andrew (irc:RhodiumToad)



--
Jeevan B Chalke
Principal Software Engineer, Product Development
EnterpriseDB Corporation
The Enterprise PostgreSQL Company

Attachment

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Interval - incorrect grammar form
Next
From: Kyotaro HORIGUCHI
Date:
Subject: Re: [HACKERS] Grouping Sets: Fix unrecognized node type bug