1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
|
CREATE TABLE t1(a int) ENGINE=EXAMPLE;
ERROR 42000: Unknown storage engine 'EXAMPLE'
INSTALL PLUGIN example SONAME 'ha_example.so';
INSTALL PLUGIN EXAMPLE SONAME 'ha_example.so';
ERROR HY000: Function 'EXAMPLE' already exists
UNINSTALL PLUGIN example;
INSTALL PLUGIN example SONAME 'ha_example.so';
# Example engine does not support indexes
CREATE TABLE t1 (a int PRIMARY KEY) ENGINE=EXAMPLE;
ERROR 42000: Too many keys specified; max 0 keys allowed
CREATE TABLE t1 (a int, KEY (a)) ENGINE=EXAMPLE;
ERROR 42000: Too many keys specified; max 0 keys allowed
CREATE TABLE t1(a int) ENGINE=EXAMPLE;
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
`a` int DEFAULT NULL
) ENGINE=EXAMPLE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
# Let's do some advanced ops with the example engine :)
INSERT INTO t1 VALUES (0);
# Only supports table scans (and does always return zero rows :)
SELECT * FROM t1;
a
SELECT * FROM t1 WHERE a = 0;
a
# Since there are no rows found, it will never do update_row.
UPDATE t1 SET a = 1 WHERE a = 0;
# Since there are no rows found, it will never do delete_row.
DELETE FROM t1 WHERE a = 0;
# No support for SQL HANDLER statement
HANDLER t1 OPEN;
ERROR HY000: Table storage engine for 't1' doesn't have this option
# Try to delete table when plugin is not loaded.
# Remove table from TDC to allow plugin unload.
FLUSH TABLE t1;
UNINSTALL PLUGIN example;
DROP TABLE t1;
ERROR 42000: Unknown storage engine 'EXAMPLE'
INSTALL PLUGIN example SONAME 'ha_example.so';
DROP TABLE t1;
set global example_ulong_var=500;
set global example_enum_var= e1;
select * from performance_schema.global_status where variable_name like 'example%' order by variable_name;
VARIABLE_NAME VARIABLE_VALUE
example_func_example enum_var is 0, ulong_var is 500, double_var is 8.500000, signed_int_var is -10, signed_long_var is -10, signed_longlong_var is -10
example_status_array_var1 100
example_status_array_var2 20.010000
example_status_var3 three hundred
example_status_var4 ON
example_status_var5 OFF
example_status_var6 8250
show variables like 'example%';
Variable_name Value
example_create_count_thdvar 1
example_double_thdvar 8.500000
example_double_var 8.500000
example_enum_var e1
example_last_create_thdvar Last creation 't1'
example_signed_int_thdvar -10
example_signed_int_var -10
example_signed_long_thdvar -10
example_signed_long_var -10
example_signed_longlong_thdvar -10
example_signed_longlong_var -10
example_ulong_var 500
UNINSTALL PLUGIN example;
UNINSTALL PLUGIN EXAMPLE;
ERROR 42000: PLUGIN EXAMPLE does not exist
UNINSTALL PLUGIN non_exist;
ERROR 42000: PLUGIN non_exist does not exist
#
# Bug#32034: check_func_enum() does not check correct values but set it
# to impossible int val
#
INSTALL PLUGIN example SONAME 'ha_example.so';
SET GLOBAL example_enum_var= e1;
SET GLOBAL example_enum_var= e2;
SET GLOBAL example_enum_var= impossible;
ERROR 42000: Variable 'example_enum_var' can't be set to the value of 'impossible'
UNINSTALL PLUGIN example;
INSTALL PLUGIN example SONAME 'ha_example.so';
select @@session.sql_mode into @old_sql_mode;
set session sql_mode='';
set global example_ulong_var=500;
select @@global.example_ulong_var;
@@global.example_ulong_var
500
set global example_ulong_var=1111;
Warnings:
Warning 1292 Truncated incorrect example_ulong_var value: '1111'
select @@global.example_ulong_var;
@@global.example_ulong_var
1000
set session sql_mode='STRICT_ALL_TABLES';
Warnings:
Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
set global example_ulong_var=500;
select @@global.example_ulong_var;
@@global.example_ulong_var
500
set global example_ulong_var=1111;
ERROR 42000: Variable 'example_ulong_var' can't be set to the value of '1111'
select @@global.example_ulong_var;
@@global.example_ulong_var
500
set session sql_mode=@old_sql_mode;
set session old=bla;
ERROR HY000: Variable 'old' is a read only variable
UNINSTALL PLUGIN example;
#
# Bug #16194302 SUPPORT FOR FLOATING-POINT SYSTEM
# VARIABLES USING THE PLUGIN INTERFACE.
#
INSTALL PLUGIN example SONAME 'ha_example.so';
SET GLOBAL example_double_var = -0.1;
Warnings:
Warning 1292 Truncated incorrect example_double_var value: '-0.1'
SELECT @@GLOBAL.example_double_var;
@@GLOBAL.example_double_var
0.500000
SET GLOBAL example_double_var = 0.000001;
Warnings:
Warning 1292 Truncated incorrect example_double_var value: '0.000001'
SELECT @@GLOBAL.example_double_var;
@@GLOBAL.example_double_var
0.500000
SET GLOBAL example_double_var = 0.4;
Warnings:
Warning 1292 Truncated incorrect example_double_var value: '0.4'
SELECT @@GLOBAL.example_double_var;
@@GLOBAL.example_double_var
0.500000
SET GLOBAL example_double_var = 123.456789;
SELECT @@GLOBAL.example_double_var;
@@GLOBAL.example_double_var
123.456789
SET GLOBAL example_double_var = 500;
SELECT @@GLOBAL.example_double_var;
@@GLOBAL.example_double_var
500.000000
SET GLOBAL example_double_var = 999.999999;
SELECT @@GLOBAL.example_double_var;
@@GLOBAL.example_double_var
999.999999
SET GLOBAL example_double_var = 1000.51;
Warnings:
Warning 1292 Truncated incorrect example_double_var value: '1000.51'
SELECT @@GLOBAL.example_double_var;
@@GLOBAL.example_double_var
1000.500000
SET SESSION example_double_thdvar = -0.1;
Warnings:
Warning 1292 Truncated incorrect example_double_thdvar value: '-0.1'
SELECT @@SESSION.example_double_thdvar;
@@SESSION.example_double_thdvar
0.500000
SET SESSION example_double_thdvar = 0.000001;
Warnings:
Warning 1292 Truncated incorrect example_double_thdvar value: '0.000001'
SELECT @@SESSION.example_double_thdvar;
@@SESSION.example_double_thdvar
0.500000
SET SESSION example_double_thdvar = 0.4;
Warnings:
Warning 1292 Truncated incorrect example_double_thdvar value: '0.4'
SELECT @@SESSION.example_double_thdvar;
@@SESSION.example_double_thdvar
0.500000
SET SESSION example_double_thdvar = 123.456789;
SELECT @@SESSION.example_double_thdvar;
@@SESSION.example_double_thdvar
123.456789
SET SESSION example_double_thdvar = 500;
SELECT @@SESSION.example_double_thdvar;
@@SESSION.example_double_thdvar
500.000000
SET SESSION example_double_thdvar = 999.999999;
SELECT @@SESSION.example_double_thdvar;
@@SESSION.example_double_thdvar
999.999999
SET SESSION example_double_thdvar = 1000.51;
Warnings:
Warning 1292 Truncated incorrect example_double_thdvar value: '1000.51'
SELECT @@SESSION.example_double_thdvar;
@@SESSION.example_double_thdvar
1000.500000
UNINSTALL PLUGIN example;
#
# Bug #11759453: UNINSTALL PLUGIN MISLEADING ERROR
# MESSAGE FOR NON-DYNAMIC PLUGINS
#
UNINSTALL PLUGIN innodb;
ERROR HY000: Built-in plugins cannot be deleted
#
# Bug #19917521: MEMORY LEAK WITH STRING THREAD VARIABLE
# THAT SET MEMALLOC FLAG
#
INSTALL PLUGIN example SONAME 'ha_example.so';
SET SESSION example_create_count_thdvar = 0;
SET SESSION example_last_create_thdvar = '';
CREATE TABLE t10(a INT) ENGINE=EXAMPLE;
SELECT @@SESSION.example_create_count_thdvar;
@@SESSION.example_create_count_thdvar
1
SELECT @@SESSION.example_last_create_thdvar;
@@SESSION.example_last_create_thdvar
Last creation 't10'
CREATE TABLE t20(a INT) ENGINE=EXAMPLE;
SELECT @@SESSION.example_create_count_thdvar;
@@SESSION.example_create_count_thdvar
2
SELECT @@SESSION.example_last_create_thdvar;
@@SESSION.example_last_create_thdvar
Last creation 't20'
DROP TABLE t10, t20;
UNINSTALL PLUGIN example;
#
# BUG#24344026 - SIG 11 IN MY_VALID_MBCHARLEN_UTF8 AT STRINGS/CTYPE-UTF8.CC:9437
#
SET GLOBAL DEBUG='+d,set_uninstall_sync_point';
INSTALL PLUGIN example SONAME 'ha_example.so';
SET DEBUG_SYNC='before_store_plugin_name SIGNAL uninstall_plugin WAIT_FOR plugin_uninstalled';
SELECT * FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME='example';;
SET DEBUG_SYNC='now WAIT_FOR uninstall_plugin';
UNINSTALL PLUGIN example;
SET DEBUG_SYNC='now SIGNAL plugin_uninstalled';
PLUGIN_NAME PLUGIN_VERSION PLUGIN_STATUS PLUGIN_TYPE PLUGIN_TYPE_VERSION PLUGIN_LIBRARY PLUGIN_LIBRARY_VERSION PLUGIN_AUTHOR PLUGIN_DESCRIPTION PLUGIN_LICENSE LOAD_OPTION
SET DEBUG_SYNC='RESET';
SET GLOBAL DEBUG='-d,set_uninstall_sync_point';
#
# Bug#51770: UNINSTALL PLUGIN requires no privileges
#
CREATE USER bug51770@localhost;
GRANT INSERT ON mysql.plugin TO bug51770@localhost;
INSTALL PLUGIN example SONAME 'ha_example.so';
UNINSTALL PLUGIN example;
ERROR 42000: DELETE command denied to user 'bug51770'@'localhost' for table 'plugin'
GRANT DELETE ON mysql.plugin TO bug51770@localhost;
UNINSTALL PLUGIN example;
DROP USER bug51770@localhost;
INSTALL PLUGIN example SONAME '../ha_example.so';
ERROR HY000: No paths allowed for shared library
#
# Bug #28534414: NEGATIVE NUMBERS IN PLUGIN VARIABLES
# NOT DISPLAYED CORRECTLY
#
INSTALL PLUGIN example SONAME 'ha_example.so';
SELECT * FROM performance_schema.global_status WHERE variable_name LIKE 'example_func_example' ORDER BY variable_name;
VARIABLE_NAME VARIABLE_VALUE
example_func_example enum_var is 0, ulong_var is 8, double_var is 8.500000, signed_int_var is -10, signed_long_var is -10, signed_longlong_var is -10
SHOW VARIABLES LIKE 'example_signed_int_var';
Variable_name Value
example_signed_int_var -10
SELECT @@GLOBAL.example_signed_int_var;
@@GLOBAL.example_signed_int_var
-10
SET GLOBAL example_signed_int_var = -2147483648;
SELECT @@GLOBAL.example_signed_int_var;
@@GLOBAL.example_signed_int_var
-2147483648
SET GLOBAL example_signed_int_var = -100;
SELECT @@GLOBAL.example_signed_int_var;
@@GLOBAL.example_signed_int_var
-100
SET GLOBAL example_signed_int_var = 0;
SELECT @@GLOBAL.example_signed_int_var;
@@GLOBAL.example_signed_int_var
0
SET GLOBAL example_signed_int_var = 100;
SELECT @@GLOBAL.example_signed_int_var;
@@GLOBAL.example_signed_int_var
100
SET GLOBAL example_signed_int_var = 2147483647;
SELECT @@GLOBAL.example_signed_int_var;
@@GLOBAL.example_signed_int_var
2147483647
SET GLOBAL example_signed_int_var = -2147483649;
Warnings:
Warning 1292 Truncated incorrect example_signed_int_var value: '-2147483649'
SELECT @@GLOBAL.example_signed_int_var;
@@GLOBAL.example_signed_int_var
-2147483648
SET GLOBAL example_signed_int_var = 2147483648;
Warnings:
Warning 1292 Truncated incorrect example_signed_int_var value: '2147483648'
SELECT @@GLOBAL.example_signed_int_var;
@@GLOBAL.example_signed_int_var
2147483647
SHOW SESSION VARIABLES LIKE 'example_signed_int_thdvar';
Variable_name Value
example_signed_int_thdvar -10
SELECT @@SESSION.example_signed_int_thdvar;
@@SESSION.example_signed_int_thdvar
-10
SET SESSION example_signed_int_thdvar = -2147483648;
SELECT @@SESSION.example_signed_int_thdvar;
@@SESSION.example_signed_int_thdvar
-2147483648
SET SESSION example_signed_int_thdvar = -100;
SELECT @@SESSION.example_signed_int_thdvar;
@@SESSION.example_signed_int_thdvar
-100
SET SESSION example_signed_int_thdvar = 0;
SELECT @@SESSION.example_signed_int_thdvar;
@@SESSION.example_signed_int_thdvar
0
SET SESSION example_signed_int_thdvar = 100;
SELECT @@SESSION.example_signed_int_thdvar;
@@SESSION.example_signed_int_thdvar
100
SET SESSION example_signed_int_thdvar = 2147483647;
SELECT @@SESSION.example_signed_int_thdvar;
@@SESSION.example_signed_int_thdvar
2147483647
SET SESSION example_signed_int_thdvar = -2147483649;
Warnings:
Warning 1292 Truncated incorrect example_signed_int_thdvar value: '-2147483649'
SELECT @@SESSION.example_signed_int_thdvar;
@@SESSION.example_signed_int_thdvar
-2147483648
SET SESSION example_signed_int_thdvar = 2147483648;
Warnings:
Warning 1292 Truncated incorrect example_signed_int_thdvar value: '2147483648'
SELECT @@SESSION.example_signed_int_thdvar;
@@SESSION.example_signed_int_thdvar
2147483647
SHOW VARIABLES LIKE 'example_signed_long_var';
Variable_name Value
example_signed_long_var -10
SELECT @@GLOBAL.example_signed_long_var;
@@GLOBAL.example_signed_long_var
-10
SET GLOBAL example_signed_long_var = -9223372036854775808;
SELECT @@GLOBAL.example_signed_long_var IN (-2147483648, -9223372036854775808);
@@GLOBAL.example_signed_long_var IN (-2147483648, -9223372036854775808)
1
SET GLOBAL example_signed_long_var = -100;
SELECT @@GLOBAL.example_signed_long_var;
@@GLOBAL.example_signed_long_var
-100
SET GLOBAL example_signed_long_var = 0;
SELECT @@GLOBAL.example_signed_long_var;
@@GLOBAL.example_signed_long_var
0
SET GLOBAL example_signed_long_var = 100;
SELECT @@GLOBAL.example_signed_long_var;
@@GLOBAL.example_signed_long_var
100
SET GLOBAL example_signed_long_var = 9223372036854775807;
SELECT @@GLOBAL.example_signed_long_var IN (2147483647, 9223372036854775807);
@@GLOBAL.example_signed_long_var IN (2147483647, 9223372036854775807)
1
SET GLOBAL example_signed_long_var = -9223372036854775809;
ERROR 42000: Incorrect argument type to variable 'example_signed_long_var'
SELECT @@GLOBAL.example_signed_long_var IN (2147483647, 9223372036854775807);
@@GLOBAL.example_signed_long_var IN (2147483647, 9223372036854775807)
1
SET GLOBAL example_signed_long_var = 9223372036854775808;
SELECT @@GLOBAL.example_signed_long_var IN (2147483647, 9223372036854775807);
@@GLOBAL.example_signed_long_var IN (2147483647, 9223372036854775807)
1
SHOW SESSION VARIABLES LIKE 'example_signed_long_thdvar';
Variable_name Value
example_signed_long_thdvar -10
SELECT @@SESSION.example_signed_long_thdvar;
@@SESSION.example_signed_long_thdvar
-10
SET SESSION example_signed_long_thdvar = -9223372036854775808;
SELECT @@SESSION.example_signed_long_thdvar IN (-2147483648, -9223372036854775808);
@@SESSION.example_signed_long_thdvar IN (-2147483648, -9223372036854775808)
1
SET SESSION example_signed_long_thdvar = -100;
SELECT @@SESSION.example_signed_long_thdvar;
@@SESSION.example_signed_long_thdvar
-100
SET SESSION example_signed_long_thdvar = 0;
SELECT @@SESSION.example_signed_long_thdvar;
@@SESSION.example_signed_long_thdvar
0
SET SESSION example_signed_long_thdvar = 100;
SELECT @@SESSION.example_signed_long_thdvar;
@@SESSION.example_signed_long_thdvar
100
SET SESSION example_signed_long_thdvar = 9223372036854775807;
SELECT @@SESSION.example_signed_long_thdvar IN (2147483647, 9223372036854775807);
@@SESSION.example_signed_long_thdvar IN (2147483647, 9223372036854775807)
1
SET SESSION example_signed_long_thdvar = -9223372036854775809;
ERROR 42000: Incorrect argument type to variable 'example_signed_long_thdvar'
SELECT @@SESSION.example_signed_long_thdvar IN (2147483647, 9223372036854775807);
@@SESSION.example_signed_long_thdvar IN (2147483647, 9223372036854775807)
1
SET SESSION example_signed_long_thdvar = 9223372036854775808;
SELECT @@SESSION.example_signed_long_thdvar IN (2147483647, 9223372036854775807);
@@SESSION.example_signed_long_thdvar IN (2147483647, 9223372036854775807)
1
SHOW VARIABLES LIKE 'example_signed_longlong_var';
Variable_name Value
example_signed_longlong_var -10
SELECT @@GLOBAL.example_signed_longlong_var;
@@GLOBAL.example_signed_longlong_var
-10
SET GLOBAL example_signed_longlong_var = -9223372036854775808;
SELECT @@GLOBAL.example_signed_longlong_var;
@@GLOBAL.example_signed_longlong_var
-9223372036854775808
SET GLOBAL example_signed_longlong_var = -100;
SELECT @@GLOBAL.example_signed_longlong_var;
@@GLOBAL.example_signed_longlong_var
-100
SET GLOBAL example_signed_longlong_var = 0;
SELECT @@GLOBAL.example_signed_longlong_var;
@@GLOBAL.example_signed_longlong_var
0
SET GLOBAL example_signed_longlong_var = 100;
SELECT @@GLOBAL.example_signed_longlong_var;
@@GLOBAL.example_signed_longlong_var
100
SET GLOBAL example_signed_longlong_var = 9223372036854775807;
SELECT @@GLOBAL.example_signed_longlong_var;
@@GLOBAL.example_signed_longlong_var
9223372036854775807
SET GLOBAL example_signed_longlong_var = -9223372036854775809;
ERROR 42000: Incorrect argument type to variable 'example_signed_longlong_var'
SELECT @@GLOBAL.example_signed_longlong_var;
@@GLOBAL.example_signed_longlong_var
9223372036854775807
SET GLOBAL example_signed_longlong_var = 9223372036854775808;
Warnings:
Warning 1292 Truncated incorrect example_signed_longlong_var value: '9223372036854775808'
SELECT @@GLOBAL.example_signed_longlong_var;
@@GLOBAL.example_signed_longlong_var
9223372036854775807
SHOW SESSION VARIABLES LIKE 'example_signed_longlong_thdvar';
Variable_name Value
example_signed_longlong_thdvar -10
SELECT @@SESSION.example_signed_longlong_thdvar;
@@SESSION.example_signed_longlong_thdvar
-10
SET SESSION example_signed_longlong_thdvar = -9223372036854775808;
SELECT @@SESSION.example_signed_longlong_thdvar;
@@SESSION.example_signed_longlong_thdvar
-9223372036854775808
SET SESSION example_signed_longlong_thdvar = -100;
SELECT @@SESSION.example_signed_longlong_thdvar;
@@SESSION.example_signed_longlong_thdvar
-100
SET SESSION example_signed_longlong_thdvar = 0;
SELECT @@SESSION.example_signed_longlong_thdvar;
@@SESSION.example_signed_longlong_thdvar
0
SET SESSION example_signed_longlong_thdvar = 100;
SELECT @@SESSION.example_signed_longlong_thdvar;
@@SESSION.example_signed_longlong_thdvar
100
SET SESSION example_signed_longlong_thdvar = 9223372036854775807;
SELECT @@SESSION.example_signed_longlong_thdvar;
@@SESSION.example_signed_longlong_thdvar
9223372036854775807
SET SESSION example_signed_longlong_thdvar = -9223372036854775809;
ERROR 42000: Incorrect argument type to variable 'example_signed_longlong_thdvar'
SELECT @@SESSION.example_signed_longlong_thdvar;
@@SESSION.example_signed_longlong_thdvar
9223372036854775807
SET SESSION example_signed_longlong_thdvar = 9223372036854775808;
Warnings:
Warning 1292 Truncated incorrect example_signed_longlong_thdvar value: '9223372036854775808'
SELECT @@SESSION.example_signed_longlong_thdvar;
@@SESSION.example_signed_longlong_thdvar
9223372036854775807
UNINSTALL PLUGIN example;
|
