summaryrefslogtreecommitdiff
path: root/mysql-test/suite/galera/r/galera_binlog_stmt_autoinc.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/galera/r/galera_binlog_stmt_autoinc.result')
-rw-r--r--mysql-test/suite/galera/r/galera_binlog_stmt_autoinc.result28
1 files changed, 14 insertions, 14 deletions
diff --git a/mysql-test/suite/galera/r/galera_binlog_stmt_autoinc.result b/mysql-test/suite/galera/r/galera_binlog_stmt_autoinc.result
index 8e8b79b168f..542bd156816 100644
--- a/mysql-test/suite/galera/r/galera_binlog_stmt_autoinc.result
+++ b/mysql-test/suite/galera/r/galera_binlog_stmt_autoinc.result
@@ -8,20 +8,20 @@ PRIMARY KEY (i)
insert into t1(i) values(null);
select * from t1;
i c
-3 dummy_text
+1 dummy_text
insert into t1(i) values(null), (null), (null);
select * from t1;
i c
+1 dummy_text
3 dummy_text
5 dummy_text
7 dummy_text
-9 dummy_text
select * from t1;
i c
+1 dummy_text
3 dummy_text
5 dummy_text
7 dummy_text
-9 dummy_text
SET GLOBAL wsrep_forced_binlog_format='none';
SET GLOBAL wsrep_forced_binlog_format='none';
drop table t1;
@@ -40,20 +40,20 @@ PRIMARY KEY (i)
insert into t1(i) values(null);
select * from t1;
i c
-4 dummy_text
+1 dummy_text
insert into t1(i) values(null), (null), (null);
select * from t1;
i c
+1 dummy_text
4 dummy_text
7 dummy_text
10 dummy_text
-13 dummy_text
select * from t1;
i c
+1 dummy_text
4 dummy_text
7 dummy_text
10 dummy_text
-13 dummy_text
SET GLOBAL wsrep_auto_increment_control='ON';
SET SESSION binlog_format='ROW';
show variables like 'binlog_format';
@@ -67,7 +67,7 @@ wsrep_auto_increment_control ON
SET GLOBAL wsrep_auto_increment_control='OFF';
show variables like '%auto_increment%';
Variable_name Value
-auto_increment_increment 2
+auto_increment_increment 3
auto_increment_offset 1
wsrep_auto_increment_control OFF
SET GLOBAL wsrep_auto_increment_control='ON';
@@ -82,20 +82,20 @@ PRIMARY KEY (i)
insert into t1(i) values(null);
select * from t1;
i c
-3 dummy_text
+1 dummy_text
insert into t1(i) values(null), (null), (null);
select * from t1;
i c
+1 dummy_text
3 dummy_text
5 dummy_text
7 dummy_text
-9 dummy_text
select * from t1;
i c
+1 dummy_text
3 dummy_text
5 dummy_text
7 dummy_text
-9 dummy_text
SET GLOBAL wsrep_forced_binlog_format='none';
SET GLOBAL wsrep_forced_binlog_format='none';
drop table t1;
@@ -114,20 +114,20 @@ PRIMARY KEY (i)
insert into t1(i) values(null);
select * from t1;
i c
-4 dummy_text
+1 dummy_text
insert into t1(i) values(null), (null), (null);
select * from t1;
i c
+1 dummy_text
4 dummy_text
7 dummy_text
10 dummy_text
-13 dummy_text
select * from t1;
i c
+1 dummy_text
4 dummy_text
7 dummy_text
10 dummy_text
-13 dummy_text
SET GLOBAL wsrep_auto_increment_control='ON';
show variables like 'binlog_format';
Variable_name Value
@@ -140,7 +140,7 @@ wsrep_auto_increment_control ON
SET GLOBAL wsrep_auto_increment_control='OFF';
show variables like '%auto_increment%';
Variable_name Value
-auto_increment_increment 2
+auto_increment_increment 3
auto_increment_offset 1
wsrep_auto_increment_control OFF
SET GLOBAL wsrep_auto_increment_control='ON';