mirror of
https://github.com/MariaDB/server.git
synced 2025-11-06 13:56:14 +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.
40 lines
1.4 KiB
Text
40 lines
1.4 KiB
Text
connection node_2;
|
|
connection node_1;
|
|
SET sql_mode='';
|
|
SET SESSION autocommit=0;
|
|
SET SESSION enforce_storage_engine=Aria;
|
|
SET WSREP_OSU_METHOD = RSU;
|
|
CREATE TABLE t1 (a TEXT) ;
|
|
Warnings:
|
|
Note 1266 Using storage engine Aria for table 't1'
|
|
Note 1266 Using storage engine Aria for table 't1'
|
|
CREATE TABLE t2 (a TEXT) ;
|
|
Warnings:
|
|
Note 1266 Using storage engine Aria for table 't2'
|
|
Note 1266 Using storage engine Aria for table 't2'
|
|
SET SESSION autocommit=1;
|
|
REPLACE INTO t2 (a) SELECT a from t1;
|
|
ERROR 42000: This version of MariaDB doesn't yet support 'RSU on this table engine'
|
|
REPLACE INTO t2 (a) SELECT /*!99997 */ a from t1;
|
|
ERROR 42000: This version of MariaDB doesn't yet support 'RSU on this table engine'
|
|
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) ;
|
|
Warnings:
|
|
Note 1266 Using storage engine MyISAM for table 't1'
|
|
Note 1266 Using storage engine MyISAM for table 't1'
|
|
CREATE TABLE t2 (a TEXT) ;
|
|
Warnings:
|
|
Note 1266 Using storage engine MyISAM for table 't2'
|
|
Note 1266 Using storage engine MyISAM for table 't2'
|
|
SET SESSION autocommit=1;
|
|
REPLACE INTO t2 (a) SELECT a from t1;
|
|
ERROR 42000: This version of MariaDB doesn't yet support 'RSU on this table engine'
|
|
REPLACE INTO t2 (a) SELECT /*!99997 */ a from t1;
|
|
ERROR 42000: This version of MariaDB doesn't yet support 'RSU on this table engine'
|
|
SET WSREP_OSU_METHOD = TOI;
|
|
DROP TABLE t1,t2;
|