Message-ID: <49275921-7b39-41af-5eb8-97b50ce3312e@gmail.com>
Date: Fri, 5 Jul 2024 17:00:00 +0300
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.4.2
Subject: Re: Use generation memory context for tuplestore.c
Content-Language: en-US
To: David Rowley <dgrowleyml@gmail.com>
Cc: Matthias van de Meent <boekewurm+postgres@gmail.com>,
 PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
References: <CAApHDvp5Py9g4Rjq7_inL3-MCK1Co2CRt_YWFwTU2zfQix0p4A@mail.gmail.com>
 <CAEze2WiusMw4Ern1HriocdMdt-r+zjw3tKoQn3hCSDRjt5VOyA@mail.gmail.com>
 <CAApHDvr72_Nur=3Zq3_R-V5JB8u-EFeApTQ2mFVDOtB59=aS=w@mail.gmail.com>
 <CAEze2Wjzoo+DXcvYwtbPiKCK5sqjT5WvWXftS9LTiLkzOFbyCw@mail.gmail.com>
 <CAApHDvpwG5w1YeHLPD1M-nZ=k1omFUCAmLGNMSctHFR_f8-NYw@mail.gmail.com>
 <fe7fc8fb-86e5-ecb0-3cb2-dd2c9a6c482f@gmail.com>
 <CAApHDvqT=6KWWb_dii+W0risak6bYBe2yu7e4oUtZoiNOeORKg@mail.gmail.com>
From: Alexander Lakhin <exclusion@gmail.com>
In-Reply-To: <CAApHDvqT=6KWWb_dii+W0risak6bYBe2yu7e4oUtZoiNOeORKg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/49275921-7b39-41af-5eb8-97b50ce3312e%40gmail.com>
Precedence: bulk

05.07.2024 07:57, David Rowley wrote:
> Thanks for the report. I've just pushed a fix in 53abb1e0e.

Thank you, David!

Please look at another anomaly introduced with 590b045c3:
echo "
CREATE TABLE t(f int, t int);
INSERT INTO t VALUES (1, 1);

WITH RECURSIVE sg(f, t) AS (
SELECT * FROM t t1
UNION ALL
SELECT t2.* FROM t t2, sg WHERE t2.f = sg.t
) SEARCH DEPTH FIRST BY f, t SET seq
SELECT * FROM sg;
" | timeout 60 psql

triggers
TRAP: failed Assert("chunk->requested_size < oldsize"), File: "generation.c", Line: 842, PID: 830294

Best regards,
Alexander