I applied your patch and run tpc-h.
Then I got new errors on Q4,12,17 and 19.
ERROR: Aggref found in non-Agg plan node.
postgres=# \i queries/4.explain.sql
ERROR: Aggref found in non-Agg plan node
STATEMENT: explain analyze select
count(*) as order_count
o_orderdate >= date '1993-10-01'
and o_orderdate < date '1993-10-01' + interval '3' month
and exists (
l_orderkey = o_orderkey
and l_commitdate < l_receiptdate
NTT OSS Center
On 2016/06/13 16:18, Amit Kapila wrote:
On Mon, Jun 13, 2016 at 11:05 AM, David Rowley <david.row...@2ndquadrant.com
> On 13 June 2016 at 15:39, Thomas Munro <thomas.mu...@enterprisedb.com
> > What is going on here?
> > postgres=# set max_parallel_workers_per_gather = 2;
> > SET
> > postgres=# explain select length(data) from logs group by length(data);
> > ERROR: ORDER/GROUP BY expression not found in targetlist
> Seems like this was caused by 04ae11f62e643e07c411c4935ea6af46cb112aa9
In create_grouping_paths(), we are building partial_grouping_path and same is
used for gather path and other grouping paths (for partial paths). However, we
don't use it for partial path list and sort path due to which path target for
Sort path is different from what we have expected. Is there a problem in
applying partial_grouping_path for partial pathlist? Attached patch just
does that and I don't see error with patch.
EnterpriseDB: http://www.enterprisedb.com <http://www.enterprisedb.com/>
Sent via pgsql-hackers mailing list (email@example.com)
To make changes to your subscription: