I am not familiar with any of the real use cases, and don't know, what users do actually expect. I thought we're agreed about that
Hi, Nikita!
On Apr 03, Nikita Malyavin wrote:
> >
> > Now, about semantics. It is very arguable here. One options is to
> > do, literally, "insert, if fails delete/update the conflicting row".
> > No periods involved here. The other option is to use FOR PERIOD
> > implicitly for updates and deletes.
> >
> Sure, option two should be chosen. I rewrote the code
Why option two?
Do you know use cases that would justify this behavior?
Regards,
Sergei
VP of MariaDB Server Engineering
and security@mariadb.org