Debian Codegraph @

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

raw
1 CREATE TABLE t (
2 `c0000` INT NOT NULL,
3 `c0003` TINYINT NOT NULL,
4 `c0004` INT NOT NULL,
5 PRIMARY KEY (`c0000`,`c0003`,`c0004`)
6 )
7 PARTITION BY KEY (c0003) PARTITIONS 6;
8 INSERT INTO t VALUES (123,12,0);
9 INSERT INTO t VALUES (122,13,0);
10 BEGIN;
11 SELECT * FROM t WHERE `c0000` = 122 AND `c0003` = 13 FOR UPDATE;
12 c0000 c0003 c0004
13 122 13 0
14 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
15 BEGIN;
16 UPDATE t SET `c0003` = 16 WHERE `c0004`;
17 COMMIT;
18 COMMIT;
19 DROP TABLE t;
20 CREATE TABLE t (
21 `c0000` INT NOT NULL,
22 `c0003` TINYINT NOT NULL,
23 `c0004` INT NOT NULL,
24 PRIMARY KEY (`c0000`,`c0003`,`c0004`)
25 )
26 PARTITION BY KEY (c0003) PARTITIONS 6;
27 INSERT INTO t VALUES (121,13,0);
28 INSERT INTO t VALUES (123,12,0);
29 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
30 BEGIN;
31 SELECT * FROM t WHERE `c0000` = 121 AND `c0003` = 13 AND `c0004` = 0 FOR UPDATE;
32 c0000 c0003 c0004
33 121 13 0
34 SELECT LOCK_DATA
35 FROM performance_schema.data_locks
36 WHERE LOCK_TYPE = 'RECORD' AND OBJECT_NAME = 't';
37 LOCK_DATA
38 121, 13, 0
39 UPDATE t SET `c0003` = 16 WHERE `c0004`;
40 SELECT LOCK_DATA
41 FROM performance_schema.data_locks
42 WHERE LOCK_TYPE = 'RECORD' AND OBJECT_NAME = 't';
43 LOCK_DATA
44 121, 13, 0
45 COMMIT;
46 DROP TABLE t;
47 CREATE TABLE t (
48 `c0000` INT NOT NULL,
49 `c0003` TINYINT NOT NULL,
50 `c0004` INT NOT NULL,
51 PRIMARY KEY (`c0000`,`c0003`,`c0004`)
52 )
53 PARTITION BY KEY (c0003) PARTITIONS 6;
54 INSERT INTO t VALUES (1,10,0);
55 INSERT INTO t VALUES (2,11,0);
56 INSERT INTO t VALUES (4,13,0);
57 INSERT INTO t VALUES (5,14,0);
58 INSERT INTO t VALUES (6,15,0);
59 INSERT INTO t VALUES (7,16,0);
60 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
61 BEGIN;
62 SELECT LOCK_DATA
63 FROM performance_schema.data_locks
64 WHERE LOCK_TYPE = 'RECORD' AND OBJECT_NAME = 't';
65 LOCK_DATA
66 UPDATE t SET `c0003` = 16 WHERE `c0004`;
67 SELECT LOCK_DATA
68 FROM performance_schema.data_locks
69 WHERE LOCK_TYPE = 'RECORD' AND OBJECT_NAME = 't';
70 LOCK_DATA
71 COMMIT;
72 DROP TABLE t;