1
drop table if exists t1;
2
CREATE TABLE t1 (c1 int, c2 text, c3 blob) ENGINE=blackhole;
3
INSERT INTO t1 VALUES (111, "aaaa", "aaaa");
4
INSERT INTO t1 VALUES (222, "bbbb", "bbbb");
5
INSERT INTO t1 VALUES (333, "cccc", "cccc");
8
UPDATE t1 SET c2 = "xxxx" WHERE c1 = 111;
9
UPDATE t1 SET c2 = "yyyy" WHERE c1 = 222;
10
UPDATE t1 SET c2 = "zzzz" WHERE c1 = 333;
13
REPLACE INTO t1 VALUES (1, "one", "one");
14
REPLACE INTO t1 VALUES (2, "two", "two");
15
REPLACE INTO t1 VALUES (3, "three", "three");
18
DELETE FROM t1 WHERE c1 = 111;
19
DELETE FROM t1 WHERE c1 = 222;
24
CREATE TABLE t1 (id int primary key, c1 int, c2 double) ENGINE=blackhole;
25
INSERT INTO t1 VALUES (1, 1111, 11.111);
26
INSERT INTO t1 VALUES (2, 2222, 22.222);
27
INSERT INTO t1 VALUES (3, 3333, 33.333);
28
CREATE TABLE t5 (a int) ENGINE=BLACKHOLE;
29
INSERT INTO t5 VALUES (1);
30
FLUSH TABLES WITH READ LOCK;
31
INSERT INTO t5 VALUES (1);
32
ERROR HY000: Can't execute the query because you have a conflicting read lock
34
INSERT INTO t5 VALUES (1);
35
FLUSH TABLES WITH READ LOCK;
37
ERROR HY000: Can't execute the query because you have a conflicting read lock
39
INSERT INTO t5 VALUES (1);
43
CREATE TABLE A (A INT) ENGINE=BLACKHOLE;