mirror of
https://github.com/MariaDB/server.git
synced 2025-02-23 05:43:08 +01:00
ab3ec013c4
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.
17 lines
487 B
Text
17 lines
487 B
Text
connection node_2;
|
|
connection node_1;
|
|
show variables like 'auto_increment%';
|
|
Variable_name Value
|
|
auto_increment_increment 3
|
|
auto_increment_offset 3
|
|
create table t4 (c1 int primary key auto_increment) engine=innodb;
|
|
show variables like 'auto_increment%';
|
|
Variable_name Value
|
|
auto_increment_increment 3
|
|
auto_increment_offset 3
|
|
alter table t4 add (c2 varchar(50));
|
|
show variables like 'auto_increment%';
|
|
Variable_name Value
|
|
auto_increment_increment 3
|
|
auto_increment_offset 3
|
|
DROP TABLE t4;
|