Debian Codegraph @

mysql-test/suite/query_rewrite_plugins/t/errors.test

raw
1 --echo #
2 --echo # Test of various abuses of the plugin.
3 --echo #
4
5 --source suite/query_rewrite_plugins/include/have_plugin_rewriter.inc
6
7 SET sql_mode = 'PIPES_AS_CONCAT';
8 CALL mtr.add_suppression("Plugin rewriter reported: " ||
9 "'Some rules failed to load.'");
10
11 CALL mtr.add_suppression("Plugin rewriter reported: " ||
12 "'Wrong column count or names when loading rules.'");
13
14
15 --echo # In theory a user might try to install the UDF without the plugin. In
16 --echo # this case, we should exit gracefully with an informative error.
17
18 --replace_regex /\.so|\.dll/.xxx/
19 eval CREATE FUNCTION load_rewrite_rules RETURNS STRING SONAME '$REWRITER';
20
21 --error ER_CANT_INITIALIZE_UDF
22 SELECT load_rewrite_rules();
23 DROP FUNCTION load_rewrite_rules;
24
25 CREATE TABLE t1 ( c1 VARCHAR(10), c2 VARCHAR(10) );
26 INSERT INTO t1 VALUES( 'abc', 'def' ), ( 'ghi', 'klm' ), ( 'nop', 'qrs' );
27
28 CREATE TABLE t2( c1 VARCHAR(10) );
29 INSERT INTO t2 VALUES ( 'tuv' ), ( 'wxy' );
30
31 --echo #
32 --echo # Create a table with insufficient number of columns.
33 --echo #
34 CREATE DATABASE query_rewrite;
35 CREATE TABLE query_rewrite.rewrite_rules ( pattern INT, replacement INT );
36
37 --source suite/query_rewrite_plugins/include/install_rewriter.inc
38
39 SELECT c1 FROM t1;
40
41 SHOW STATUS LIKE 'Rewriter_reload_error';
42 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
43
44 --source suite/query_rewrite_plugins/include/load_error_log.inc
45
46 --echo # Avoid seeing any other error that might be there.
47 SELECT search_error_log( '[Error]', "%Plugin Rewriter reported: 'Wrong%" );
48 SHOW STATUS LIKE 'Rewriter_number_reloads';
49
50 --source suite/query_rewrite_plugins/include/uninstall_rewriter.inc
51 --source include/disconnect_connections.inc
52
53 --echo # Create another table with insufficient number of columns.
54 CREATE DATABASE query_rewrite;
55 CREATE TABLE query_rewrite.rewrite_rules ( enabled CHAR(1) DEFAULT 'Y' );
56
57 --source suite/query_rewrite_plugins/include/install_rewriter.inc
58
59 --source suite/query_rewrite_plugins/include/load_error_log.inc
60 --echo # Avoid seeing any other error that might be there.
61 SELECT search_error_log( '[Error]', "%Plugin Rewriter reported: 'Wrong%" );
62 SHOW STATUS LIKE 'Rewriter_number_reloads';
63
64 SELECT c1 FROM t1;
65
66 SHOW STATUS LIKE 'Rewriter_reload_error';
67 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
68
69 --source suite/query_rewrite_plugins/include/uninstall_rewriter.inc
70 --source include/disconnect_connections.inc
71
72 --source suite/query_rewrite_plugins/include/install_rewriter.inc
73
74 --echo #
75 --echo # We now try 6 rules with various errors in them:
76 --echo #
77
78 SHOW STATUS LIKE 'Rewriter_reload_error';
79 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
80
81 --echo # 1. Syntax error in the replacement.
82 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
83 VALUES ( 'SELECT c1 FROM test.t1 WHERE c1 = ?', 'SELECT c1 FROM test.t2 WHERE q c1 = ?' );
84
85 --error ER_SIGNAL_EXCEPTION
86 CALL query_rewrite.flush_rewrite_rules();
87
88 SHOW STATUS LIKE 'Rewriter_reload_error';
89 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
90
91 SELECT c1 FROM test.t1 WHERE c1 = 'abc';
92
93 SELECT * FROM query_rewrite.rewrite_rules;
94
95 --echo # 2. No error.
96 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
97 VALUES ( 'SELECT c1 FROM test.t1', 'SELECT * FROM test.t1' );
98
99 --error ER_SIGNAL_EXCEPTION
100 CALL query_rewrite.flush_rewrite_rules();
101
102 SHOW STATUS LIKE 'Rewriter_reload_error';
103 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
104
105 SELECT * FROM query_rewrite.rewrite_rules;
106
107 --echo # 3. Syntax error in the pattern.
108 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
109 VALUES ( 'SELECT c1 FROM test.t1 WHERE dqdq c1 = ? OR c2 = ?',
110 'SELECT * FROM test.t1 WHERE c2 = ? OR c1 = ?' );
111
112 --error ER_SIGNAL_EXCEPTION
113 CALL query_rewrite.flush_rewrite_rules();
114
115 SHOW STATUS LIKE 'Rewriter_reload_error';
116 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
117
118 SELECT * FROM query_rewrite.rewrite_rules;
119
120 --echo # 4 Empty/NULL replacement/pattern
121 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
122 VALUES ( 'SELECT c1 FROM test.t1 WHERE c2 = ?', '' );
123
124 --error ER_SIGNAL_EXCEPTION
125 CALL query_rewrite.flush_rewrite_rules();
126
127 SHOW STATUS LIKE 'Rewriter_reload_error';
128 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
129
130 SELECT * FROM query_rewrite.rewrite_rules;
131
132 DELETE FROM query_rewrite.rewrite_rules
133 WHERE pattern = 'SELECT c1 FROM test.t1 WHERE c2 = ?';
134
135 ALTER TABLE query_rewrite.rewrite_rules
136 MODIFY COLUMN replacement VARCHAR(10000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
137
138 INSERT INTO query_rewrite.rewrite_rules ( pattern )
139 VALUES ( 'SELECT c1 FROM test.t1 WHERE c2 = ?' );
140
141 --error ER_SIGNAL_EXCEPTION
142 CALL query_rewrite.flush_rewrite_rules();
143
144 SHOW STATUS LIKE 'Rewriter_reload_error';
145 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
146
147 SELECT * FROM query_rewrite.rewrite_rules;
148
149 DELETE FROM query_rewrite.rewrite_rules
150 WHERE pattern = 'SELECT c1 FROM test.t1 WHERE c2 = ?';
151
152 ALTER TABLE query_rewrite.rewrite_rules
153 MODIFY COLUMN pattern VARCHAR(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
154
155 INSERT INTO query_rewrite.rewrite_rules ( replacement )
156 VALUES ( 'SELECT c1 FROM test.t1 WHERE c2 = ?' );
157
158 --error ER_SIGNAL_EXCEPTION
159 CALL query_rewrite.flush_rewrite_rules();
160
161 SHOW STATUS LIKE 'Rewriter_reload_error';
162 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
163
164 SELECT * FROM query_rewrite.rewrite_rules;
165
166 --echo # 5 More parameters in the replacement than the pattern
167 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
168 VALUES
169 ( 'SELECT * FROM test.t1 WHERE c1 = ?', 'SELECT * FROM test.t2 WHERE c2 = ? AND c1 = ?' );
170
171 --error ER_SIGNAL_EXCEPTION
172 CALL query_rewrite.flush_rewrite_rules();
173
174 SHOW STATUS LIKE 'Rewriter_reload_error';
175 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
176
177 SELECT * FROM test.t1 WHERE c1 = 'abc';
178
179 SELECT * FROM query_rewrite.rewrite_rules;
180
181 --echo # 6 A replacement that does not have syntax errors in itself, but the
182 --echo # rewritten query does.
183 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
184 VALUES ( 'SELECT "Fail, please", ?', 'SELECT 1 LIMIT ?' );
185
186 --error ER_SIGNAL_EXCEPTION
187 CALL query_rewrite.flush_rewrite_rules();
188
189 SELECT * FROM query_rewrite.rewrite_rules;
190
191 SHOW STATUS LIKE 'Rewriter_reload_error';
192 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
193
194 SET @@global.rewriter_verbose = 2;
195
196 --error ER_PARSE_ERROR
197 SELECT 'Fail, please', 'a';
198
199 --echo # Check that the one rule without errors is still rewritten and executed.
200 SELECT c1 FROM test.t1;
201
202 --echo # Fix rule 1 (error in the replacement.)
203 UPDATE query_rewrite.rewrite_rules
204 SET replacement = 'SELECT c1 FROM test.t2 WHERE c1 = ?', enabled = 'YES'
205 WHERE pattern = 'SELECT c1 FROM test.t1 WHERE c1 = ?';
206
207 --error ER_SIGNAL_EXCEPTION
208 CALL query_rewrite.flush_rewrite_rules();
209
210 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
211
212 SELECT c1 FROM test.t1 WHERE c1 = 'abc';
213 SELECT c1 FROM test.t2 WHERE c1 = 'tuv';
214
215 SELECT * FROM query_rewrite.rewrite_rules;
216
217 --echo # Check that the rule without error is still executed and rewritten.
218 SELECT c1 FROM test.t1;
219
220 --echo # Remove all the rules that cause errors.
221 DELETE FROM query_rewrite.rewrite_rules WHERE pattern <> 'SELECT c1 FROM test.t1';
222 DELETE FROM query_rewrite.rewrite_rules WHERE pattern IS NULL;
223 DELETE FROM query_rewrite.rewrite_rules WHERE replacement IS NULL;
224
225 SHOW STATUS LIKE 'Rewriter_reload_error';
226 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
227 SHOW STATUS LIKE 'Rewriter_number_reloads';
228
229 --echo # Check that a rule that used to have syntax error now works fine.
230 SELECT c1 FROM t1 WHERE c1 = 'abc';
231
232 --echo # Check that the rule without error is still executed and rewritten.
233 SELECT c1 FROM test.t1;
234
235 --echo # A rule with parse error followed by a correct rule should still turn
236 --echo # Rewriter_reload_error to true.
237 DELETE FROM query_rewrite.rewrite_rules;
238
239 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
240 VALUES ( 'error', 'error' ),
241 ( 'select 1', 'select 2' );
242
243 --error ER_SIGNAL_EXCEPTION
244 CALL query_rewrite.flush_rewrite_rules();
245
246 SELECT * FROM query_rewrite.rewrite_rules;
247
248 SHOW STATUS LIKE 'Rewriter_reload_error';
249
250 --echo #
251 --echo # Test of what happens if pfs digests are turned off.
252 --echo #
253
254 UPDATE performance_schema.setup_consumers
255 SET enabled = 'NO'
256 WHERE NAME = 'statements_digest';
257
258 --echo # Rewrites should still work.
259 SELECT 1;
260
261 PREPARE stmt1 FROM 'SELECT 1';
262 EXECUTE stmt1;
263
264 --echo # Restore the setting.
265 UPDATE performance_schema.setup_consumers
266 SET enabled = 'YES'
267 WHERE NAME = 'statements_digest';
268
269 --echo # Let's try to uninstall the plugin the wrong way, that is, not using the
270 --echo # script. The library will not be unloaded so we can still call the UDF
271 --echo # but it should return an error.
272 UNINSTALL PLUGIN rewriter;
273 --source include/disconnect_connections.inc
274
275 --error ER_CANT_INITIALIZE_UDF
276 CALL query_rewrite.flush_rewrite_rules();
277 --error ER_CANT_INITIALIZE_UDF
278 SELECT load_rewrite_rules();
279
280 --source suite/query_rewrite_plugins/include/uninstall_rewriter.inc
281 --source suite/query_rewrite_plugins/include/drop_error_log.inc
282
283 DROP TABLE t1, t2;