mirror of
https://github.com/MariaDB/server.git
synced 2025-02-05 13:22:17 +01:00
9ab7dbc3be
Return an error if user attempts to use SEQUENCEs in combination with streaming replication in a Galera cluster. This is currently not supported. Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
20 lines
623 B
Text
20 lines
623 B
Text
#
|
|
# MDEV-28971 - Assertion `total_length + thd->wsrep_sr().log_position() == saved_pos'
|
|
# failed in int wsrep_write_cache_inc(THD*, IO_CACHE*, size_t*)
|
|
#
|
|
|
|
--source include/galera_cluster.inc
|
|
|
|
CREATE SEQUENCE SEQ NOCACHE ENGINE=InnoDB;
|
|
SET SESSION wsrep_trx_fragment_size=1;
|
|
SET collation_connection=utf16_thai_520_w2;
|
|
SET autocommit=0;
|
|
CREATE TABLE t1 (a BLOB UNIQUE);
|
|
INSERT INTO t1 VALUES ('AAF');
|
|
--error ER_NOT_SUPPORTED_YET
|
|
SELECT SETVAL (SEQ, 100);
|
|
ALTER TABLE t1 ADD CONSTRAINT constraint_1 UNIQUE (a);
|
|
INSERT INTO t1 VALUES();
|
|
--error ER_KEY_COLUMN_DOES_NOT_EXITS
|
|
ALTER TABLE t1 ADD KEY(b (50));
|
|
DROP TABLE t1,SEQ;
|