1
# generated by tokudb_update_decr_floor.py
2
source include/have_tokudb.inc;
3
source include/have_innodb.inc;
4
set default_storage_engine='tokudb';
6
drop table if exists t;
8
set tokudb_disable_slow_update=1;
10
id tinyint null primary key,
13
insert into tt values (1,4);
14
create table ti like tt;
15
alter table ti engine=innodb;
16
insert into ti select * from tt;
17
replace_regex /MariaDB/XYZ/ /MySQL/XYZ/;
18
error ER_UNSUPPORTED_EXTENSION;
19
update noar tt set x=if(x=0,0,x-1) where id=1;
22
id tinyint not null primary key,
25
insert into tt values (1,4);
26
create table ti like tt;
27
alter table ti engine=innodb;
28
insert into ti select * from tt;
29
replace_regex /MariaDB/XYZ/ /MySQL/XYZ/;
30
error ER_UNSUPPORTED_EXTENSION;
31
update noar tt set x=if(x=0,0,x-1) where id=1;
34
id tinyint unsigned null primary key,
35
x tinyint unsigned null
37
insert into tt values (1,4);
38
create table ti like tt;
39
alter table ti engine=innodb;
40
insert into ti select * from tt;
41
update noar tt set x=if(x=0,0,x-1) where id=1;
42
update noar ti set x=if(x=0,0,x-1) where id=1;
43
update noar tt set x=if(x=0,0,x-1) where id=1;
44
update noar ti set x=if(x=0,0,x-1) where id=1;
45
update noar tt set x=if(x=0,0,x-1) where id=1;
46
update noar ti set x=if(x=0,0,x-1) where id=1;
47
update noar tt set x=if(x=0,0,x-1) where id=1;
48
update noar ti set x=if(x=0,0,x-1) where id=1;
49
# try to decrement when x=0
50
update noar tt set x=if(x=0,0,x-1) where id=1;
51
update noar ti set x=if(x=0,0,x-1) where id=1;
52
let $diff_tables = test.tt, test.ti;
53
source include/diff_tables.inc;
56
id tinyint unsigned not null primary key,
57
x tinyint unsigned not null
59
insert into tt values (1,4);
60
create table ti like tt;
61
alter table ti engine=innodb;
62
insert into ti select * from tt;
63
update noar tt set x=if(x=0,0,x-1) where id=1;
64
update noar ti set x=if(x=0,0,x-1) where id=1;
65
update noar tt set x=if(x=0,0,x-1) where id=1;
66
update noar ti set x=if(x=0,0,x-1) where id=1;
67
update noar tt set x=if(x=0,0,x-1) where id=1;
68
update noar ti set x=if(x=0,0,x-1) where id=1;
69
update noar tt set x=if(x=0,0,x-1) where id=1;
70
update noar ti set x=if(x=0,0,x-1) where id=1;
71
# try to decrement when x=0
72
update noar tt set x=if(x=0,0,x-1) where id=1;
73
update noar ti set x=if(x=0,0,x-1) where id=1;
74
let $diff_tables = test.tt, test.ti;
75
source include/diff_tables.inc;
78
id smallint null primary key,
81
insert into tt values (1,4);
82
create table ti like tt;
83
alter table ti engine=innodb;
84
insert into ti select * from tt;
85
replace_regex /MariaDB/XYZ/ /MySQL/XYZ/;
86
error ER_UNSUPPORTED_EXTENSION;
87
update noar tt set x=if(x=0,0,x-1) where id=1;
90
id smallint not null primary key,
93
insert into tt values (1,4);
94
create table ti like tt;
95
alter table ti engine=innodb;
96
insert into ti select * from tt;
97
replace_regex /MariaDB/XYZ/ /MySQL/XYZ/;
98
error ER_UNSUPPORTED_EXTENSION;
99
update noar tt set x=if(x=0,0,x-1) where id=1;
102
id smallint unsigned null primary key,
103
x smallint unsigned null
105
insert into tt values (1,4);
106
create table ti like tt;
107
alter table ti engine=innodb;
108
insert into ti select * from tt;
109
update noar tt set x=if(x=0,0,x-1) where id=1;
110
update noar ti set x=if(x=0,0,x-1) where id=1;
111
update noar tt set x=if(x=0,0,x-1) where id=1;
112
update noar ti set x=if(x=0,0,x-1) where id=1;
113
update noar tt set x=if(x=0,0,x-1) where id=1;
114
update noar ti set x=if(x=0,0,x-1) where id=1;
115
update noar tt set x=if(x=0,0,x-1) where id=1;
116
update noar ti set x=if(x=0,0,x-1) where id=1;
117
# try to decrement when x=0
118
update noar tt set x=if(x=0,0,x-1) where id=1;
119
update noar ti set x=if(x=0,0,x-1) where id=1;
120
let $diff_tables = test.tt, test.ti;
121
source include/diff_tables.inc;
124
id smallint unsigned not null primary key,
125
x smallint unsigned not null
127
insert into tt values (1,4);
128
create table ti like tt;
129
alter table ti engine=innodb;
130
insert into ti select * from tt;
131
update noar tt set x=if(x=0,0,x-1) where id=1;
132
update noar ti set x=if(x=0,0,x-1) where id=1;
133
update noar tt set x=if(x=0,0,x-1) where id=1;
134
update noar ti set x=if(x=0,0,x-1) where id=1;
135
update noar tt set x=if(x=0,0,x-1) where id=1;
136
update noar ti set x=if(x=0,0,x-1) where id=1;
137
update noar tt set x=if(x=0,0,x-1) where id=1;
138
update noar ti set x=if(x=0,0,x-1) where id=1;
139
# try to decrement when x=0
140
update noar tt set x=if(x=0,0,x-1) where id=1;
141
update noar ti set x=if(x=0,0,x-1) where id=1;
142
let $diff_tables = test.tt, test.ti;
143
source include/diff_tables.inc;
146
id mediumint null primary key,
149
insert into tt values (1,4);
150
create table ti like tt;
151
alter table ti engine=innodb;
152
insert into ti select * from tt;
153
replace_regex /MariaDB/XYZ/ /MySQL/XYZ/;
154
error ER_UNSUPPORTED_EXTENSION;
155
update noar tt set x=if(x=0,0,x-1) where id=1;
158
id mediumint not null primary key,
161
insert into tt values (1,4);
162
create table ti like tt;
163
alter table ti engine=innodb;
164
insert into ti select * from tt;
165
replace_regex /MariaDB/XYZ/ /MySQL/XYZ/;
166
error ER_UNSUPPORTED_EXTENSION;
167
update noar tt set x=if(x=0,0,x-1) where id=1;
170
id mediumint unsigned null primary key,
171
x mediumint unsigned null
173
insert into tt values (1,4);
174
create table ti like tt;
175
alter table ti engine=innodb;
176
insert into ti select * from tt;
177
update noar tt set x=if(x=0,0,x-1) where id=1;
178
update noar ti set x=if(x=0,0,x-1) where id=1;
179
update noar tt set x=if(x=0,0,x-1) where id=1;
180
update noar ti set x=if(x=0,0,x-1) where id=1;
181
update noar tt set x=if(x=0,0,x-1) where id=1;
182
update noar ti set x=if(x=0,0,x-1) where id=1;
183
update noar tt set x=if(x=0,0,x-1) where id=1;
184
update noar ti set x=if(x=0,0,x-1) where id=1;
185
# try to decrement when x=0
186
update noar tt set x=if(x=0,0,x-1) where id=1;
187
update noar ti set x=if(x=0,0,x-1) where id=1;
188
let $diff_tables = test.tt, test.ti;
189
source include/diff_tables.inc;
192
id mediumint unsigned not null primary key,
193
x mediumint unsigned not null
195
insert into tt values (1,4);
196
create table ti like tt;
197
alter table ti engine=innodb;
198
insert into ti select * from tt;
199
update noar tt set x=if(x=0,0,x-1) where id=1;
200
update noar ti set x=if(x=0,0,x-1) where id=1;
201
update noar tt set x=if(x=0,0,x-1) where id=1;
202
update noar ti set x=if(x=0,0,x-1) where id=1;
203
update noar tt set x=if(x=0,0,x-1) where id=1;
204
update noar ti set x=if(x=0,0,x-1) where id=1;
205
update noar tt set x=if(x=0,0,x-1) where id=1;
206
update noar ti set x=if(x=0,0,x-1) where id=1;
207
# try to decrement when x=0
208
update noar tt set x=if(x=0,0,x-1) where id=1;
209
update noar ti set x=if(x=0,0,x-1) where id=1;
210
let $diff_tables = test.tt, test.ti;
211
source include/diff_tables.inc;
214
id int null primary key,
217
insert into tt values (1,4);
218
create table ti like tt;
219
alter table ti engine=innodb;
220
insert into ti select * from tt;
221
replace_regex /MariaDB/XYZ/ /MySQL/XYZ/;
222
error ER_UNSUPPORTED_EXTENSION;
223
update noar tt set x=if(x=0,0,x-1) where id=1;
226
id int not null primary key,
229
insert into tt values (1,4);
230
create table ti like tt;
231
alter table ti engine=innodb;
232
insert into ti select * from tt;
233
replace_regex /MariaDB/XYZ/ /MySQL/XYZ/;
234
error ER_UNSUPPORTED_EXTENSION;
235
update noar tt set x=if(x=0,0,x-1) where id=1;
238
id int unsigned null primary key,
241
insert into tt values (1,4);
242
create table ti like tt;
243
alter table ti engine=innodb;
244
insert into ti select * from tt;
245
update noar tt set x=if(x=0,0,x-1) where id=1;
246
update noar ti set x=if(x=0,0,x-1) where id=1;
247
update noar tt set x=if(x=0,0,x-1) where id=1;
248
update noar ti set x=if(x=0,0,x-1) where id=1;
249
update noar tt set x=if(x=0,0,x-1) where id=1;
250
update noar ti set x=if(x=0,0,x-1) where id=1;
251
update noar tt set x=if(x=0,0,x-1) where id=1;
252
update noar ti set x=if(x=0,0,x-1) where id=1;
253
# try to decrement when x=0
254
update noar tt set x=if(x=0,0,x-1) where id=1;
255
update noar ti set x=if(x=0,0,x-1) where id=1;
256
let $diff_tables = test.tt, test.ti;
257
source include/diff_tables.inc;
260
id int unsigned not null primary key,
261
x int unsigned not null
263
insert into tt values (1,4);
264
create table ti like tt;
265
alter table ti engine=innodb;
266
insert into ti select * from tt;
267
update noar tt set x=if(x=0,0,x-1) where id=1;
268
update noar ti set x=if(x=0,0,x-1) where id=1;
269
update noar tt set x=if(x=0,0,x-1) where id=1;
270
update noar ti set x=if(x=0,0,x-1) where id=1;
271
update noar tt set x=if(x=0,0,x-1) where id=1;
272
update noar ti set x=if(x=0,0,x-1) where id=1;
273
update noar tt set x=if(x=0,0,x-1) where id=1;
274
update noar ti set x=if(x=0,0,x-1) where id=1;
275
# try to decrement when x=0
276
update noar tt set x=if(x=0,0,x-1) where id=1;
277
update noar ti set x=if(x=0,0,x-1) where id=1;
278
let $diff_tables = test.tt, test.ti;
279
source include/diff_tables.inc;
282
id bigint null primary key,
285
insert into tt values (1,4);
286
create table ti like tt;
287
alter table ti engine=innodb;
288
insert into ti select * from tt;
289
replace_regex /MariaDB/XYZ/ /MySQL/XYZ/;
290
error ER_UNSUPPORTED_EXTENSION;
291
update noar tt set x=if(x=0,0,x-1) where id=1;
294
id bigint not null primary key,
297
insert into tt values (1,4);
298
create table ti like tt;
299
alter table ti engine=innodb;
300
insert into ti select * from tt;
301
replace_regex /MariaDB/XYZ/ /MySQL/XYZ/;
302
error ER_UNSUPPORTED_EXTENSION;
303
update noar tt set x=if(x=0,0,x-1) where id=1;
306
id bigint unsigned null primary key,
307
x bigint unsigned null
309
insert into tt values (1,4);
310
create table ti like tt;
311
alter table ti engine=innodb;
312
insert into ti select * from tt;
313
update noar tt set x=if(x=0,0,x-1) where id=1;
314
update noar ti set x=if(x=0,0,x-1) where id=1;
315
update noar tt set x=if(x=0,0,x-1) where id=1;
316
update noar ti set x=if(x=0,0,x-1) where id=1;
317
update noar tt set x=if(x=0,0,x-1) where id=1;
318
update noar ti set x=if(x=0,0,x-1) where id=1;
319
update noar tt set x=if(x=0,0,x-1) where id=1;
320
update noar ti set x=if(x=0,0,x-1) where id=1;
321
# try to decrement when x=0
322
update noar tt set x=if(x=0,0,x-1) where id=1;
323
update noar ti set x=if(x=0,0,x-1) where id=1;
324
let $diff_tables = test.tt, test.ti;
325
source include/diff_tables.inc;
328
id bigint unsigned not null primary key,
329
x bigint unsigned not null
331
insert into tt values (1,4);
332
create table ti like tt;
333
alter table ti engine=innodb;
334
insert into ti select * from tt;
335
update noar tt set x=if(x=0,0,x-1) where id=1;
336
update noar ti set x=if(x=0,0,x-1) where id=1;
337
update noar tt set x=if(x=0,0,x-1) where id=1;
338
update noar ti set x=if(x=0,0,x-1) where id=1;
339
update noar tt set x=if(x=0,0,x-1) where id=1;
340
update noar ti set x=if(x=0,0,x-1) where id=1;
341
update noar tt set x=if(x=0,0,x-1) where id=1;
342
update noar ti set x=if(x=0,0,x-1) where id=1;
343
# try to decrement when x=0
344
update noar tt set x=if(x=0,0,x-1) where id=1;
345
update noar ti set x=if(x=0,0,x-1) where id=1;
346
let $diff_tables = test.tt, test.ti;
347
source include/diff_tables.inc;