Re: sublink [exists (select xxx group by grouping sets ())] causes an assertion error

2024-03-22 Thread Tom Lane
Jeff Davis writes: > On Fri, 2024-03-22 at 12:28 -0400, Tom Lane wrote: >> Thanks for the report.  I did some bisecting and found that the crash >> appears at Jeff's commit c8aeaf3ab (which introduced this assertion) >> and disappears at Heikki's c4649cce3 (which removed it).  So I would >> say

Re: sublink [exists (select xxx group by grouping sets ())] causes an assertion error

2024-03-22 Thread Jeff Davis
On Fri, 2024-03-22 at 12:28 -0400, Tom Lane wrote: > Thanks for the report.  I did some bisecting and found that the crash > appears at Jeff's commit c8aeaf3ab (which introduced this assertion) > and disappears at Heikki's c4649cce3 (which removed it).  So I would > say that the problem is "this

Re: sublink [exists (select xxx group by grouping sets ())] causes an assertion error

2024-03-22 Thread Tom Lane
"=?UTF-8?B?6LW15bqt5rW3KOW6reeroCk=?=" writes: > I recently notice these sql can lead to a assertion error in pg14 and older > version. Here is an example: > postgres=> CREATE TABLE t1 (a int); > postgres=> INSERT INTO t1 VALUES (1); > postgres=> SELECT EXISTS ( SELECT * FROM t1 GROUP BY

sublink [exists (select xxx group by grouping sets ())] causes an assertion error

2024-03-22 Thread 赵庭海(庭章)
Hello postgres hackers: I recently notice these sql can lead to a assertion error in pg14 and older version. Here is an example: postgres=> CREATE TABLE t1 (a int); CREATE TABLE postgres=> INSERT INTO t1 VALUES (1); INSERT 0 1 postgres=> SELECT EXISTS ( SELECT * FROM t1 GROUP BY GROUPING SETS