mirror of
https://github.com/MariaDB/server.git
synced 2025-07-25 12:45:00 +02:00
fd1266a980
@@enforce_storage_engine is local setting and there is no knowledge how other nodes are configured. Statement CREATE TABLE xxx ENGINE=yyy is replicated as it is and if required engine != enforced engine it could lead inconsistent used storage engine in the cluster. Fix is to return error and a warning if required engine is not same as enforced engine. Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
19 lines
474 B
Text
19 lines
474 B
Text
--source include/galera_cluster.inc
|
|
--source include/have_aria.inc
|
|
--source include/log_bin.inc
|
|
|
|
set session sql_mode='';
|
|
SET @@enforce_storage_engine=INNODB;
|
|
--error ER_OPTION_PREVENTS_STATEMENT
|
|
CREATE TABLE t1 (c INT ) ENGINE=ARIA;
|
|
SHOW WARNINGS;
|
|
|
|
CREATE TABLE t1 (c INT );
|
|
DROP TABLE t1;
|
|
CREATE TABLE t1 (c INT ) ENGINE=INNODB;
|
|
DROP TABLE t1;
|
|
|
|
SET @@enforce_storage_engine=ARIA;
|
|
--error ER_OPTION_PREVENTS_STATEMENT
|
|
CREATE TABLE t1 (c INT ) ENGINE=INNODB;
|
|
SHOW WARNINGS;
|