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
|
# Set up the plugin APIs
INSTALL PLUGIN version_tokens SONAME 'version_token.so';
CREATE FUNCTION version_tokens_set RETURNS STRING SONAME 'version_token.so';
CREATE FUNCTION version_tokens_show RETURNS STRING SONAME 'version_token.so';
CREATE FUNCTION version_tokens_edit RETURNS STRING SONAME 'version_token.so';
CREATE FUNCTION version_tokens_delete RETURNS STRING SONAME 'version_token.so';
CREATE FUNCTION version_tokens_lock_shared RETURNS INT SONAME 'version_token.so';
CREATE FUNCTION version_tokens_lock_exclusive RETURNS INT SONAME 'version_token.so';
CREATE FUNCTION version_tokens_unlock RETURNS INT SONAME 'version_token.so';
# tests
#
# Bug #21645001 VERSION_TOKENS_DELETE() UDF DOESN'T TRIM WHITESPACE
#
SELECT version_tokens_set(' * = a ; y = b ');
version_tokens_set(' * = a ; y = b ')
2 version tokens set.
SELECT version_tokens_show();
version_tokens_show()
*=a;y=b;
SELECT version_tokens_delete(' * ');
version_tokens_delete(' * ')
1 version tokens deleted.
SELECT version_tokens_show();
version_tokens_show()
y=b;
SELECT version_tokens_delete(' ; y ');
version_tokens_delete(' ; y ')
1 version tokens deleted.
SELECT version_tokens_show();
version_tokens_show()
NULL
#
# Bug #21645944: VERSION_TOKENS : CRASH WITH EMPTY TOKEN NAME
#
# Must not crash
SELECT version_tokens_edit('=');
version_tokens_edit('=')
0 version tokens updated.
Warnings:
Warning 42000 Invalid version token pair encountered. The list provided is only partially updated.
#
# Bug #21646017: VERSION_TOKENS : CRASH WITH INVALID TIMEOUT PARAMETER
#
# Must not crash
SELECT version_tokens_lock_shared('a',''>''%'0');
ERROR 22003: timeout value is out of range in 'version_tokens_lock_shared'
#
# Bug #21646106: VERSION_TOKENS : CRASH WITH NULL INPUTS
#
# Must not crash
SELECT version_tokens_delete(null);
version_tokens_delete(null)
0 version tokens deleted.
# End of 5.7 tests
# Clean up the plugin APIs
UNINSTALL PLUGIN version_tokens;
Warnings:
Warning 1620 Plugin is busy and will be uninstalled on shutdown
DROP FUNCTION version_tokens_set;
DROP FUNCTION version_tokens_show;
DROP FUNCTION version_tokens_edit;
DROP FUNCTION version_tokens_delete;
DROP FUNCTION version_tokens_lock_shared;
DROP FUNCTION version_tokens_lock_exclusive;
DROP FUNCTION version_tokens_unlock;
|
