Re: ERROR: ORDER/GROUP BY expression not found in targetlist - Mailing list pgsql-hackers

From Tatsuro Yamada
Subject Re: ERROR: ORDER/GROUP BY expression not found in targetlist
Date
Msg-id 575E6BE6.8040006@lab.ntt.co.jp
Whole thread Raw
In response to Re: ERROR: ORDER/GROUP BY expression not found in targetlist  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers
Hi,

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.
See bellow,

----------------------------------
postgres=# \i queries/4.explain.sql
ERROR:  Aggref found in non-Agg plan node
STATEMENT:  explain analyze select                o_orderpriority,                count(*) as order_count        from
            orders        where                o_orderdate >= date '1993-10-01'                and o_orderdate < date
'1993-10-01'+ interval '3' month                and exists (                        select
 *                        from                                lineitem                        where
          l_orderkey = o_orderkey                                and l_commitdate < l_receiptdate                )
 group by                o_orderpriority        order by                o_orderpriority        LIMIT 1;
 
----------------------------------

Regards,
Tatsuro Yamada
NTT OSS Center


On 2016/06/13 16:18, Amit Kapila wrote:
> On Mon, Jun 13, 2016 at 11:05 AM, David Rowley <david.rowley@2ndquadrant.com <mailto:david.rowley@2ndquadrant.com>>
wrote:
>  >
>  > On 13 June 2016 at 15:39, Thomas Munro <thomas.munro@enterprisedb.com <mailto:thomas.munro@enterprisedb.com>>
wrote:
>  > > 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
Sortpath 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.
 
>
> With Regards,
> Amit Kapila.
> EnterpriseDB: http://www.enterprisedb.com <http://www.enterprisedb.com/>
>
>
>





pgsql-hackers by date:

Previous
From: Tatsuro Yamada
Date:
Subject: Re: ERROR: ORDER/GROUP BY expression not found in targetlist
Next
From: Julien Rouhaud
Date:
Subject: Re: Rename max_parallel_degree?