27 May
2023
27 May
'23
10:08 p.m.
Hi,
On Wed, 24 May 2023 at 16:09, Sergei Golubchik
+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