mirror of
https://github.com/MariaDB/server.git
synced 2025-04-07 15:55:41 +02:00
0172887980
This is regression from commit3228c08fa8. Problem is that when table storage engine is determined there should be check is table partitioned and if it is then determine partition implementing storage engine. Reported bug is reproducible only with --log-bin so make sure tests changed by3228c08fa8and new test are run with --log-bin and binlog disabled. Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
62 lines
1.2 KiB
Text
62 lines
1.2 KiB
Text
--source include/galera_cluster.inc
|
|
--source include/have_innodb.inc
|
|
--source include/log_bin.inc
|
|
|
|
#
|
|
# This tests simple autocommit replication of MyISAM tables.
|
|
#
|
|
|
|
SET GLOBAL wsrep_replicate_myisam=ON;
|
|
|
|
# Without a PK
|
|
|
|
CREATE TABLE t1 (f1 INTEGER) ENGINE=MyISAM;
|
|
|
|
INSERT INTO t1 VALUES (1);
|
|
INSERT INTO t1 VALUES (2), (3);
|
|
# This is TOI
|
|
INSERT INTO t1 SELECT 4 FROM DUAL UNION ALL SELECT 5 FROM DUAL;
|
|
|
|
CREATE TABLE t2 (f1 INTEGER PRIMARY KEY) ENGINE=MyISAM;
|
|
INSERT INTO t2 VALUES (1);
|
|
INSERT INTO t2 VALUES (2), (3);
|
|
# This is TOI
|
|
INSERT INTO t2 SELECT 4 FROM DUAL UNION ALL SELECT 5 FROM DUAL;
|
|
|
|
# Error
|
|
--error ER_DUP_ENTRY
|
|
INSERT INTO t2 VALUES (6), (1);
|
|
|
|
# UPDATE
|
|
|
|
UPDATE t1 SET f1 = 9;
|
|
UPDATE t2 SET f1 = 9 WHERE f1 = 1;
|
|
|
|
# DELETE
|
|
|
|
DELETE FROM t1 WHERE f1 = 9;
|
|
DELETE FROM t2 WHERE f1 = 9;
|
|
|
|
SELECT * FROM t1 ORDER BY f1;
|
|
SELECT * FROM t2 ORDER BY f1;
|
|
|
|
--connection node_2
|
|
SELECT * FROM t1 ORDER BY f1;
|
|
SELECT * FROM t2 ORDER BY f1;
|
|
|
|
# TRUNCATE
|
|
|
|
TRUNCATE TABLE t1;
|
|
TRUNCATE TABLE t2;
|
|
|
|
SELECT * FROM t1 ORDER BY f1;
|
|
SELECT * FROM t2 ORDER BY f1;
|
|
|
|
--connection node_2
|
|
SELECT * FROM t1 ORDER BY f1;
|
|
SELECT * FROM t2 ORDER BY f1;
|
|
|
|
--connection node_1
|
|
SET GLOBAL wsrep_replicate_myisam=OFF;
|
|
DROP TABLE t1;
|
|
DROP TABLE t2;
|