mirror of
https://github.com/MariaDB/server.git
synced 2025-02-23 05:43:08 +01:00

Problem was incorrect condition on wsrep_check_sequence when ENGINE!=InnoDB. Fix is not use DB_TYPE_XXX because it is not correct on dynamic storage engines. Instead used storage engine name is looked from thd->lex->m_sql_cmd->option_storage_engine_name. For CREATE TABLE allow anyting except ENGINE=SEQUENCE. For CREATE SEQUENCE only ENGINE=InnoDB is supported. For ALTER TABLE if original table contains sequence information only ENGINE=InnoDB is supported. Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
22 lines
538 B
Text
22 lines
538 B
Text
--source include/galera_cluster.inc
|
|
--source include/have_sequence.inc
|
|
--source include/have_rocksdb.inc
|
|
|
|
--connection node_1
|
|
INSTALL PLUGIN IF NOT EXISTS connect SONAME 'ha_connect';
|
|
|
|
CREATE TABLE t1 (f INT) ENGINE=CONNECT;
|
|
CREATE TABLE t2 (f INT) ENGINE=ROCKSDB;
|
|
--error ER_NOT_SUPPORTED_YET
|
|
CREATE TABLE t3 (f INT) ENGINE=SEQUENCE;
|
|
show warnings;
|
|
|
|
--connection node_2
|
|
show create table t1;
|
|
show create table t2;
|
|
--error ER_NO_SUCH_TABLE
|
|
show create table t3;
|
|
|
|
--connection node_1
|
|
DROP TABLE t1, t2;
|
|
UNINSTALL PLUGIN IF EXISTS connect;
|