Hi,

On Wed, 24 May 2023 at 16:09, Sergei Golubchik <serg@mariadb.org> 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