mariadb/mysql-test/suite/galera/t/MDEV-27123.test at bb-10.6-MDEV-36622-galera - mirror/mariadb - May the force be without you: git.fucktheforce.de

mirror/mariadb

mirror of https://github.com/MariaDB/server.git synced 2025-10-31 02:46:29 +01:00

Jan Lindström ab3ec013c4 MDEV-27123 : auto_increment_increment and auto_increment_offset reset to 1 in current session after alter table on auto-increment column

Problem was that in ALTER TABLE execution variables were set
to 1 even when wsrep_auto_increment_control is OFF. We should
set them only when wsrep_auto_increment_control is ON.

2022-10-09 10:09:47 +03:00

8 lines

273 B

Text

Raw Permalink Blame History

 --source include/galera_cluster.inc
 show variables like 'auto_increment%';
 create table t4 (c1 int primary key auto_increment) engine=innodb;
 show variables like 'auto_increment%';
 alter table t4 add (c2 varchar(50));
 show variables like 'auto_increment%';
 DROP TABLE t4;