Re: BUG #18429: Inconsistent results on similar queries with join lateral - Mailing list pgsql-bugs

From Corey Huinker
Subject Re: BUG #18429: Inconsistent results on similar queries with join lateral
Date
Msg-id CADkLM=fbcjMvDrYHjstLh1CiwGJft7q9MCqmTnTsg1_NmT20eA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #18429: Inconsistent results on similar queries with join lateral  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
I didn't add such a test because there are already several cases
(in foreign_data.sql, IIRC) that trigger the assert, which is
how come I found the problem in the first place.  Admittedly,
those depend on potentially-changeable details of an
information_schema view, so maybe it'd be better to have a
bespoke test.

I recently had a situation where having a bespoke test would have been helpful. Attached is a mostly-verbatim formalization of the tests from the original email. Q3 was of particular use to me.
Attachment

pgsql-bugs by date:

Previous
From: Melanie Plageman
Date:
Subject: Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae
Next
From: Shlok Kyal
Date:
Subject: Re: BUG #18433: Logical replication timeout