Re: ON CONFLICT DO SELECT (take 3)

Поиск
Список
Период
Сортировка
От Dean Rasheed
Тема Re: ON CONFLICT DO SELECT (take 3)
Дата
Msg-id CAEZATCXboUd3HTOph4Ae5kJ=My_Vc2t2re5TuuunRBkOW55Lgw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ON CONFLICT DO SELECT (take 3)  (jian he <jian.universality@gmail.com>)
Список pgsql-hackers
On Tue, 25 Nov 2025 at 08:33, jian he <jian.universality@gmail.com> wrote:
>
> v16-0002: using INJECTION_POINT to test the case when
> ExecOnConflictSelect->ExecOnConflictLockRow returns false.
>

In general, having more tests is a good thing, but I think this is
setting a higher bar for the ON CONFLICT DO SELECT than existing code,
such as ON CONFLICT DO UPDATE. ExecOnConflictUpdate() also uses
ExecOnConflictLockRow() in the same way, and doesn't have such a test,
and there are other lock-and-retry paths in the executor not tested in
this way.

IMO, using injection points for testing a wider variety of possible
race conditions in the executor should be considered as a separate
patch.

Regards,
Dean



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