From: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
---|---|
To: | Jeevan Chalke <jeevan(dot)chalke(at)enterprisedb(dot)com> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Strange result with LATERAL query |
Date: | 2016-08-24 12:55:00 |
Message-ID: | 87y43mba4p.fsf@news-spur.riddles.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>>>>> "Andrew" == Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> writes:
>>>>> "Jeevan" == Jeevan Chalke <jeevan(dot)chalke(at)enterprisedb(dot)com> writes:
Jeevan> Hi,
Jeevan> While playing with LATERAL along with some aggregates in
Jeevan> sub-query, I have observed somewhat unusual behavior.
Andrew> Simpler example not needing LATERAL:
Andrew> select array(select sum(x+y) from generate_series(1,3) y group by y)
Andrew> from generate_series(1,3) x;
Oh, and another way to verify that it's a bug and not expected behavior
is that it goes away with set enable_hashagg=false;
--
Andrew (irc:RhodiumToad)
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2016-08-24 13:15:36 | Re: dump/restore doesn't preserve row ordering? |
Previous Message | Andrew Gierth | 2016-08-24 12:53:22 | Re: Strange result with LATERAL query |