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

On Thu, 13 Aug 2026, 00:19 Paul A Jungwirth, <pj(at)illuminatedcomputing(dot)com>
wrote:

> 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.
>

Seems reasonable to me, after a quick read through.

Regards,
Dean