Re: BUG #18429: Inconsistent results on similar queries with join lateral

Поиск
Список
Период
Сортировка
От Corey Huinker
Тема Re: BUG #18429: Inconsistent results on similar queries with join lateral
Дата
Msg-id CADkLM=fbcjMvDrYHjstLh1CiwGJft7q9MCqmTnTsg1_NmT20eA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #18429: Inconsistent results on similar queries with join lateral  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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.
Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Melanie Plageman
Дата:
Сообщение: Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae
Следующее
От: Shlok Kyal
Дата:
Сообщение: Re: BUG #18433: Logical replication timeout