Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.4.4, 10.1(EOL), 10.2(EOL)
-
None
Description
galera.galera_binlog_stmt_autoinc 'innodb' w4 [ fail ]
|
Test ended at 2018-08-30 09:58:42
|
|
CURRENT_TEST: galera.galera_binlog_stmt_autoinc
|
--- /usr/share/mysql/mysql-test/suite/galera/r/galera_binlog_stmt_autoinc.result 2018-08-30 07:54:55.000000000 +0000
|
+++ /run/shm/var/4/log/galera_binlog_stmt_autoinc.reject 2018-08-30 09:58:42.602542458 +0000
|
@@ -12,21 +12,21 @@
|
insert into t1(i) values(null);
|
select * from t1;
|
i c
|
-1 dummy_text
|
+2 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
|
+2 dummy_text
|
+4 dummy_text
|
+6 dummy_text
|
+8 dummy_text
|
connection node_2;
|
select * from t1;
|
i c
|
-1 dummy_text
|
-3 dummy_text
|
-5 dummy_text
|
-7 dummy_text
|
+2 dummy_text
|
+4 dummy_text
|
+6 dummy_text
|
+8 dummy_text
|
SET GLOBAL wsrep_forced_binlog_format='none';
|
connection node_1;
|
SET GLOBAL wsrep_forced_binlog_format='none';
|
@@ -70,7 +70,7 @@
|
show variables like '%auto_increment%';
|
Variable_name Value
|
auto_increment_increment 2
|
-auto_increment_offset 1
|
+auto_increment_offset 2
|
wsrep_auto_increment_control ON
|
SET GLOBAL wsrep_auto_increment_control='OFF';
|
show variables like '%auto_increment%';
|
@@ -92,21 +92,21 @@
|
insert into t1(i) values(null);
|
select * from t1;
|
i c
|
-1 dummy_text
|
+2 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
|
+2 dummy_text
|
+4 dummy_text
|
+6 dummy_text
|
+8 dummy_text
|
connection node_2;
|
select * from t1;
|
i c
|
-1 dummy_text
|
-3 dummy_text
|
-5 dummy_text
|
-7 dummy_text
|
+2 dummy_text
|
+4 dummy_text
|
+6 dummy_text
|
+8 dummy_text
|
SET GLOBAL wsrep_forced_binlog_format='none';
|
connection node_1;
|
SET GLOBAL wsrep_forced_binlog_format='none';
|
@@ -149,7 +149,7 @@
|
show variables like '%auto_increment%';
|
Variable_name Value
|
auto_increment_increment 2
|
-auto_increment_offset 1
|
+auto_increment_offset 2
|
wsrep_auto_increment_control ON
|
SET GLOBAL wsrep_auto_increment_control='OFF';
|
show variables like '%auto_increment%';
|
|
mysqltest: Result content mismatch
|
Attachments
Issue Links
- is duplicated by
-
MDEV-19959 Galera test failure on galera_binlog_stmt_autoinc
- Closed