Re: [Maria-developers] c75f774d278: MDEV-31058 ER_KEY_NOT_FOUND upon concurrent CHANGE column autoinc and DML

2023-05-27 Thread Nikita Malyavin
Hi, On Wed, 24 May 2023 at 16:09, Sergei Golubchik 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

Re: [Maria-developers] c75f774d278: MDEV-31058 ER_KEY_NOT_FOUND upon concurrent CHANGE column autoinc and DML

2023-05-24 Thread Sergei Golubchik
Hi, Nikita, On May 24, Nikita Malyavin wrote: > revision-id: c75f774d278 (mariadb-11.0.1-118-gc75f774d278) > parent(s): 319207175bd > author: Nikita Malyavin > committer: Nikita Malyavin > timestamp: 2023-05-15 19:43:49 +0300 > message: > > MDEV-31058 ER_KEY_NOT_FOUND upon concurrent CHANGE