Debian Codegraph @

mysql-test/suite/galera/r/MDEV-24143.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BINARY (10), c3 DATETIME);
4 SELECT get_lock ('test2', 0);
5 get_lock ('test2', 0)
6 1
7 DROP TABLE t1;
8 CREATE TABLE t1 (c1 SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
9 INSERT INTO t1 VALUES (1);
10 SET SESSION wsrep_trx_fragment_size=10;
11 SET SESSION autocommit=0;
12 SELECT * FROM t1 WHERE c1 <=0 ORDER BY c1 DESC;
13 c1
14 INSERT INTO t1 VALUES (4),(3),(1),(2);
15 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
16 CREATE TABLE t1 (pk INT PRIMARY KEY, b INT) ENGINE=SEQUENCE;
17 ERROR 42000: This version of MariaDB doesn't yet support 'non-InnoDB sequences in Galera cluster'
18 ALTER TABLE t1 DROP COLUMN c2;
19 ERROR 42000: Can't DROP COLUMN `c2`; check that it exists
20 SELECT get_lock ('test', 1.5);
21 get_lock ('test', 1.5)
22 1
23 DROP TABLE t1;