mirror of
https://github.com/MariaDB/server.git
synced 2025-08-07 00:04:31 +03:00
4baab8697a
The check for streaming replication logging format in THD::decide_logging_format() did the check also for DDLs running in TOI mode. This caused DROP DATABASE to fail if streaming replication was enabled. Added check for THD wsrep execution mode and perform the check only if the THD is in local processing mode (i.e. not TOI). Added galera_sr_create_drop test to verify that CREATE/DROP statements pass even if streaming replication is on.
34 lines
746 B
Plaintext
34 lines
746 B
Plaintext
#
|
|
# Verify that CREATE/DROP DDLs work when streaming replication is on.
|
|
#
|
|
|
|
--source include/galera_cluster.inc
|
|
|
|
SET SESSION wsrep_trx_fragment_size=1;
|
|
|
|
#
|
|
# CREATE/DROP TABLE succeeds and the change is propagated to node_2.
|
|
#
|
|
CREATE TABLE t1 (f1 INT PRIMARY KEY) ENGINE=InnoDB;
|
|
--connection node_2
|
|
SHOW CREATE TABLE t1;
|
|
--connection node_1
|
|
DROP TABLE t1;
|
|
--connection node_2
|
|
--error ER_NO_SUCH_TABLE
|
|
SHOW CREATE TABLE t1;
|
|
|
|
#
|
|
# CREATE/DROP DATABASE succeeds and the change is propagated to node_2.
|
|
#
|
|
CREATE DATABASE mdev_18587;
|
|
--connection node_2
|
|
SHOW DATABASES LIKE 'mdev_18587';
|
|
--connection node_1
|
|
DROP DATABASE mdev_18587;
|
|
--connection node_2
|
|
SHOW DATABASES LIKE 'mdev_18587';
|
|
--connection node_1
|
|
|
|
SET SESSION wsrep_trx_fragment_size=DEFAULT;
|