[Postgres-xl-developers] regression bug fix

Tomas Vondra tomas.vondra at 2ndquadrant.com
Wed Oct 11 12:46:14 PDT 2017

Hi senhu,

On 10/10/2017 01:25 PM, senhu(胡森) wrote:
> Hi, all:
>    When I run the case tsrf of regression on latest version of PGXL, I
> get the error message
> “ORDER/GROUP BY expression not found in targetlist”. It seems like the
> problem is in function
> ‘split_pathtarget_at_srfs’, add new column to pathtarget just appends
> the expressions, but do not
> set the sortgrouprefs. I share a patch to set the sortgrouprefs at the
> end of creation of pathtarget,

Thanks for the patch! I've been wondering what causes this regression
failure, so thanks for investigating. I'll review the patch soon.

> I think it may be better to set the sortgrouprefs when creating pathtarget.

Does that mean you think there might be a better way to fix this issue?


Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

More information about the Postgres-xl-developers mailing list