maria-developers team mailing list archive

[Nikita Malyavin <nikitamalyavin@xxxxxxxxx>]

Hi,

On Wed, 24 May 2023 at 16:09, Sergei Golubchik <serg@xxxxxxxxxxx> wrote:

> > +set statement sql_mode= NO_AUTO_VALUE_ON_ZERO for
> > +alter table t drop a, modify b serial, algorithm=copy, lock=none;
>
> I don't think it should work, see my comment in the MDEV
>
the existing values will not be changed under NO_AUTO_VALUE_ON_ZERO,
this is why it's fine.


-- 
Yours truly,
Nikita Malyavin