Debian Codegraph @

mysql-test/suite/period/t/innodb_debug.test

raw
1 --source include/have_innodb.inc
2 --source include/have_debug_sync.inc
3
4 --echo #
5 --echo # MDEV-37199 UNIQUE KEY USING HASH accepting duplicate records
6 --echo #
7
8 --echo ## INSERT
9 create table t1 (
10 id int, s date, e date,
11 period for p(s,e),
12 unique(id, p without overlaps)
13 ) engine=innodb;
14
15 start transaction;
16 select * from t1;
17 --connect con1,localhost,root
18 insert t1 values(10, date'2010-10-10', date'2010-11-11');
19 delete from t1;
20 set innodb_snapshot_isolation=0;
21 set transaction isolation level read committed;
22 set debug_sync="innodb_row_ins_step_enter SIGNAL checked_duplicate WAIT_FOR do_insert";
23 --send insert t1 values(10, date'2010-09-09', date'2010-11-10')
24 --connect con2,localhost,root
25 set debug_sync="now WAIT_FOR checked_duplicate";
26 set innodb_snapshot_isolation=0;
27 set transaction isolation level read committed;
28 insert t1 values(10, date'2010-10-10', date'2010-11-12');
29 set debug_sync="now SIGNAL do_insert";
30 --connection con1
31 --error ER_DUP_ENTRY
32 --reap
33 --connection default
34 select * from t1;
35 commit;
36 select * from t1;
37 --disconnect con1
38 --disconnect con2
39 set debug_sync='RESET';
40 drop table t1;
41
42 --echo ## UPDATE
43 create table t1 (
44 id int, s date, e date,
45 period for p(s,e),
46 unique(id, p without overlaps)
47 ) engine=innodb;
48
49 start transaction;
50 select * from t1;
51 --connect con1,localhost,root
52 insert t1 values(10, date'2010-10-10', date'2010-11-11');
53 delete from t1;
54 insert t1 values(10, date'2010-09-09', date'2010-09-10');
55 insert t1 values(10, date'2010-12-10', date'2010-12-12');
56 set innodb_snapshot_isolation=0;
57 set transaction isolation level read committed;
58 set debug_sync="innodb_row_update_for_mysql_begin SIGNAL checked_duplicate WAIT_FOR do_insert";
59 --send update t1 set e=e + interval 2 month where s=date'2010-09-09'
60 --connect con2,localhost,root
61 set debug_sync="now WAIT_FOR checked_duplicate";
62 set innodb_snapshot_isolation=0;
63 set transaction isolation level read committed;
64 update t1 set s=date'2010-10-10' where e=date'2010-12-12';
65 set debug_sync="now SIGNAL do_insert";
66 --connection con1
67 --error ER_DUP_ENTRY
68 --reap
69 --connection default
70 select * from t1;
71 commit;
72 select * from t1;
73 --disconnect con1
74 --disconnect con2
75 set debug_sync='RESET';
76 drop table t1;
77
78 --echo ## INSERT IGNORE
79 create table t1 (
80 id int, s date, e date,
81 period for p(s,e),
82 unique(id, p without overlaps)
83 ) engine=innodb;
84
85 start transaction;
86 select * from t1;
87 --connect con1,localhost,root
88 insert t1 values(10, date'2010-10-10', date'2010-11-11');
89 delete from t1;
90 set innodb_snapshot_isolation=0;
91 set transaction isolation level read committed;
92 set debug_sync="innodb_row_ins_step_enter SIGNAL checked_duplicate WAIT_FOR do_insert";
93 --send insert ignore t1 values(10, date'2010-09-09', date'2010-11-10'),(11, date'2010-09-09', date'2010-11-10')
94 --connect con2,localhost,root
95 set debug_sync="now WAIT_FOR checked_duplicate";
96 set innodb_snapshot_isolation=0;
97 set transaction isolation level read committed;
98 insert t1 values(10, date'2010-10-10', date'2010-11-12');
99 set debug_sync="now SIGNAL do_insert";
100 --connection con1
101 --reap
102 --connection default
103 select * from t1;
104 commit;
105 select * from t1;
106 --disconnect con1
107 --disconnect con2
108 set debug_sync='RESET';
109 drop table t1;
110
111 --echo ## UPDATE IGNORE
112 create table t1 (
113 id int, s date, e date,
114 period for p(s,e),
115 unique(id, p without overlaps)
116 ) engine=innodb;
117
118 start transaction;
119 select * from t1;
120 --connect con1,localhost,root
121 insert t1 values(10, date'2010-10-10', date'2010-11-11');
122 delete from t1;
123 insert t1 values(10, date'2010-09-09', date'2010-09-10');
124 insert t1 values(10, date'2010-12-10', date'2010-12-12');
125 set innodb_snapshot_isolation=0;
126 set transaction isolation level read committed;
127 set debug_sync="innodb_row_update_for_mysql_begin SIGNAL checked_duplicate WAIT_FOR do_insert";
128 --send update ignore t1 set e=e + interval 2 month where s=date'2010-09-09'
129 --connect con2,localhost,root
130 set debug_sync="now WAIT_FOR checked_duplicate";
131 set innodb_snapshot_isolation=0;
132 set transaction isolation level read committed;
133 update t1 set s=date'2010-10-10' where e=date'2010-12-12';
134 set debug_sync="now SIGNAL do_insert";
135 --connection con1
136 --error ER_NOT_SUPPORTED_YET
137 --reap
138 --connection default
139 select * from t1;
140 commit;
141 select * from t1;
142 --disconnect con1
143 --disconnect con2
144 set debug_sync='RESET';
145 drop table t1;
146
147 --echo ## UPDATE modifying PK
148 create table t1 (
149 id int, s date, e date,
150 period for p(s,e),
151 primary key (id, p without overlaps)
152 ) engine=innodb;
153
154 start transaction;
155 select * from t1;
156 --connect con1,localhost,root
157 insert t1 values(10, date'2010-10-10', date'2010-11-11');
158 delete from t1;
159 insert t1 values(10, date'2010-09-09', date'2010-09-10');
160 insert t1 values(10, date'2010-12-10', date'2010-12-12');
161 set innodb_snapshot_isolation=0;
162 set transaction isolation level read committed;
163 set debug_sync="innodb_row_update_for_mysql_begin SIGNAL checked_duplicate WAIT_FOR do_insert";
164 --send update t1 set e=e + interval 2 month where s=date'2010-09-09'
165 --connect con2,localhost,root
166 set debug_sync="now WAIT_FOR checked_duplicate";
167 set innodb_snapshot_isolation=0;
168 set transaction isolation level read committed;
169 update t1 set s=date'2010-10-10' where e=date'2010-12-12';
170 set debug_sync="now SIGNAL do_insert";
171 --connection con1
172 --error ER_DUP_ENTRY
173 --reap
174 --connection default
175 select * from t1;
176 commit;
177 select * from t1;
178 --disconnect con1
179 --disconnect con2
180 set debug_sync='RESET';
181 drop table t1;
182
183 --echo ## UPDATE IGNORE modifying PK
184 create table t1 (
185 id int, s date, e date,
186 period for p(s,e),
187 primary key (id, p without overlaps)
188 ) engine=innodb;
189
190 start transaction;
191 select * from t1;
192 --connect con1,localhost,root
193 insert t1 values(10, date'2010-10-10', date'2010-11-11');
194 delete from t1;
195 insert t1 values(10, date'2010-09-09', date'2010-09-10');
196 insert t1 values(10, date'2010-12-10', date'2010-12-12');
197 set innodb_snapshot_isolation=0;
198 set transaction isolation level read committed;
199 set debug_sync="innodb_row_update_for_mysql_begin SIGNAL checked_duplicate WAIT_FOR do_insert";
200 --send update ignore t1 set e=e + interval 2 month where s=date'2010-09-09'
201 --connect con2,localhost,root
202 set debug_sync="now WAIT_FOR checked_duplicate";
203 set innodb_snapshot_isolation=0;
204 set transaction isolation level read committed;
205 update t1 set s=date'2010-10-10' where e=date'2010-12-12';
206 set debug_sync="now SIGNAL do_insert";
207 --connection con1
208 --error ER_NOT_SUPPORTED_YET
209 --reap
210 --connection default
211 select * from t1;
212 commit;
213 select * from t1;
214 --disconnect con1
215 --disconnect con2
216 set debug_sync='RESET';
217 drop table t1;
218
219
220 --echo # End of 10.6 tests
221