[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?


regards

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


More information about the Postgres-xl-developers mailing list