Debian Codegraph @

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

raw
1 SET @save_timeout=@@GLOBAL.innodb_lock_wait_timeout;
2 SET GLOBAL innodb_lock_wait_timeout=100000000;
3 CREATE TABLE t_min (
4 c01 TINYINT,
5 c02 TINYINT UNSIGNED,
6 c03 SMALLINT,
7 c04 SMALLINT UNSIGNED,
8 c05 MEDIUMINT,
9 c06 MEDIUMINT UNSIGNED,
10 c07 INT,
11 c08 INT UNSIGNED,
12 c09 BIGINT,
13 c10 BIGINT UNSIGNED,
14 PRIMARY KEY(c01, c02, c03, c04, c05, c06, c07, c08, c09, c10)
15 ) ENGINE=INNODB;;
16 INSERT INTO t_min VALUES
17 (-128, 0,
18 -32768, 0,
19 -8388608, 0,
20 -2147483648, 0,
21 -9223372036854775808, 0);
22 CREATE TABLE t_max (
23 c01 TINYINT,
24 c02 TINYINT UNSIGNED,
25 c03 SMALLINT,
26 c04 SMALLINT UNSIGNED,
27 c05 MEDIUMINT,
28 c06 MEDIUMINT UNSIGNED,
29 c07 INT,
30 c08 INT UNSIGNED,
31 c09 BIGINT,
32 c10 BIGINT UNSIGNED,
33 PRIMARY KEY(c01, c02, c03, c04, c05, c06, c07, c08, c09, c10)
34 ) ENGINE=INNODB;;
35 INSERT INTO t_max VALUES
36 (127, 255,
37 32767, 65535,
38 8388607, 16777215,
39 2147483647, 4294967295,
40 9223372036854775807, 18446744073709551615);
41 CREATE TABLE ```t'\"_str` (
42 c1 VARCHAR(32),
43 c2 VARCHAR(32),
44 c3 VARCHAR(32),
45 c4 VARCHAR(32),
46 c5 VARCHAR(32),
47 c6 VARCHAR(32),
48 c7 VARCHAR(32),
49 PRIMARY KEY(c1, c2, c3, c4, c5, c6, c7)
50 ) ENGINE=INNODB;
51 INSERT INTO ```t'\"_str` VALUES
52 ('1', 'abc', '''abc', 'abc''', 'a''bc', 'a''bc''', '''abc''''');
53 INSERT INTO ```t'\"_str` VALUES
54 ('2', 'abc', '"abc', 'abc"', 'a"bc', 'a"bc"', '"abc""');
55 INSERT INTO ```t'\"_str` VALUES
56 ('3', 'abc', '\\abc', 'abc\\', 'a\\bc', 'a\\bc\\', '\\abc\\\\');
57 INSERT INTO ```t'\"_str` VALUES
58 ('4', 'abc', 0x00616263, 0x61626300, 0x61006263, 0x6100626300, 0x610062630000);
59 connect con_lock,localhost,root,,;
60 connect con_min_trylock,localhost,root,,;
61 connect con_max_trylock,localhost,root,,;
62 connect con_str_insert_supremum,localhost,root,,;
63 connect con_str_lock_row1,localhost,root,,;
64 connect con_str_lock_row2,localhost,root,,;
65 connect con_str_lock_row3,localhost,root,,;
66 connect con_str_lock_row4,localhost,root,,;
67 connect con_verify_innodb_locks,localhost,root,,;
68 connection con_lock;
69 SET autocommit=0;
70 SELECT * FROM t_min FOR UPDATE;
71 c01 c02 c03 c04 c05 c06 c07 c08 c09 c10
72 -128 0 -32768 0 -8388608 0 -2147483648 0 -9223372036854775808 0
73 SELECT * FROM t_max FOR UPDATE;
74 c01 c02 c03 c04 c05 c06 c07 c08 c09 c10
75 127 255 32767 65535 8388607 16777215 2147483647 4294967295 9223372036854775807 18446744073709551615
76 SELECT * FROM ```t'\"_str` FOR UPDATE;
77 c1 c2 c3 c4 c5 c6 c7
78 1 abc 'abc abc' a'bc a'bc' 'abc''
79 2 abc "abc abc" a"bc a"bc" "abc""
80 3 abc \abc abc\ a\bc a\bc\ \abc\\
81 4 abc abc abc abc abc abc
82 connection con_min_trylock;
83 SELECT * FROM t_min FOR UPDATE;
84 connection con_max_trylock;
85 SELECT * FROM t_max FOR UPDATE;
86 connection con_str_insert_supremum;
87 INSERT INTO ```t'\"_str` VALUES
88 ('z', 'z', 'z', 'z', 'z', 'z', 'z');
89 connection con_str_lock_row1;
90 SELECT * FROM ```t'\"_str` WHERE c1 = '1' FOR UPDATE;
91 connection con_str_lock_row2;
92 SELECT * FROM ```t'\"_str` WHERE c1 = '2' FOR UPDATE;
93 connection con_str_lock_row3;
94 SELECT * FROM ```t'\"_str` WHERE c1 = '3' FOR UPDATE;
95 connection con_str_lock_row4;
96 SELECT * FROM ```t'\"_str` WHERE c1 = '4' FOR UPDATE;
97 connection con_verify_innodb_locks;
98 SELECT lock_mode, lock_type, lock_table, lock_index, lock_rec, lock_data
99 FROM INFORMATION_SCHEMA.INNODB_LOCKS ORDER BY lock_data;
100 lock_mode lock_type lock_table lock_index lock_rec lock_data
101 X RECORD `test`.```t'\"_str` PRIMARY 2 '1', 'abc', '''abc', 'abc''', 'a''bc', 'a''bc''', '''abc'''''
102 X RECORD `test`.```t'\"_str` PRIMARY 2 '1', 'abc', '''abc', 'abc''', 'a''bc', 'a''bc''', '''abc'''''
103 X RECORD `test`.```t'\"_str` PRIMARY 3 '2', 'abc', '"abc', 'abc"', 'a"bc', 'a"bc"', '"abc""'
104 X RECORD `test`.```t'\"_str` PRIMARY 3 '2', 'abc', '"abc', 'abc"', 'a"bc', 'a"bc"', '"abc""'
105 X RECORD `test`.```t'\"_str` PRIMARY 4 '3', 'abc', '\\abc', 'abc\\', 'a\\bc', 'a\\bc\\', '\\abc\\\\'
106 X RECORD `test`.```t'\"_str` PRIMARY 4 '3', 'abc', '\\abc', 'abc\\', 'a\\bc', 'a\\bc\\', '\\abc\\\\'
107 X RECORD `test`.```t'\"_str` PRIMARY 5 '4', 'abc', '\0abc', 'abc\0', 'a\0bc', 'a\0bc\0', 'a\0bc\0\0'
108 X RECORD `test`.```t'\"_str` PRIMARY 5 '4', 'abc', '\0abc', 'abc\0', 'a\0bc', 'a\0bc\0', 'a\0bc\0\0'
109 X RECORD `test`.`t_min` PRIMARY 2 -128, 0, -32768, 0, -8388608, 0, -2147483648, 0, -9223372036854775808, 0
110 X RECORD `test`.`t_min` PRIMARY 2 -128, 0, -32768, 0, -8388608, 0, -2147483648, 0, -9223372036854775808, 0
111 X RECORD `test`.`t_max` PRIMARY 2 127, 255, 32767, 65535, 8388607, 16777215, 2147483647, 4294967295, 9223372036854775807, 18446744073709551615
112 X RECORD `test`.`t_max` PRIMARY 2 127, 255, 32767, 65535, 8388607, 16777215, 2147483647, 4294967295, 9223372036854775807, 18446744073709551615
113 X RECORD `test`.```t'\"_str` PRIMARY 1 supremum pseudo-record
114 X RECORD `test`.```t'\"_str` PRIMARY 1 supremum pseudo-record
115 SELECT lock_table, COUNT(*) FROM INFORMATION_SCHEMA.INNODB_LOCKS
116 GROUP BY lock_table;
117 lock_table COUNT(*)
118 `test`.`t_max` 2
119 `test`.`t_min` 2
120 `test`.```t'\"_str` 10
121 set @save_sql_mode = @@sql_mode;
122 SET SQL_MODE='ANSI_QUOTES';
123 SELECT lock_table, COUNT(*) FROM INFORMATION_SCHEMA.INNODB_LOCKS
124 GROUP BY lock_table;
125 lock_table COUNT(*)
126 "test"."t_max" 2
127 "test"."t_min" 2
128 "test"."`t'\""_str" 10
129 SET @@sql_mode=@save_sql_mode;
130 connection con_lock;
131 COMMIT;
132 connection default;
133 disconnect con_lock;
134 disconnect con_min_trylock;
135 disconnect con_max_trylock;
136 disconnect con_str_insert_supremum;
137 disconnect con_str_lock_row1;
138 disconnect con_str_lock_row2;
139 disconnect con_str_lock_row3;
140 disconnect con_str_lock_row4;
141 disconnect con_verify_innodb_locks;
142 DROP TABLE t_min, t_max, ```t'\"_str`;
143 SET GLOBAL innodb_lock_wait_timeout=@save_timeout;