Re: [HACKERS] Grouping Sets: Fix unrecognized node type bug

Поиск
Список
Период
Сортировка
От Jeevan Chalke
Тема Re: [HACKERS] Grouping Sets: Fix unrecognized node type bug
Дата
Msg-id CAM2+6=XPRgumbqWTsczbECC3xjv4zH1ryQ3fwds5uajON1iq2A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Grouping Sets: Fix unrecognized node type bug  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Ответы 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>)
Список pgsql-bugs


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

Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Interval - incorrect grammar form
Следующее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: [HACKERS] Grouping Sets: Fix unrecognized node type bug