Postgres Pro
Downloads
Home   >   mailing lists

Re: Add proper planner support for ORDER BY / DISTINCT aggregates - Mailing list pgsql-hackers

From Dean Rasheed
Subject Re: Add proper planner support for ORDER BY / DISTINCT aggregates
Date
Msg-id CAEZATCWETioXs5kY8vT6BVguY41_wD962VDk=u_Nvd7S1UXzuQ@mail.gmail.com
Whole thread Raw
In response to Re: Add proper planner support for ORDER BY / DISTINCT aggregates  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: Add proper planner support for ORDER BY / DISTINCT aggregates  (Richard Guo <guofenglinux@gmail.com>)
List pgsql-hackers
Tree view 
While doing some random testing, I noticed that the following is broken in HEAD:

SELECT COUNT(DISTINCT random()) FROM generate_series(1,10);

ERROR:  ORDER/GROUP BY expression not found in targetlist

It appears to have been broken by 1349d279, though I haven't looked at
the details.

I'm somewhat surprised that a case as simple as this wasn't covered by
any pre-existing regression tests.

Regards,
Dean

pgsql-hackers by date:

Previous
From: "Drouvot, Bertrand"
Date:
Subject: Change xl_hash_vacuum_one_page.ntuples from int to uint16
Next
From: Dean Rasheed
Date:
Subject: Re: [PATCH] random_normal function