Debian Codegraph @

mysql-test/suite/galera/t/MDEV-24143.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_sequence.inc
3
4 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BINARY (10), c3 DATETIME);
5 SELECT get_lock ('test2', 0);
6 DROP TABLE t1;
7 CREATE TABLE t1 (c1 SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
8 INSERT INTO t1 VALUES (1);
9 SET SESSION wsrep_trx_fragment_size=10;
10 SET SESSION autocommit=0;
11 SELECT * FROM t1 WHERE c1 <=0 ORDER BY c1 DESC;
12 --error ER_LOCK_DEADLOCK
13 INSERT INTO t1 VALUES (4),(3),(1),(2);
14 #
15 # This is because support for CREATE TABLE ENGINE=SEQUENCE
16 # is done before we check does table exists already.
17 #
18 --error ER_NOT_SUPPORTED_YET
19 CREATE TABLE t1 (pk INT PRIMARY KEY, b INT) ENGINE=SEQUENCE;
20 --error ER_CANT_DROP_FIELD_OR_KEY
21 ALTER TABLE t1 DROP COLUMN c2;
22 SELECT get_lock ('test', 1.5);
23 DROP TABLE t1;