mirror of
https://github.com/MariaDB/server.git
synced 2025-11-20 20:49:41 +01:00
66aa2501b1
Problem was executable comment in REPLACE that caused consistency check that is not supported for RSU and !InnoDB tables. Fix is to check is Online Schema Upgrade (OSU) method something else than TOI and if it is then table storage engine must be InnoDB or error is produced and execution returns and no consistency check is done.
30 lines
839 B
Text
30 lines
839 B
Text
--source include/galera_cluster.inc
|
|
--source include/have_aria.inc
|
|
|
|
SET sql_mode='';
|
|
SET SESSION autocommit=0;
|
|
SET SESSION enforce_storage_engine=Aria;
|
|
SET WSREP_OSU_METHOD = RSU;
|
|
CREATE TABLE t1 (a TEXT) ;
|
|
CREATE TABLE t2 (a TEXT) ;
|
|
SET SESSION autocommit=1;
|
|
--error ER_NOT_SUPPORTED_YET
|
|
REPLACE INTO t2 (a) SELECT a from t1;
|
|
--error ER_NOT_SUPPORTED_YET
|
|
REPLACE INTO t2 (a) SELECT /*!99997 */ a from t1;
|
|
SET WSREP_OSU_METHOD = TOI;
|
|
DROP TABLE t1,t2;
|
|
|
|
SET sql_mode='';
|
|
SET SESSION autocommit=0;
|
|
SET SESSION enforce_storage_engine=MyISAM;
|
|
SET WSREP_OSU_METHOD = RSU;
|
|
CREATE TABLE t1 (a TEXT) ;
|
|
CREATE TABLE t2 (a TEXT) ;
|
|
SET SESSION autocommit=1;
|
|
--error ER_NOT_SUPPORTED_YET
|
|
REPLACE INTO t2 (a) SELECT a from t1;
|
|
--error ER_NOT_SUPPORTED_YET
|
|
REPLACE INTO t2 (a) SELECT /*!99997 */ a from t1;
|
|
SET WSREP_OSU_METHOD = TOI;
|
|
DROP TABLE t1,t2;
|