Re: ERROR: ORDER/GROUP BY expression not found in targetlist

2018-06-22 Thread Rajkumar Raghuwanshi
Thanks for commit. I have verified reported case. it is fixed now. Thanks & Regards, Rajkumar Raghuwanshi QMG, EnterpriseDB Corporation On Thu, Jun 21, 2018 at 1:54 AM, Tom Lane wrote: > I wrote: > > Thanks for the report. I traced through this, and the problem seems to > > be that

Re: ERROR: ORDER/GROUP BY expression not found in targetlist

2018-06-20 Thread Tom Lane
I wrote: > Thanks for the report. I traced through this, and the problem seems to > be that split_pathtarget_at_srfs() is neglecting to attach sortgroupref > labeling to the extra PathTargets it constructs. I don't remember > whether that code is my fault or Andres', but I'll take a look at >

Re: ERROR: ORDER/GROUP BY expression not found in targetlist

2018-06-20 Thread Tom Lane
Rajkumar Raghuwanshi writes: > Below test case is failing with ERROR: ORDER/GROUP BY expression not found > in targetlist. this issue is reproducible from PGv10. Thanks for the report. I traced through this, and the problem seems to be that split_pathtarget_at_srfs() is neglecting to attach

ERROR: ORDER/GROUP BY expression not found in targetlist

2018-06-20 Thread Rajkumar Raghuwanshi
Hi, Below test case is failing with ERROR: ORDER/GROUP BY expression not found in targetlist. this issue is reproducible from PGv10. postgres=# CREATE TABLE test(c1 int, c2 text, c3 text); CREATE TABLE postgres=# INSERT INTO test SELECT i % 10, i % 250, to_char(i % 4, 'FM000') FROM