Re: sublink [exists (select xxx group by grouping sets ())] causes an assertion error - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: sublink [exists (select xxx group by grouping sets ())] causes an assertion error
Date
Msg-id 7242a03fe0b52e8dd24b21fc8973738105e64990.camel@j-davis.com
Whole thread Raw
In response to Re: sublink [exists (select xxx group by grouping sets ())] causes an assertion error  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: sublink [exists (select xxx group by grouping sets ())] causes an assertion error
List pgsql-hackers
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 assertion is wrong", and we should fix
> the problem by fixing the assertion, not by hacking around in distant
> calling code.  On the whole, since this code has been dead for
> several versions, I'd be inclined to just remove the assertion.

c4649cce3 didn't add additional calls to LogicalTapeSetBlocks(), so I'm
not sure if the removal of the Assert was related to his changes, or if
he just realized the assertion was wrong and removed it along the way?

Also, without the assertion, the word "should" in the comment is
ambiguous (does it mean "must not" or something else), and it still
exists in master. Do we care about the calculation being wrong if
there's an unfinished write? If not, I'll just clarify that the
calculation doesn't take into account still-buffered data. If we do
care, then something might need to be fixed.

Regards,
    Jeff Davis




pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Cannot find a working 64-bit integer type on Illumos
Next
From: Corey Huinker
Date:
Subject: Re: Statistics Import and Export