Debian Codegraph @

mysql-test/suite/query_rewrite_plugins/r/errors.result

raw
1 #
2 # Test of various abuses of the plugin.
3 #
4 SET sql_mode = 'PIPES_AS_CONCAT';
5 CALL mtr.add_suppression("Plugin rewriter reported: " ||
6 "'Some rules failed to load.'");
7 CALL mtr.add_suppression("Plugin rewriter reported: " ||
8 "'Wrong column count or names when loading rules.'");
9 # In theory a user might try to install the UDF without the plugin. In
10 # this case, we should exit gracefully with an informative error.
11 CREATE FUNCTION load_rewrite_rules RETURNS STRING SONAME 'rewriter.xxx';
12 SELECT load_rewrite_rules();
13 ERROR HY000: Can't initialize function 'load_rewrite_rules'; Rewriter plugin needs to be installed.
14 DROP FUNCTION load_rewrite_rules;
15 CREATE TABLE t1 ( c1 VARCHAR(10), c2 VARCHAR(10) );
16 INSERT INTO t1 VALUES( 'abc', 'def' ), ( 'ghi', 'klm' ), ( 'nop', 'qrs' );
17 CREATE TABLE t2( c1 VARCHAR(10) );
18 INSERT INTO t2 VALUES ( 'tuv' ), ( 'wxy' );
19 #
20 # Create a table with insufficient number of columns.
21 #
22 CREATE DATABASE query_rewrite;
23 CREATE TABLE query_rewrite.rewrite_rules ( pattern INT, replacement INT );
24 Warnings:
25 Note 1007 Can't create database 'query_rewrite'; database exists
26 Warnings:
27 Note 1050 Table 'rewrite_rules' already exists
28 # Query rewrite plugin was installed.
29 SELECT c1 FROM t1;
30 c1
31 abc
32 ghi
33 nop
34 SHOW STATUS LIKE 'Rewriter_reload_error';
35 Variable_name Value
36 Rewriter_reload_error ON
37 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
38 Variable_name Value
39 Rewriter_number_loaded_rules 0
40 CREATE TABLE IF NOT EXISTS error_log ( line TEXT );
41 DELETE FROM error_log;
42 LOAD DATA LOCAL INFILE 'ERROR_LOG'
43 INTO TABLE error_log FIELDS TERMINATED BY '\t';
44 UPDATE error_log SET line = replace ( line, '\r', '' );
45 # Avoid seeing any other error that might be there.
46 SELECT search_error_log( '[Error]', "%Plugin Rewriter reported: 'Wrong%" );
47 search_error_log( '[Error]', "%Plugin Rewriter reported: 'Wrong%" )
48 [ERROR] [MY-011276] [Server] Plugin Rewriter reported: 'Wrong column count or names when loading rules.'
49 SHOW STATUS LIKE 'Rewriter_number_reloads';
50 Variable_name Value
51 Rewriter_number_reloads 1
52 Warnings:
53 Warning 1620 Plugin is busy and will be uninstalled on shutdown
54 # Query rewrite plugin was queued for uninstalling.
55 # Create another table with insufficient number of columns.
56 CREATE DATABASE query_rewrite;
57 CREATE TABLE query_rewrite.rewrite_rules ( enabled CHAR(1) DEFAULT 'Y' );
58 Warnings:
59 Note 1007 Can't create database 'query_rewrite'; database exists
60 Warnings:
61 Note 1050 Table 'rewrite_rules' already exists
62 # Query rewrite plugin was installed.
63 CREATE TABLE IF NOT EXISTS error_log ( line TEXT );
64 DELETE FROM error_log;
65 LOAD DATA LOCAL INFILE 'ERROR_LOG'
66 INTO TABLE error_log FIELDS TERMINATED BY '\t';
67 UPDATE error_log SET line = replace ( line, '\r', '' );
68 # Avoid seeing any other error that might be there.
69 SELECT search_error_log( '[Error]', "%Plugin Rewriter reported: 'Wrong%" );
70 search_error_log( '[Error]', "%Plugin Rewriter reported: 'Wrong%" )
71 [ERROR] [MY-011276] [Server] Plugin Rewriter reported: 'Wrong column count or names when loading rules.'
72 SHOW STATUS LIKE 'Rewriter_number_reloads';
73 Variable_name Value
74 Rewriter_number_reloads 1
75 SELECT c1 FROM t1;
76 c1
77 abc
78 ghi
79 nop
80 SHOW STATUS LIKE 'Rewriter_reload_error';
81 Variable_name Value
82 Rewriter_reload_error ON
83 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
84 Variable_name Value
85 Rewriter_number_loaded_rules 0
86 Warnings:
87 Warning 1620 Plugin is busy and will be uninstalled on shutdown
88 # Query rewrite plugin was queued for uninstalling.
89 # Query rewrite plugin was installed.
90 #
91 # We now try 6 rules with various errors in them:
92 #
93 SHOW STATUS LIKE 'Rewriter_reload_error';
94 Variable_name Value
95 Rewriter_reload_error OFF
96 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
97 Variable_name Value
98 Rewriter_number_loaded_rules 0
99 # 1. Syntax error in the replacement.
100 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
101 VALUES ( 'SELECT c1 FROM test.t1 WHERE c1 = ?', 'SELECT c1 FROM test.t2 WHERE q c1 = ?' );
102 CALL query_rewrite.flush_rewrite_rules();
103 ERROR 45000: Loading of some rule(s) failed.
104 SHOW STATUS LIKE 'Rewriter_reload_error';
105 Variable_name Value
106 Rewriter_reload_error ON
107 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
108 Variable_name Value
109 Rewriter_number_loaded_rules 0
110 SELECT c1 FROM test.t1 WHERE c1 = 'abc';
111 c1
112 abc
113 SELECT * FROM query_rewrite.rewrite_rules;
114 id pattern pattern_database replacement enabled message
115 1 SELECT c1 FROM test.t1 WHERE c1 = ? NULL SELECT c1 FROM test.t2 WHERE q c1 = ? YES Parse error in replacement: >>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c1 = ?' at line 1<<
116 # 2. No error.
117 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
118 VALUES ( 'SELECT c1 FROM test.t1', 'SELECT * FROM test.t1' );
119 CALL query_rewrite.flush_rewrite_rules();
120 ERROR 45000: Loading of some rule(s) failed.
121 SHOW STATUS LIKE 'Rewriter_reload_error';
122 Variable_name Value
123 Rewriter_reload_error ON
124 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
125 Variable_name Value
126 Rewriter_number_loaded_rules 1
127 SELECT * FROM query_rewrite.rewrite_rules;
128 id pattern pattern_database replacement enabled message
129 1 SELECT c1 FROM test.t1 WHERE c1 = ? NULL SELECT c1 FROM test.t2 WHERE q c1 = ? YES Parse error in replacement: >>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c1 = ?' at line 1<<
130 2 SELECT c1 FROM test.t1 NULL SELECT * FROM test.t1 YES NULL
131 # 3. Syntax error in the pattern.
132 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
133 VALUES ( 'SELECT c1 FROM test.t1 WHERE dqdq c1 = ? OR c2 = ?',
134 'SELECT * FROM test.t1 WHERE c2 = ? OR c1 = ?' );
135 CALL query_rewrite.flush_rewrite_rules();
136 ERROR 45000: Loading of some rule(s) failed.
137 SHOW STATUS LIKE 'Rewriter_reload_error';
138 Variable_name Value
139 Rewriter_reload_error ON
140 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
141 Variable_name Value
142 Rewriter_number_loaded_rules 1
143 SELECT * FROM query_rewrite.rewrite_rules;
144 id pattern pattern_database replacement enabled message
145 1 SELECT c1 FROM test.t1 WHERE c1 = ? NULL SELECT c1 FROM test.t2 WHERE q c1 = ? YES Parse error in replacement: >>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c1 = ?' at line 1<<
146 2 SELECT c1 FROM test.t1 NULL SELECT * FROM test.t1 YES NULL
147 3 SELECT c1 FROM test.t1 WHERE dqdq c1 = ? OR c2 = ? NULL SELECT * FROM test.t1 WHERE c2 = ? OR c1 = ? YES Parse error in pattern: >>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c1 = ? OR c2 = ?' at line 1<<
148 # 4 Empty/NULL replacement/pattern
149 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
150 VALUES ( 'SELECT c1 FROM test.t1 WHERE c2 = ?', '' );
151 CALL query_rewrite.flush_rewrite_rules();
152 ERROR 45000: Loading of some rule(s) failed.
153 SHOW STATUS LIKE 'Rewriter_reload_error';
154 Variable_name Value
155 Rewriter_reload_error ON
156 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
157 Variable_name Value
158 Rewriter_number_loaded_rules 1
159 SELECT * FROM query_rewrite.rewrite_rules;
160 id pattern pattern_database replacement enabled message
161 1 SELECT c1 FROM test.t1 WHERE c1 = ? NULL SELECT c1 FROM test.t2 WHERE q c1 = ? YES Parse error in replacement: >>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c1 = ?' at line 1<<
162 2 SELECT c1 FROM test.t1 NULL SELECT * FROM test.t1 YES NULL
163 3 SELECT c1 FROM test.t1 WHERE dqdq c1 = ? OR c2 = ? NULL SELECT * FROM test.t1 WHERE c2 = ? OR c1 = ? YES Parse error in pattern: >>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c1 = ? OR c2 = ?' at line 1<<
164 4 SELECT c1 FROM test.t1 WHERE c2 = ? NULL YES Parse error in replacement: >>Query was empty<<
165 DELETE FROM query_rewrite.rewrite_rules
166 WHERE pattern = 'SELECT c1 FROM test.t1 WHERE c2 = ?';
167 ALTER TABLE query_rewrite.rewrite_rules
168 MODIFY COLUMN replacement VARCHAR(10000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
169 INSERT INTO query_rewrite.rewrite_rules ( pattern )
170 VALUES ( 'SELECT c1 FROM test.t1 WHERE c2 = ?' );
171 CALL query_rewrite.flush_rewrite_rules();
172 ERROR 45000: Loading of some rule(s) failed.
173 SHOW STATUS LIKE 'Rewriter_reload_error';
174 Variable_name Value
175 Rewriter_reload_error ON
176 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
177 Variable_name Value
178 Rewriter_number_loaded_rules 1
179 SELECT * FROM query_rewrite.rewrite_rules;
180 id pattern pattern_database replacement enabled message
181 1 SELECT c1 FROM test.t1 WHERE c1 = ? NULL SELECT c1 FROM test.t2 WHERE q c1 = ? YES Parse error in replacement: >>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c1 = ?' at line 1<<
182 2 SELECT c1 FROM test.t1 NULL SELECT * FROM test.t1 YES NULL
183 3 SELECT c1 FROM test.t1 WHERE dqdq c1 = ? OR c2 = ? NULL SELECT * FROM test.t1 WHERE c2 = ? OR c1 = ? YES Parse error in pattern: >>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c1 = ? OR c2 = ?' at line 1<<
184 5 SELECT c1 FROM test.t1 WHERE c2 = ? NULL NULL YES Replacement is NULL.
185 DELETE FROM query_rewrite.rewrite_rules
186 WHERE pattern = 'SELECT c1 FROM test.t1 WHERE c2 = ?';
187 ALTER TABLE query_rewrite.rewrite_rules
188 MODIFY COLUMN pattern VARCHAR(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
189 INSERT INTO query_rewrite.rewrite_rules ( replacement )
190 VALUES ( 'SELECT c1 FROM test.t1 WHERE c2 = ?' );
191 CALL query_rewrite.flush_rewrite_rules();
192 ERROR 45000: Loading of some rule(s) failed.
193 SHOW STATUS LIKE 'Rewriter_reload_error';
194 Variable_name Value
195 Rewriter_reload_error ON
196 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
197 Variable_name Value
198 Rewriter_number_loaded_rules 1
199 SELECT * FROM query_rewrite.rewrite_rules;
200 id pattern pattern_database replacement enabled message
201 1 SELECT c1 FROM test.t1 WHERE c1 = ? NULL SELECT c1 FROM test.t2 WHERE q c1 = ? YES Parse error in replacement: >>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c1 = ?' at line 1<<
202 2 SELECT c1 FROM test.t1 NULL SELECT * FROM test.t1 YES NULL
203 3 SELECT c1 FROM test.t1 WHERE dqdq c1 = ? OR c2 = ? NULL SELECT * FROM test.t1 WHERE c2 = ? OR c1 = ? YES Parse error in pattern: >>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c1 = ? OR c2 = ?' at line 1<<
204 6 NULL NULL SELECT c1 FROM test.t1 WHERE c2 = ? YES Pattern is NULL.
205 # 5 More parameters in the replacement than the pattern
206 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
207 VALUES
208 ( 'SELECT * FROM test.t1 WHERE c1 = ?', 'SELECT * FROM test.t2 WHERE c2 = ? AND c1 = ?' );
209 CALL query_rewrite.flush_rewrite_rules();
210 ERROR 45000: Loading of some rule(s) failed.
211 SHOW STATUS LIKE 'Rewriter_reload_error';
212 Variable_name Value
213 Rewriter_reload_error ON
214 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
215 Variable_name Value
216 Rewriter_number_loaded_rules 1
217 SELECT * FROM test.t1 WHERE c1 = 'abc';
218 c1 c2
219 abc def
220 SELECT * FROM query_rewrite.rewrite_rules;
221 id pattern pattern_database replacement enabled message
222 1 SELECT c1 FROM test.t1 WHERE c1 = ? NULL SELECT c1 FROM test.t2 WHERE q c1 = ? YES Parse error in replacement: >>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c1 = ?' at line 1<<
223 2 SELECT c1 FROM test.t1 NULL SELECT * FROM test.t1 YES NULL
224 3 SELECT c1 FROM test.t1 WHERE dqdq c1 = ? OR c2 = ? NULL SELECT * FROM test.t1 WHERE c2 = ? OR c1 = ? YES Parse error in pattern: >>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c1 = ? OR c2 = ?' at line 1<<
225 6 NULL NULL SELECT c1 FROM test.t1 WHERE c2 = ? YES Pattern is NULL.
226 7 SELECT * FROM test.t1 WHERE c1 = ? NULL SELECT * FROM test.t2 WHERE c2 = ? AND c1 = ? YES Replacement has more parameter markers than pattern.
227 # 6 A replacement that does not have syntax errors in itself, but the
228 # rewritten query does.
229 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
230 VALUES ( 'SELECT "Fail, please", ?', 'SELECT 1 LIMIT ?' );
231 CALL query_rewrite.flush_rewrite_rules();
232 ERROR 45000: Loading of some rule(s) failed.
233 SELECT * FROM query_rewrite.rewrite_rules;
234 id pattern pattern_database replacement enabled message
235 1 SELECT c1 FROM test.t1 WHERE c1 = ? NULL SELECT c1 FROM test.t2 WHERE q c1 = ? YES Parse error in replacement: >>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c1 = ?' at line 1<<
236 2 SELECT c1 FROM test.t1 NULL SELECT * FROM test.t1 YES NULL
237 3 SELECT c1 FROM test.t1 WHERE dqdq c1 = ? OR c2 = ? NULL SELECT * FROM test.t1 WHERE c2 = ? OR c1 = ? YES Parse error in pattern: >>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c1 = ? OR c2 = ?' at line 1<<
238 6 NULL NULL SELECT c1 FROM test.t1 WHERE c2 = ? YES Pattern is NULL.
239 7 SELECT * FROM test.t1 WHERE c1 = ? NULL SELECT * FROM test.t2 WHERE c2 = ? AND c1 = ? YES Replacement has more parameter markers than pattern.
240 8 SELECT "Fail, please", ? NULL SELECT 1 LIMIT ? YES NULL
241 SHOW STATUS LIKE 'Rewriter_reload_error';
242 Variable_name Value
243 Rewriter_reload_error ON
244 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
245 Variable_name Value
246 Rewriter_number_loaded_rules 2
247 SET @@global.rewriter_verbose = 2;
248 SELECT 'Fail, please', 'a';
249 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''a'' at line 1
250 # Check that the one rule without errors is still rewritten and executed.
251 SELECT c1 FROM test.t1;
252 c1 c2
253 abc def
254 ghi klm
255 nop qrs
256 Warnings:
257 Note 1105 Query 'SELECT c1 FROM test.t1' rewritten to 'SELECT * FROM test.t1' by a query rewrite plugin
258 # Fix rule 1 (error in the replacement.)
259 UPDATE query_rewrite.rewrite_rules
260 SET replacement = 'SELECT c1 FROM test.t2 WHERE c1 = ?', enabled = 'YES'
261 WHERE pattern = 'SELECT c1 FROM test.t1 WHERE c1 = ?';
262 CALL query_rewrite.flush_rewrite_rules();
263 ERROR 45000: Loading of some rule(s) failed.
264 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
265 Variable_name Value
266 Rewriter_number_loaded_rules 3
267 SELECT c1 FROM test.t1 WHERE c1 = 'abc';
268 c1
269 Warnings:
270 Note 1105 Query 'SELECT c1 FROM test.t1 WHERE c1 = 'abc'' rewritten to 'SELECT c1 FROM test.t2 WHERE c1 = 'abc'' by a query rewrite plugin
271 SELECT c1 FROM test.t2 WHERE c1 = 'tuv';
272 c1
273 tuv
274 SELECT * FROM query_rewrite.rewrite_rules;
275 id pattern pattern_database replacement enabled message
276 1 SELECT c1 FROM test.t1 WHERE c1 = ? NULL SELECT c1 FROM test.t2 WHERE c1 = ? YES NULL
277 2 SELECT c1 FROM test.t1 NULL SELECT * FROM test.t1 YES NULL
278 3 SELECT c1 FROM test.t1 WHERE dqdq c1 = ? OR c2 = ? NULL SELECT * FROM test.t1 WHERE c2 = ? OR c1 = ? YES Parse error in pattern: >>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c1 = ? OR c2 = ?' at line 1<<
279 6 NULL NULL SELECT c1 FROM test.t1 WHERE c2 = ? YES Pattern is NULL.
280 7 SELECT * FROM test.t1 WHERE c1 = ? NULL SELECT * FROM test.t2 WHERE c2 = ? AND c1 = ? YES Replacement has more parameter markers than pattern.
281 8 SELECT "Fail, please", ? NULL SELECT 1 LIMIT ? YES NULL
282 # Check that the rule without error is still executed and rewritten.
283 SELECT c1 FROM test.t1;
284 c1 c2
285 abc def
286 ghi klm
287 nop qrs
288 Warnings:
289 Note 1105 Query 'SELECT c1 FROM test.t1' rewritten to 'SELECT * FROM test.t1' by a query rewrite plugin
290 # Remove all the rules that cause errors.
291 DELETE FROM query_rewrite.rewrite_rules WHERE pattern <> 'SELECT c1 FROM test.t1';
292 DELETE FROM query_rewrite.rewrite_rules WHERE pattern IS NULL;
293 DELETE FROM query_rewrite.rewrite_rules WHERE replacement IS NULL;
294 SHOW STATUS LIKE 'Rewriter_reload_error';
295 Variable_name Value
296 Rewriter_reload_error ON
297 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
298 Variable_name Value
299 Rewriter_number_loaded_rules 3
300 SHOW STATUS LIKE 'Rewriter_number_reloads';
301 Variable_name Value
302 Rewriter_number_reloads 10
303 # Check that a rule that used to have syntax error now works fine.
304 SELECT c1 FROM t1 WHERE c1 = 'abc';
305 c1
306 abc
307 # Check that the rule without error is still executed and rewritten.
308 SELECT c1 FROM test.t1;
309 c1 c2
310 abc def
311 ghi klm
312 nop qrs
313 Warnings:
314 Note 1105 Query 'SELECT c1 FROM test.t1' rewritten to 'SELECT * FROM test.t1' by a query rewrite plugin
315 # A rule with parse error followed by a correct rule should still turn
316 # Rewriter_reload_error to true.
317 DELETE FROM query_rewrite.rewrite_rules;
318 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
319 VALUES ( 'error', 'error' ),
320 ( 'select 1', 'select 2' );
321 CALL query_rewrite.flush_rewrite_rules();
322 ERROR 45000: Loading of some rule(s) failed.
323 SELECT * FROM query_rewrite.rewrite_rules;
324 id pattern pattern_database replacement enabled message
325 9 error NULL error YES Parse error in pattern: >>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'error' at line 1<<
326 10 select 1 NULL select 2 YES NULL
327 SHOW STATUS LIKE 'Rewriter_reload_error';
328 Variable_name Value
329 Rewriter_reload_error ON
330 #
331 # Test of what happens if pfs digests are turned off.
332 #
333 UPDATE performance_schema.setup_consumers
334 SET enabled = 'NO'
335 WHERE NAME = 'statements_digest';
336 # Rewrites should still work.
337 SELECT 1;
338 2
339 2
340 Warnings:
341 Note 1105 Query 'SELECT 1' rewritten to 'select 2' by a query rewrite plugin
342 PREPARE stmt1 FROM 'SELECT 1';
343 Warnings:
344 Note 1105 Query 'SELECT 1' rewritten to 'select 2' by a query rewrite plugin
345 EXECUTE stmt1;
346 2
347 2
348 # Restore the setting.
349 UPDATE performance_schema.setup_consumers
350 SET enabled = 'YES'
351 WHERE NAME = 'statements_digest';
352 # Let's try to uninstall the plugin the wrong way, that is, not using the
353 # script. The library will not be unloaded so we can still call the UDF
354 # but it should return an error.
355 UNINSTALL PLUGIN rewriter;
356 Warnings:
357 Warning 1620 Plugin is busy and will be uninstalled on shutdown
358 CALL query_rewrite.flush_rewrite_rules();
359 ERROR HY000: Can't initialize function 'load_rewrite_rules'; Rewriter plugin needs to be installed.
360 SELECT load_rewrite_rules();
361 ERROR HY000: Can't initialize function 'load_rewrite_rules'; Rewriter plugin needs to be installed.
362 # Query rewrite plugin was queued for uninstalling.
363 DROP TABLE error_log;
364 DROP FUNCTION search_error_log;
365 DROP TABLE t1, t2;