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
|
#
# Test for the example pre parse query rewrite plugin. The example
# plugin rewrites queries to lowercase.
#
INSTALL PLUGIN rewrite_example SONAME 'rewrite_example.xxx';
SELECT PLUGIN_NAME, PLUGIN_TYPE
FROM information_schema.plugins
WHERE plugin_name LIKE 'rewrite%';
plugin_name plugin_type
rewrite_example AUDIT
Warnings:
Note 1105 Query 'SELECT PLUGIN_NAME, PLUGIN_TYPE
FROM information_schema.plugins
WHERE plugin_name LIKE 'rewrite%'' rewritten to 'select plugin_name, plugin_type
from information_schema.plugins
where plugin_name like 'rewrite%'' by a query rewrite plugin
Note 1105 Query 'SHOW WARNINGS' rewritten to 'show warnings' by a query rewrite plugin
# We roll our own show warnings here. We try GET DIAGNOSTICS at the same
# time, so automatic SHOW WARNINGS would just be confusing.
SELECT 'LOWERCASE';
lowercase
lowercase
SHOW WARNINGS;
Level Code Message
Note 1105 Query 'SELECT 'LOWERCASE'' rewritten to 'select 'lowercase'' by a query rewrite plugin
Note 1105 Query 'SHOW WARNINGS' rewritten to 'show warnings' by a query rewrite plugin
SELECT 'LOWERCASE AGAIN';
lowercase again
lowercase again
GET DIAGNOSTICS CONDITION 1 @c1p1 = MESSAGE_TEXT;
GET DIAGNOSTICS CONDITION 2 @c2p1 = MESSAGE_TEXT;
SELECT @c1p1;
@c1p1
Query 'SELECT 'LOWERCASE AGAIN'' rewritten to 'select 'lowercase again'' by a query rewrite plugin
SELECT @c2p1;
@c2p1
Query 'GET DIAGNOSTICS CONDITION 1 @c1p1 = MESSAGE_TEXT' rewritten to 'get diagnostics condition 1 @c1p1 = message_text' by a query rewrite plugin
UNINSTALL PLUGIN rewrite_example;
Warnings:
Note 1105 Query 'UNINSTALL PLUGIN rewrite_example' rewritten to 'uninstall plugin rewrite_example' by a query rewrite plugin
Warning 1620 Plugin is busy and will be uninstalled on shutdown
Note 1105 Query 'SHOW WARNINGS' rewritten to 'show warnings' by a query rewrite plugin
SELECT 'UPPERCASE';
UPPERCASE
UPPERCASE
|
