Dumped SQL failed to execute with ERROR "GROUP BY position -1 is not in select list"

Hi hackers, I found that dumped view SQL failed to execute due to the explicit cast of negative number, and I took a look at the defined SQL in view and then found -1 in the group by clause. I suppose it’s the main reason the sql cannot be executed and raised ERROR "GROUP BY position -1 is no

答复: Dumped SQL failed to execute with ERROR "GROUP BY position -1 is not in select list"

ce. Regards, Haotian 发件人: Tom Lane 日期: 星期六, 2023年12月2日 03:57 收件人: Haotian Chen 抄送: pgsql-hack...@postgresql.org 主题: Re: Dumped SQL failed to execute with ERROR "GROUP BY position -1 is not in select list" Haotian Chen writes: > postgres=# create view v1 as select * from t1 grou

Re: Dumped SQL failed to execute with ERROR "GROUP BY position -1 is not in select list"

Please feel free to review latest version patch v3-0001-Printing-const-folder-expression-in-ruleutils.c.patch Best regards, Haotian From: David Rowley Date: Monday, December 4, 2023 at 06:08 To: Haotian Chen Cc: Tom Lane , pgsql-hack...@postgresql.org Subject: Re: Dumped SQL failed to ex