1
SET GLOBAL innodb_lock_wait_timeout=600;
2
DROP TABLE IF EXISTS t_min, t_max;
9
c06 MEDIUMINT UNSIGNED,
14
PRIMARY KEY(c01, c02, c03, c04, c05, c06, c07, c08, c09, c10)
16
INSERT INTO t_min VALUES
21
-9223372036854775808, 0);
26
c04 SMALLINT UNSIGNED,
28
c06 MEDIUMINT UNSIGNED,
33
PRIMARY KEY(c01, c02, c03, c04, c05, c06, c07, c08, c09, c10)
35
INSERT INTO t_max VALUES
39
2147483647, 4294967295,
40
9223372036854775807, 18446744073709551615);
41
CREATE TABLE ```t'\"_str` (
49
PRIMARY KEY(c1, c2, c3, c4, c5, c6, c7)
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);
60
SELECT * FROM t_min FOR UPDATE;
61
c01 c02 c03 c04 c05 c06 c07 c08 c09 c10
62
-128 0 -32768 0 -8388608 0 -2147483648 0 -9223372036854775808 0
63
SELECT * FROM t_max FOR UPDATE;
64
c01 c02 c03 c04 c05 c06 c07 c08 c09 c10
65
127 255 32767 65535 8388607 16777215 2147483647 4294967295 9223372036854775807 18446744073709551615
66
SELECT * FROM ```t'\"_str` FOR UPDATE;
68
1 abc 'abc abc' a'bc a'bc' 'abc''
69
2 abc "abc abc" a"bc a"bc" "abc""
70
3 abc \abc abc\ a\bc a\bc\ \abc\\