diff options
Diffstat (limited to 'mysql-test/suite/galera/r/galera_var_desync_on.result')
-rw-r--r-- | mysql-test/suite/galera/r/galera_var_desync_on.result | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_var_desync_on.result b/mysql-test/suite/galera/r/galera_var_desync_on.result new file mode 100644 index 00000000000..0b5f34688b7 --- /dev/null +++ b/mysql-test/suite/galera/r/galera_var_desync_on.result @@ -0,0 +1,29 @@ +CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB; +INSERT INTO t1 VALUES (1); +SET GLOBAL wsrep_provider_options = 'gcs.fc_limit=1'; +SET GLOBAL wsrep_desync = TRUE; +FLUSH TABLES WITH READ LOCK; +INSERT INTO t1 VALUES (2); +INSERT INTO t1 VALUES (3); +INSERT INTO t1 VALUES (4); +INSERT INTO t1 VALUES (5); +INSERT INTO t1 VALUES (6); +INSERT INTO t1 VALUES (7); +INSERT INTO t1 VALUES (8); +INSERT INTO t1 VALUES (9); +INSERT INTO t1 VALUES (10); +SET SESSION wsrep_sync_wait = 0; +SELECT COUNT(*) = 1 FROM t1; +COUNT(*) = 1 +1 +SET GLOBAL wsrep_desync = FALSE; +UNLOCK TABLES; +SET SESSION wsrep_sync_wait = 1; +SELECT COUNT(*) = 10 FROM t1; +COUNT(*) = 10 +1 +INSERT INTO t1 VALUES (11); +SELECT COUNT(*) = 11 FROM t1; +COUNT(*) = 11 +1 +DROP TABLE t1; |