Обсуждение: Assert failure with MERGE into partitioned table with RLS

Поиск
Список
Период
Сортировка

Assert failure with MERGE into partitioned table with RLS

От
Dean Rasheed
Дата:
As part of the MERGE RETURNING patch I noticed a suspicious Assert()
in ExecInitPartitionInfo() that looked like it needed updating for
MERGE.

After more testing, I can confirm that this is indeed a pre-existing
bug, that can be triggered using MERGE into a partitioned table that
has RLS enabled (and hence non-empty withCheckOptionLists to
initialise).

So I think we need something like the attached.

Regards,
Dean
Вложения

Re: Assert failure with MERGE into partitioned table with RLS

От
Dean Rasheed
Дата:
On Mon, 20 Feb 2023 at 16:18, Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
>
> As part of the MERGE RETURNING patch I noticed a suspicious Assert()
> in ExecInitPartitionInfo() that looked like it needed updating for
> MERGE.
>
> After more testing, I can confirm that this is indeed a pre-existing
> bug, that can be triggered using MERGE into a partitioned table that
> has RLS enabled (and hence non-empty withCheckOptionLists to
> initialise).
>
> So I think we need something like the attached.
>

Pushed and back-patched.

Regards,
Dean