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
|
#
# Tests of touching the rules table from different transactions.
#
# Query rewrite plugin was installed.
SET autocommit = 0;
SELECT @@autocommit;
@@autocommit
0
START TRANSACTION;
INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
VALUES ( 'SELECT "Rewrite me conn 1"', 'SELECT "Rewritten conn 1 rule 1"' );
COMMIT;
START TRANSACTION;
INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
VALUES ( 'SELECT "Rewrite me conn 2"', 'SELECT "Rewritten conn 2 rule 1"' );
COMMIT;
CALL query_rewrite.flush_rewrite_rules();
SELECT "Rewrite me conn 1";
Rewritten conn 1 rule 1
Rewritten conn 1 rule 1
Warnings:
Note 1105 Query 'SELECT "Rewrite me conn 1"' rewritten to 'SELECT "Rewritten conn 1 rule 1"' by a query rewrite plugin
SELECT "Rewrite me conn 2";
Rewritten conn 2 rule 1
Rewritten conn 2 rule 1
Warnings:
Note 1105 Query 'SELECT "Rewrite me conn 2"' rewritten to 'SELECT "Rewritten conn 2 rule 1"' by a query rewrite plugin
CALL query_rewrite.flush_rewrite_rules();
SELECT "Rewrite me conn 1";
Rewritten conn 1 rule 1
Rewritten conn 1 rule 1
Warnings:
Note 1105 Query 'SELECT "Rewrite me conn 1"' rewritten to 'SELECT "Rewritten conn 1 rule 1"' by a query rewrite plugin
SELECT "Rewrite me conn 2";
Rewritten conn 2 rule 1
Rewritten conn 2 rule 1
Warnings:
Note 1105 Query 'SELECT "Rewrite me conn 2"' rewritten to 'SELECT "Rewritten conn 2 rule 1"' by a query rewrite plugin
SELECT "Rewrite me conn 1";
Rewritten conn 1 rule 1
Rewritten conn 1 rule 1
Warnings:
Note 1105 Query 'SELECT "Rewrite me conn 1"' rewritten to 'SELECT "Rewritten conn 1 rule 1"' by a query rewrite plugin
SELECT "Rewrite me conn 2";
Rewritten conn 2 rule 1
Rewritten conn 2 rule 1
Warnings:
Note 1105 Query 'SELECT "Rewrite me conn 2"' rewritten to 'SELECT "Rewritten conn 2 rule 1"' by a query rewrite plugin
# This would cause failed assertion unless the mdl locks are released.
SELECT xxx(pattern) FROM query_rewrite.rewrite_rules;
ERROR 42000: FUNCTION test.xxx does not exist
Warnings:
Warning 1620 Plugin is busy and will be uninstalled on shutdown
# Query rewrite plugin was queued for uninstalling.
#
# Now make sure that everything works as long we do as we're supposed
# to, even with autocommit = 0.
#
SET autocommit = 0;
SELECT @@autocommit;
@@autocommit
0
# Query rewrite plugin was installed.
START TRANSACTION;
INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
VALUES ( 'SELECT "Rewrite me"', 'SELECT "Rewritten w/rule 1"' );
CALL query_rewrite.flush_rewrite_rules();
SELECT 'Rewrite me';
Rewritten w/rule 1
Rewritten w/rule 1
Warnings:
Note 1105 Query 'SELECT 'Rewrite me'' rewritten to 'SELECT "Rewritten w/rule 1"' by a query rewrite plugin
SHOW STATUS LIKE 'Rewriter_%';
Variable_name Value
Rewriter_number_loaded_rules 1
Rewriter_number_reloads 2
Rewriter_number_rewritten_queries 1
Rewriter_reload_error OFF
Warnings:
Warning 1620 Plugin is busy and will be uninstalled on shutdown
# Query rewrite plugin was queued for uninstalling.
#
# Now check that we don't fail even if @@autocommit is 0. In this case
# InnoDB times out waiting for a lock, the plugin can't load the rules,
# and we expect a message in the error log.
#
SET autocommit = 0;
SELECT @@autocommit;
@@autocommit
0
# Query rewrite plugin was installed.
CALL mtr.add_suppression("Got error from storage engine while refreshing rewrite rules.");
# This would cause failed assertion unless the mdl locks are released.
SELECT xxx(pattern) FROM query_rewrite.rewrite_rules;
ERROR 42000: FUNCTION test.xxx does not exist
START TRANSACTION;
INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
VALUES ( 'SELECT "Rewrite me"', 'SELECT "Rewritten w/rule 1"' );
SET @@global.innodb_lock_wait_timeout = 1;
SELECT load_rewrite_rules();
load_rewrite_rules()
Loading of some rule(s) failed.
SET @@global.innodb_lock_wait_timeout = DEFAULT;
SELECT 'Rewrite me';
Rewrite me
Rewrite me
SHOW STATUS LIKE 'Rewriter_%';
Variable_name Value
Rewriter_number_loaded_rules 0
Rewriter_number_reloads 2
Rewriter_number_rewritten_queries 0
Rewriter_reload_error ON
COMMIT;
SELECT 'Rewrite me';
Rewrite me
Rewrite me
SHOW STATUS LIKE 'Rewriter_%';
Variable_name Value
Rewriter_number_loaded_rules 0
Rewriter_number_reloads 2
Rewriter_number_rewritten_queries 0
Rewriter_reload_error ON
SELECT load_rewrite_rules();
load_rewrite_rules()
NULL
SELECT 'Rewrite me';
Rewritten w/rule 1
Rewritten w/rule 1
Warnings:
Note 1105 Query 'SELECT 'Rewrite me'' rewritten to 'SELECT "Rewritten w/rule 1"' by a query rewrite plugin
SHOW STATUS LIKE 'Rewriter_%';
Variable_name Value
Rewriter_number_loaded_rules 1
Rewriter_number_reloads 3
Rewriter_number_rewritten_queries 1
Rewriter_reload_error OFF
Warnings:
Warning 1620 Plugin is busy and will be uninstalled on shutdown
# Query rewrite plugin was queued for uninstalling.
#
# Now let's make sure that everything works fine if we run with
# autocommit.
#
SET autocommit = 1;
SELECT @@autocommit;
@@autocommit
1
# Query rewrite plugin was installed.
# This would cause failed assertion unless the mdl locks are released.
SELECT xxx(pattern) FROM query_rewrite.rewrite_rules;
ERROR 42000: FUNCTION test.xxx does not exist
START TRANSACTION;
INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
VALUES ( 'SELECT "Rewrite me"', 'SELECT "Rewritten w/rule 1"' );
SET @@global.innodb_lock_wait_timeout = 1;
SELECT load_rewrite_rules();
load_rewrite_rules()
Loading of some rule(s) failed.
SET @@global.innodb_lock_wait_timeout = DEFAULT;
SELECT 'Rewrite me';
Rewrite me
Rewrite me
COMMIT;
SELECT 'Rewrite me';
Rewrite me
Rewrite me
SELECT load_rewrite_rules();
load_rewrite_rules()
NULL
SELECT 'Rewrite me';
Rewritten w/rule 1
Rewritten w/rule 1
Warnings:
Note 1105 Query 'SELECT 'Rewrite me'' rewritten to 'SELECT "Rewritten w/rule 1"' by a query rewrite plugin
SET autocommit = DEFAULT;
Warnings:
Warning 1620 Plugin is busy and will be uninstalled on shutdown
# Query rewrite plugin was queued for uninstalling.
#
# Bug#36784795 Query rewrite plugin not working when server runs with
# autocommit=OFF
#
# Query rewrite plugin was installed.
SET GLOBAL autocommit = 0;
SET SESSION autocommit = ON;
DELETE FROM query_rewrite.rewrite_rules;
INSERT INTO query_rewrite.rewrite_rules (pattern, replacement)
VALUES('SELECT ?', 'SELECT ? + 1');
SELECT * FROM query_rewrite.rewrite_rules;
id pattern pattern_database replacement enabled message pattern_digest normalized_pattern
1 SELECT ? NULL SELECT ? + 1 YES NULL NULL NULL
CALL query_rewrite.flush_rewrite_rules();
SELECT * FROM query_rewrite.rewrite_rules;
id pattern pattern_database replacement enabled message pattern_digest normalized_pattern
1 SELECT ? NULL SELECT ? + 1 YES NULL d1b44b0c19af710b5a679907e284acd2ddc285201794bc69a2389d77baedddae select ?
SET GLOBAL autocommit = DEFAULT;
SET SESSION autocommit = DEFAULT;
Warnings:
Warning 1620 Plugin is busy and will be uninstalled on shutdown
# Query rewrite plugin was queued for uninstalling.
|
