diff options
author | sjaakola <seppo.jaakola@iki.fi> | 2016-02-19 11:48:09 +0200 |
---|---|---|
committer | Nirbhay Choubey <nirbhay@mariadb.com> | 2016-08-21 16:16:59 -0400 |
commit | 5edf55be631d86a92e1faaa9e0c2792be8f41c29 (patch) | |
tree | 25b457df6ce7d5a3ce21cf32da49f36ab4e40c83 /mysql-test/suite/galera/r/galera_as_slave_autoinc.result | |
parent | df96eb5d049db22157ad0c01ac0e50c7beb79a88 (diff) | |
download | mariadb-git-5edf55be631d86a92e1faaa9e0c2792be8f41c29.tar.gz |
Refs: MW-248
- fixed the test case and extended with autoinc modification is master side
Diffstat (limited to 'mysql-test/suite/galera/r/galera_as_slave_autoinc.result')
-rw-r--r-- | mysql-test/suite/galera/r/galera_as_slave_autoinc.result | 41 |
1 files changed, 32 insertions, 9 deletions
diff --git a/mysql-test/suite/galera/r/galera_as_slave_autoinc.result b/mysql-test/suite/galera/r/galera_as_slave_autoinc.result index b3a4cd77044..a8f5ec8e37e 100644 --- a/mysql-test/suite/galera/r/galera_as_slave_autoinc.result +++ b/mysql-test/suite/galera/r/galera_as_slave_autoinc.result @@ -18,13 +18,29 @@ i c 2 dummy_text 3 dummy_text 4 dummy_text +SET SESSION auto_increment_increment=7; +insert into t1(i) values(null), (null), (null); +SET SESSION auto_increment_offset=5; +insert into t1(i) values(null), (null), (null); +select * from t1; +i c +1 dummy_text +2 dummy_text +3 dummy_text +4 dummy_text +8 dummy_text +15 dummy_text +22 dummy_text +33 dummy_text +40 dummy_text +47 dummy_text show variables like 'binlog_format'; Variable_name Value binlog_format STATEMENT show variables like '%auto_increment%'; Variable_name Value -auto_increment_increment 1 -auto_increment_offset 1 +auto_increment_increment 7 +auto_increment_offset 5 wsrep_auto_increment_control ON select * from t1; i c @@ -32,30 +48,37 @@ i c 2 dummy_text 3 dummy_text 4 dummy_text +8 dummy_text +15 dummy_text +22 dummy_text +33 dummy_text +40 dummy_text +47 dummy_text show variables like 'binlog_format'; Variable_name Value binlog_format ROW -show variables like '%auto_increment%'; +show variables like 'auto_increment_increment'; Variable_name Value auto_increment_increment 2 -auto_increment_offset 1 -wsrep_auto_increment_control ON select * from t1; i c 1 dummy_text 2 dummy_text 3 dummy_text 4 dummy_text +8 dummy_text +15 dummy_text +22 dummy_text +33 dummy_text +40 dummy_text +47 dummy_text show variables like 'binlog_format'; Variable_name Value binlog_format ROW -show variables like '%auto_increment%'; +show variables like 'auto_increment_increment'; Variable_name Value auto_increment_increment 2 -auto_increment_offset 2 -wsrep_auto_increment_control ON DROP TABLE t1; STOP SLAVE; RESET SLAVE ALL; -SET GLOBAL binlog_format='ROW'; RESET MASTER; |