RI fast path gets cross-type foreign keys wrong

Поиск
Список
Период
Сортировка
Искать
От
Peter Geoghegan
Тема
RI fast path gets cross-type foreign keys wrong
Дата
в 06:03:22
Msg-id
CAH2-WznQjX3GByh_Ju7unuzMcik_5PJ5D7i_=qhwk=gPEkhfVQ@mail.gmail.com
Список
Дерево обсуждения
RI fast path gets cross-type foreign keys wrong Peter Geoghegan <pg@bowt.ie>
Re: RI fast path gets cross-type foreign keys wrong Peter Geoghegan <pg@bowt.ie>
The attached isolation test patch (written by Claude code) shows that
the new RI fast path can get some things wrong when a foreign key uses
a cross-type equality operator.

The test has two permutations differing only in the primary key's type
-- date against a timestamp FK in the first, timestamp against
timestamp in the second. The interleaving is identical and the
referenced key is present throughout, so both should behave the same
way. The second succeeds (which is correct), while the first fails
with a foreign key violation (which is incorrect).

The fast path was introduced by b7b27eb41. This is an issue on 19 and
master only.

-- 
Peter Geoghegan
В списке pgsql-hackers по дате отправления
От: Tomas Vondra
Дата:
От: Chengpeng Yan
Дата:
FAQ