Debian Codegraph @

mysql-test/suite/engines/rr_trx/r/rr_u_10-19_nolimit.result

raw
1 SET autocommit = 0;
2
3 *** Move record out of locked portion of index:
4
5 START TRANSACTION;
6 *** Disabling result log (result will vary)
7 SELECT * FROM t1 WHERE `int1_key` BETWEEN 981 + (CONNECTION_ID() MOD 15) AND 1030 ORDER BY `int1_key`, `pk` FOR UPDATE;
8 SELECT @pk:=`pk` FROM t1 WHERE `int1_key` BETWEEN 981 + (CONNECTION_ID() MOD 15) AND 1030 ORDER BY `int1_key`, `pk` LIMIT 1;
9 *** Enabling result log
10 UPDATE t1 SET `int1_key` = `int1_key` + 50,
11 `int2_key` = `int2_key` - 50,
12 `id` = 10,
13 `connection_id` = CONNECTION_ID(),
14 `is_consistent` = IF(`int1` + `int2` + `int1_key` + `int2_key` + `int1_unique` + `int2_unique` = 0, 1, 0),
15 `thread_id` = 0
16 WHERE `pk` = @pk;
17 COMMIT;
18
19 *** Move record out of locked portion of UNIQUE index:
20
21 START TRANSACTION;
22 *** Disabling result log (result will vary)
23 SELECT * FROM t1 WHERE `int1_unique` BETWEEN 981 + (CONNECTION_ID() MOD 15) AND 1030 ORDER BY `int1_unique` FOR UPDATE;
24 SELECT @pk:=`pk` FROM t1 WHERE `int1_unique` BETWEEN 981 + (CONNECTION_ID() MOD 15) AND 1030 ORDER BY `int1_unique` LIMIT 1;
25 *** Enabling result log
26 UPDATE t1 SET `int1_unique` = `int1_unique` + 50 + CONNECTION_ID(),
27 `int2_unique` = `int2_unique` - 50 - CONNECTION_ID(),
28 `id` = 11,
29 `connection_id` = CONNECTION_ID(),
30 `is_consistent` = IF(`int1` + `int2` + `int1_key` + `int2_key` + `int1_unique` + `int2_unique` = 0, 1, 0),
31 `thread_id` = 0
32 WHERE `pk` = @pk;
33 COMMIT;
34
35 *** Move record into locked portion of index:
36
37 START TRANSACTION;
38 *** Disabling result log (result will vary)
39 SELECT * FROM t1 WHERE `int1_key` BETWEEN 981 + (CONNECTION_ID() MOD 15) AND 1030 ORDER BY `int1_key`, `pk` FOR UPDATE;
40 SELECT @pk:=`pk` FROM t1 WHERE `int1_key` > 1030 ORDER BY `int1_key`, `pk` LIMIT 1;
41 *** Enabling result log
42 UPDATE t1 SET `int1_key` = `int1_key` + 50,
43 `int2_key` = `int2_key` - 50,
44 `id` = 12,
45 `connection_id` = CONNECTION_ID(),
46 `is_consistent` = IF(`int1` + `int2` + `int1_key` + `int2_key` + `int1_unique` + `int2_unique` = 0, 1, 0),
47 `thread_id` = 0
48 WHERE `pk` = @pk;
49 COMMIT;
50
51 *** Move record inside locked portion of index (move it but stay inside the locked range):
52
53 START TRANSACTION;
54 *** Disabling result log (result will vary)
55 SELECT * FROM t1 WHERE `int1_key` BETWEEN 981 + (CONNECTION_ID() MOD 15) AND 1030 ORDER BY `int1_key`, `pk` FOR UPDATE;
56 SELECT @pk:=`pk` FROM t1 WHERE `int1_key` BETWEEN 981 + 10 + (CONNECTION_ID() MOD 15) AND 1019 ORDER BY `int1_key`, `pk` LIMIT 1;
57 *** Enabling result log
58 UPDATE t1 SET `int1_key` = `int1_key` - 10,
59 `int2_key` = `int2_key` + 10,
60 `id` = 13,
61 `connection_id` = CONNECTION_ID(),
62 `is_consistent` = IF(`int1` + `int2` + `int1_key` + `int2_key` + `int1_unique` + `int2_unique` = 0, 1, 0),
63 `thread_id` = 0
64 WHERE `pk` = @pk;
65 COMMIT;
66
67 *** Move record outside existing index boundary (max):
68
69 START TRANSACTION;
70 *** Disabling result log (results will vary)
71 SELECT @max:=MAX(`int2_key`), @pk:=FLOOR(1 + RAND() * (MAX(`pk`) - 1)) FROM t1;
72 SELECT * FROM t1 WHERE `pk` = @pk FOR UPDATE;
73 SELECT @old:=`int2_key`, (@sum:=`int1` + `int2` + `int1_key` + `int2_key` + `int1_unique` + `int2_unique`) FROM t1 WHERE `pk` = @pk;
74 *** Enabling result log
75 UPDATE t1 SET `int2_key` = @max + 1,
76 `int2` = `int2` - (@max + 1 - @old),
77 `id` = 14,
78 `connection_id` = CONNECTION_ID(),
79 `is_consistent` = IF(@sum = 0, 1, 0),
80 `thread_id` = 0
81 WHERE `pk` = @pk;
82 COMMIT;
83
84 *** Move record outside existing UNIQUE index boundary (max):
85
86 START TRANSACTION;
87 *** Disabling result log (results will vary)
88 SELECT @max:=MAX(`int2_unique`), @pk:=FLOOR(1 + RAND() * (MAX(`pk`) - 1)) FROM t1;
89 SELECT * FROM t1 WHERE `pk` = @pk FOR UPDATE;
90 SELECT @old:=`int2_unique`, (@sum:=`int1` + `int2` + `int1_key` + `int2_key` + `int1_unique` + `int2_unique`) FROM t1 WHERE `pk` = @pk;
91 *** Enabling result log
92 UPDATE t1 SET `int2_unique` = @max + 1,
93 `int2` = `int2` - (@max + 1 - @old),
94 `id` = 15,
95 `connection_id` = CONNECTION_ID(),
96 `is_consistent` = IF(@sum = 0, 1, 0),
97 `thread_id` = 0
98 WHERE `pk` = @pk;
99 COMMIT;
100
101 *** Move record outside existing index boundary (min):
102
103 START TRANSACTION;
104 *** Disabling result log (results will vary)
105 SELECT @min:=MIN(`int1_key`), @pk:=FLOOR(1 + RAND() * (MAX(`pk`) - 1)) FROM t1;
106 SELECT * FROM t1 WHERE `pk` = @pk FOR UPDATE;
107 SELECT @old:=`int1_key`, (@sum:=`int1` + `int2` + `int1_key` + `int2_key` + `int1_unique` + `int2_unique`) FROM t1 WHERE `pk` = @pk;
108 *** Enabling result log
109 UPDATE t1 SET `int1_key` = @min - 1,
110 `int1` = `int1` - (@min - 1 - @old),
111 `id` = 16,
112 `connection_id` = CONNECTION_ID(),
113 `is_consistent` = IF(@sum = 0, 1, 0),
114 `thread_id` = 0
115 WHERE `pk` = @pk;
116 COMMIT;
117
118 *** Move record outside existing UNIQUE index boundary (min):
119
120 START TRANSACTION;
121 *** Disabling result log (results will vary)
122 SELECT @min:=MIN(`int1_unique`), @pk:=FLOOR(1 + RAND() * (MAX(`pk`) - 1)) FROM t1;
123 SELECT * FROM t1 WHERE `pk` = @pk FOR UPDATE;
124 SELECT @old:=`int1_unique`, (@sum:=`int1` + `int2` + `int1_key` + `int2_key` + `int1_unique` + `int2_unique`) FROM t1 WHERE `pk` = @pk;
125 *** Enabling result log
126 UPDATE t1 SET `int1_unique` = @min - 1,
127 `int1` = `int1` - (@min - 1 - @old),
128 `id` = 17,
129 `connection_id` = CONNECTION_ID(),
130 `is_consistent` = IF(@sum = 0, 1, 0),
131 `thread_id` = 0
132 WHERE `pk` = @pk;
133 COMMIT;
134
135 *** Move record forward in index (add some number):
136
137 START TRANSACTION;
138 UPDATE t1 SET `int2_key` = `int2_key` + 16,
139 `int2` = `int2` - 16,
140 `id` = 18,
141 `connection_id` = CONNECTION_ID(),
142 `thread_id` = 0
143 WHERE `pk` = CONNECTION_ID() MOD 1000;
144
145 *** Move record backward in index (subtract some number):
146
147 UPDATE t1 SET `int1_key` = `int1_key` - 16,
148 `int1` = `int1` + 16,
149 `id` = 18,
150 `connection_id` = CONNECTION_ID(),
151 `thread_id` = 0
152 WHERE `pk` = CONNECTION_ID() + 16 MOD 1000;
153 COMMIT;