Debian Codegraph @

mysql-test/suite/innodb/r/lock_insert_into_empty.result

raw
1 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
2 CREATE TABLE t2 (a INT PRIMARY KEY) ENGINE=InnoDB;
3 INSERT INTO t1 VALUES(0);
4 BEGIN;
5 DELETE FROM t1;
6 INSERT INTO t2 VALUES(1),(1);
7 ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
8 BEGIN;
9 SELECT * FROM t2 LOCK IN SHARE MODE;
10 a
11 connect con1,localhost,root,,;
12 SET innodb_lock_wait_timeout=0;
13 INSERT INTO t2 VALUES(2);
14 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
15 connection default;
16 ROLLBACK;
17 connection con1;
18 INSERT INTO t2 VALUES(3);
19 COMMIT;
20 disconnect con1;
21 connection default;
22 SELECT * FROM t1;
23 a
24 SELECT * FROM t2;
25 a
26 3
27 DROP TABLE t1, t2;
28 #
29 # MDEV-24700 Assertion "lock not found"==0 in lock_table_x_unlock()
30 #
31 SET FOREIGN_KEY_CHECKS=OFF;
32 CREATE TABLE t1 (id INT PRIMARY KEY, f INT REFERENCES nonexistent(x))
33 ENGINE=InnoDB;
34 SET FOREIGN_KEY_CHECKS=ON;
35 BEGIN;
36 INSERT IGNORE INTO t1 VALUES (1,11);
37 Warnings:
38 Warning 1452 Cannot add or update a child row: a foreign key constraint fails (`test`.`t1`, CONSTRAINT `t1_ibfk_1` FOREIGN KEY (`f`) REFERENCES `nonexistent` (`x`))
39 REPLACE INTO t1 VALUES (1,12);
40 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`t1`, CONSTRAINT `t1_ibfk_1` FOREIGN KEY (`f`) REFERENCES `nonexistent` (`x`))
41 COMMIT;
42 DROP TABLE t1;
43 #
44 # MDEV-25942 Assertion failed in trx_t::drop_table()
45 #
46 CREATE TABLE t1 (k INT PRIMARY KEY) ENGINE=InnoDB;
47 INSERT INTO t1 SET k=1;
48 START TRANSACTION;
49 INSERT INTO t1 SET k=2;
50 SELECT count(*) > 0 FROM mysql.innodb_index_stats lock in share mode;
51 count(*) > 0
52 1
53 connect con1,localhost,root,,test;
54 SET innodb_lock_wait_timeout=0;
55 CREATE TABLE t2 (pk INT AUTO_INCREMENT PRIMARY KEY) ENGINE=InnoDB
56 AS SELECT k FROM t1;
57 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
58 disconnect con1;
59 connection default;
60 SET innodb_lock_wait_timeout=default;
61 DROP TABLE t1;
62 DROP TABLE IF EXISTS t2;