Re: DELETE FOR PORTION OF bypasses view WITH CHECK OPTION for leftover rows

On Wed, Aug 12, 2026 at 2:30 PM Melanie Plageman
<melanieplageman(at)gmail(dot)com> wrote:
>
> On Wed, Jul 22, 2026 at 2:43 PM Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com> wrote:
> >
> > While testing FOR PORTION OF I noticed that DELETE FOR PORTION OF on a
> > view ignores the view's WITH CHECK OPTION for the temporal leftover
> > rows it inserts.
>
> [RMT hat]
>
> It's been a few weeks since this was reported, and there hasn't been
> engagement by the feature authors. Is this on your radar?
> I added an open item [1].

Thanks Melanie! I'm sorry I missed this before.

I can reproduce the bug. The fix looks good to me.

Here are some slight revisions: I added doc updates and a couple extra
regress lines (verifying the same cases, but for UPDATE too). And I
expanded the comment to explain why this is needed for DELETE but not
UPDATE, since that wasn't obvious to me right away.

Yours,

--
Paul ~{:-)
pj(at)illuminatedcomputing(dot)com