Debian Codegraph @

mysql-test/suite/audit_null/r/audit_plugin_2.result

raw
1 call mtr.add_suppression("Event 'MYSQL_AUDIT_COMMAND_END' cannot be aborted.");
2 call mtr.add_suppression("Event 'MYSQL_AUDIT_CONNECTION_DISCONNECT' cannot be aborted.");
3 call mtr.add_suppression("Event 'MYSQL_AUDIT_GENERAL_RESULT' cannot be aborted.");
4 call mtr.add_suppression("Event 'MYSQL_AUDIT_GENERAL_STATUS' cannot be aborted.");
5 call mtr.add_suppression("Command 'Ping' cannot be aborted.");
6 call mtr.add_suppression("Plugin mysqlx reported.*Unable to use user mysql.session");
7 call mtr.add_suppression("Plugin mysqlx reported: 'Internal error");
8 INSTALL PLUGIN null_audit SONAME 'adt_null.<expected_extension>';
9 ################
10 ## CONNECTION ##
11 ################
12 CREATE USER user1@localhost IDENTIFIED BY 'pass';
13 SET GLOBAL null_audit_event_order_check = "MYSQL_AUDIT_CONNECTION_PRE_AUTHENTICATE;;ABORT_RET";
14 connect(localhost,user1,pass,test,MASTER_PORT,MASTER_SOCKET);
15 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_CONNECTION_PRE_AUTHENTICATE';1).
16 SET GLOBAL null_audit_event_order_check = "MYSQL_AUDIT_CONNECTION_PRE_AUTHENTICATE;;;"
17 "MYSQL_AUDIT_GENERAL_LOG;;;"
18 "MYSQL_AUDIT_CONNECTION_CONNECT;;ABORT_RET";
19 connect(localhost,user1,pass,test,MASTER_PORT,MASTER_SOCKET);
20 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_CONNECTION_CONNECT';1).
21 SET GLOBAL null_audit_event_order_check = NULL;
22 SET GLOBAL null_audit_event_order_check = "MYSQL_AUDIT_CONNECTION_DISCONNECT;;ABORT_RET";
23 # mysql_audit_connection_disconnect result does not have any significance
24 SET GLOBAL null_audit_event_order_check = NULL;
25 #############
26 ## COMMAND ##
27 #############
28 # Command start abort
29 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";ABORT_RET';
30 SELECT 1;
31 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_COMMAND_START';1).
32 SELECT @@null_audit_event_order_check;
33 @@null_audit_event_order_check
34 EVENT-ORDER-ABORT
35 SELECT 1;
36 1
37 1
38 SET @@GLOBAL.null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="14";ABORT_RET';
39 mysqld is alive
40 SET @@GLOBAL.null_audit_event_order_check = NULL;
41 #############
42 ## GENERAL ##
43 #############
44 ##########################
45 ## ABORT GENERAL RESULT ##
46 ##########################
47 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
48 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
49 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
50 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
51 'MYSQL_AUDIT_GENERAL_LOG;;;'
52 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
53 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="0";;'
54 'MYSQL_AUDIT_GENERAL_RESULT;;ABORT_RET';
55 SELECT 1;
56 1
57 1
58 SELECT @@null_audit_event_order_check;
59 @@null_audit_event_order_check
60 EVENT-ORDER-ABORT
61 ##########################################
62 ## ABORT GENERAL RESULT WITH MY_MESSAGE ##
63 ##########################################
64 SET @@null_audit_abort_message = "Abort with my_message.";
65 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
66 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
67 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
68 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
69 'MYSQL_AUDIT_GENERAL_LOG;;;'
70 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
71 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="0";;'
72 'MYSQL_AUDIT_GENERAL_RESULT;;ABORT_RET';
73 SELECT 1;
74 1
75 1
76 SELECT @@null_audit_event_order_check;
77 @@null_audit_event_order_check
78 EVENT-ORDER-ABORT
79 ##########################
80 ## ABORT GENERAL STATUS ##
81 ##########################
82 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
83 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
84 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
85 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
86 'MYSQL_AUDIT_GENERAL_LOG;;;'
87 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
88 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="0";;'
89 'MYSQL_AUDIT_GENERAL_RESULT;;;'
90 'MYSQL_AUDIT_GENERAL_STATUS;;ABORT_RET';
91 SELECT 1;
92 1
93 1
94 SELECT @@null_audit_event_order_check;
95 @@null_audit_event_order_check
96 EVENT-ORDER-ABORT
97 ##########################################
98 ## ABORT GENERAL STATUS WITH MY_MESSAGE ##
99 ##########################################
100 SET @@null_audit_abort_message = "Abort with my_message.";
101 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
102 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
103 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
104 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
105 'MYSQL_AUDIT_GENERAL_LOG;;;'
106 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
107 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="0";;'
108 'MYSQL_AUDIT_GENERAL_RESULT;;;'
109 'MYSQL_AUDIT_GENERAL_STATUS;;ABORT_RET';
110 SELECT 1;
111 1
112 1
113 SELECT @@null_audit_event_order_check;
114 @@null_audit_event_order_check
115 EVENT-ORDER-ABORT
116 ###########
117 ## QUERY ##
118 ###########
119 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
120 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
121 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
122 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
123 'MYSQL_AUDIT_GENERAL_LOG;;;'
124 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";ABORT_RET';
125 SELECT 1;
126 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_QUERY_START';1).
127 SELECT @@null_audit_event_order_check;
128 @@null_audit_event_order_check
129 EVENT-ORDER-ABORT
130 SELECT 1;
131 1
132 1
133 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
134 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
135 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
136 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
137 'MYSQL_AUDIT_GENERAL_LOG;;;'
138 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
139 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="0";ABORT_RET';
140 SELECT 1;
141 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_QUERY_STATUS_END';1).
142 SELECT @@null_audit_event_order_check;
143 @@null_audit_event_order_check
144 EVENT-ORDER-ABORT
145 SELECT 1;
146 1
147 1
148 ##############
149 ## VARIABLE ##
150 ##############
151 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
152 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
153 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
154 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
155 'MYSQL_AUDIT_GENERAL_LOG;;;'
156 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
157 'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;name="null_audit_abort_value" value="1";ABORT_RET';
158 SELECT @@GLOBAL.null_audit_abort_value;
159 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_GLOBAL_VARIABLE_GET';1).
160 SELECT @@null_audit_event_order_check;
161 @@null_audit_event_order_check
162 EVENT-ORDER-ABORT
163 SELECT @@GLOBAL.null_audit_abort_value;
164 @@GLOBAL.null_audit_abort_value
165 1
166 ## SESSION variable access should not be blocked.
167 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
168 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
169 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
170 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
171 'MYSQL_AUDIT_GENERAL_LOG;;;'
172 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
173 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="0";';
174 SELECT @@null_audit_abort_value;
175 @@null_audit_abort_value
176 1
177 SELECT @@null_audit_event_order_check;
178 @@null_audit_event_order_check
179 EVENT-ORDER-OK
180 # SHOW GLOBAL VARIABLE
181 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
182 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
183 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
184 'MYSQL_AUDIT_GENERAL_LOG;;;'
185 'MYSQL_AUDIT_QUERY_START;sql_command_id="15";;'
186 'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;<IGNORE>;ABORT_RET',
187 @@null_audit_event_order_check_exact = 1;
188 SHOW GLOBAL VARIABLES LIKE 'null_audit_abort_value';
189 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_GLOBAL_VARIABLE_GET';1).
190 SELECT @@null_audit_event_order_check;
191 @@null_audit_event_order_check
192 EVENT-ORDER-ABORT
193 SHOW GLOBAL VARIABLES LIKE 'null_audit_abort_value';
194 Variable_name Value
195 null_audit_abort_value 1
196 # SHOW GLOBAL VARIABLE
197 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
198 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
199 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
200 'MYSQL_AUDIT_GENERAL_LOG;;;'
201 'MYSQL_AUDIT_QUERY_START;sql_command_id="15";;'
202 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="15";';
203 SHOW SESSION VARIABLES LIKE 'null_audit_abort_value';
204 Variable_name Value
205 null_audit_abort_value 1
206 SELECT @@null_audit_event_order_check;
207 @@null_audit_event_order_check
208 EVENT-ORDER-OK
209 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
210 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
211 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
212 'MYSQL_AUDIT_GENERAL_LOG;;;'
213 'MYSQL_AUDIT_QUERY_START;sql_command_id="31";;'
214 'MYSQL_AUDIT_GLOBAL_VARIABLE_SET;name="null_audit_event_order_check" value="NULL";ABORT_RET',
215 @@null_audit_event_order_check_exact = 1;
216 SET @@GLOBAL.null_audit_event_order_check = NULL;
217 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_GLOBAL_VARIABLE_SET';1).
218 SELECT @@null_audit_event_order_check;
219 @@null_audit_event_order_check
220 EVENT-ORDER-ABORT
221 SET @@GLOBAL.null_audit_event_order_check = NULL;
222 # Global variables through virtual tables
223 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
224 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
225 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
226 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
227 'MYSQL_AUDIT_GENERAL_LOG;;;'
228 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
229 'MYSQL_AUDIT_GLOBAL_VARIABLE_GET;name="null_audit_abort_value" value="1";ABORT_RET';
230 SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME = 'null_audit_abort_value';
231 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_GLOBAL_VARIABLE_GET';1).
232 SELECT @@null_audit_event_order_check;
233 @@null_audit_event_order_check
234 EVENT-ORDER-ABORT
235 ###############################
236 ## QUERY - FIRST LEVEL ABORT ##
237 ###############################
238 CREATE DATABASE super_test;
239 USE super_test;
240 CREATE TABLE test_table (a INT);
241 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
242 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
243 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
244 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
245 'MYSQL_AUDIT_GENERAL_LOG;;;'
246 'MYSQL_AUDIT_QUERY_START;sql_command_id="5";;'
247 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table";;'
248 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="5";ABORT_RET';
249 INSERT INTO test_table VALUES(1);
250 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_QUERY_STATUS_END';1).
251 SELECT * FROM test_table;
252 a
253 SELECT @@null_audit_event_order_check;
254 @@null_audit_event_order_check
255 EVENT-ORDER-ABORT
256 INSERT INTO test_table VALUES(2);
257 SELECT * FROM test_table;
258 a
259 2
260 DELETE FROM test_table;
261 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
262 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
263 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
264 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
265 'MYSQL_AUDIT_GENERAL_LOG;;;'
266 'MYSQL_AUDIT_QUERY_START;sql_command_id="5";ABORT_RET';
267 INSERT INTO test_table VALUES(1);
268 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_QUERY_START';1).
269 SELECT @@null_audit_event_order_check;
270 @@null_audit_event_order_check
271 EVENT-ORDER-ABORT
272 SELECT * FROM test_table;
273 a
274 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
275 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
276 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
277 'MYSQL_AUDIT_GENERAL_LOG;;;'
278 'MYSQL_AUDIT_QUERY_START;sql_command_id="5";;'
279 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table";;'
280 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="5";;'
281 'MYSQL_AUDIT_GENERAL_STATUS;;;'
282 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
283 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
284 'MYSQL_AUDIT_GENERAL_LOG;;;'
285 'MYSQL_AUDIT_QUERY_START;sql_command_id="5";;'
286 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table";;'
287 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="5";ABORT_RET',
288 @@null_audit_event_order_check_exact = 1;
289 INSERT INTO test_table VALUES(3); INSERT INTO test_table VALUES(4); |;
290 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_QUERY_STATUS_END';1).
291 SELECT @@null_audit_event_order_check;
292 @@null_audit_event_order_check
293 EVENT-ORDER-ABORT
294 SELECT * FROM test_table;
295 a
296 3
297 DELETE FROM test_table;
298 CREATE PROCEDURE simple_proc()
299 BEGIN
300 INSERT INTO test_table VALUES(1);
301 INSERT INTO test_table VALUES(2);
302 END|;
303 CREATE PROCEDURE simple_proc2()
304 BEGIN
305 INSERT INTO test_table VALUES(1);
306 INSERT INTO test_table VALUES('a');
307 END|;
308 CALL simple_proc();
309 SELECT @@null_audit_event_order_check;
310 @@null_audit_event_order_check
311 EVENT-ORDER-ABORT
312 SELECT * FROM test_table;
313 a
314 1
315 2
316 DELETE FROM test_table;
317 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
318 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
319 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
320 'MYSQL_AUDIT_GENERAL_LOG;;;'
321 'MYSQL_AUDIT_QUERY_START;sql_command_id="91";;'
322 'MYSQL_AUDIT_STORED_PROGRAM_EXECUTE;;;'
323 'MYSQL_AUDIT_QUERY_NESTED_START;sql_command_id="5";;'
324 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table";;'
325 'MYSQL_AUDIT_QUERY_NESTED_STATUS_END;sql_command_id="5";;'
326 'MYSQL_AUDIT_QUERY_NESTED_START;sql_command_id="5";;'
327 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table";;'
328 'MYSQL_AUDIT_QUERY_NESTED_STATUS_END;sql_command_id="5";;'
329 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="91";ABORT_RET',
330 @@null_audit_event_order_check_exact = 1;
331 CALL simple_proc();
332 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_QUERY_STATUS_END';1).
333 SELECT @@null_audit_event_order_check;
334 @@null_audit_event_order_check
335 EVENT-ORDER-ABORT
336 SELECT * FROM test_table;
337 a
338 1
339 2
340 DELETE FROM test_table;
341 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
342 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
343 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
344 'MYSQL_AUDIT_GENERAL_LOG;;;'
345 'MYSQL_AUDIT_QUERY_START;sql_command_id="91";;'
346 'MYSQL_AUDIT_STORED_PROGRAM_EXECUTE;;;'
347 'MYSQL_AUDIT_QUERY_NESTED_START;sql_command_id="5";;'
348 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table";;'
349 'MYSQL_AUDIT_QUERY_NESTED_STATUS_END;sql_command_id="5";;'
350 'MYSQL_AUDIT_QUERY_NESTED_START;sql_command_id="5";;'
351 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table";;'
352 'MYSQL_AUDIT_QUERY_NESTED_STATUS_END;sql_command_id="5";;'
353 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="91";;'
354 'MYSQL_AUDIT_GENERAL_RESULT;;;'
355 'MYSQL_AUDIT_GENERAL_STATUS;;;'
356 'MYSQL_AUDIT_COMMAND_END;command_id="3";',
357 @@null_audit_event_order_check_exact = 1;
358 CALL simple_proc();
359 SELECT @@null_audit_event_order_check;
360 @@null_audit_event_order_check
361 EVENT-ORDER-OK
362 SELECT * FROM test_table;
363 a
364 1
365 2
366 DELETE FROM test_table;
367 call simple_proc2();
368 ERROR HY000: Incorrect integer value: 'a' for column 'a' at row 1
369 SELECT * FROM test_table;
370 a
371 1
372 DELETE FROM test_table;
373 CREATE TABLE test_table_2 (a INT) ENGINE=InnoDB;
374 CREATE PROCEDURE proc()
375 BEGIN
376 DECLARE EXIT HANDLER FOR SQLEXCEPTION ROLLBACK;
377 START TRANSACTION;
378 insert into test_table_2 values(1);
379 insert into test_table_2 values(2);
380 COMMIT WORK;
381 END|
382 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
383 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
384 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
385 'MYSQL_AUDIT_GENERAL_LOG;;;'
386 'MYSQL_AUDIT_QUERY_START;sql_command_id="91";;'
387 'MYSQL_AUDIT_STORED_PROGRAM_EXECUTE;;;'
388 'MYSQL_AUDIT_QUERY_NESTED_START;sql_command_id="61";;'
389 'MYSQL_AUDIT_QUERY_NESTED_STATUS_END;sql_command_id="61";;'
390 'MYSQL_AUDIT_QUERY_NESTED_START;sql_command_id="5";;'
391 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table_2";;'
392 'MYSQL_AUDIT_QUERY_NESTED_STATUS_END;sql_command_id="5";;'
393 'MYSQL_AUDIT_QUERY_NESTED_START;sql_command_id="5";;'
394 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table_2";;'
395 'MYSQL_AUDIT_QUERY_NESTED_STATUS_END;sql_command_id="5";;'
396 'MYSQL_AUDIT_QUERY_NESTED_START;sql_command_id="54";;'
397 'MYSQL_AUDIT_QUERY_NESTED_STATUS_END;sql_command_id="54";;'
398 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="91";;'
399 'MYSQL_AUDIT_GENERAL_RESULT;;;'
400 'MYSQL_AUDIT_GENERAL_STATUS;;;'
401 'MYSQL_AUDIT_COMMAND_END;command_id="3";',
402 @@null_audit_event_order_check_exact = 1;
403 CALL proc();
404 SELECT @@null_audit_event_order_check;
405 @@null_audit_event_order_check
406 EVENT-ORDER-OK
407 SELECT * FROM test_table_2 ORDER BY a;
408 a
409 1
410 2
411 DELETE FROM test_table_2;
412 ## ABORT ON COMMIT START
413 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
414 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
415 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
416 'MYSQL_AUDIT_GENERAL_LOG;;;'
417 'MYSQL_AUDIT_QUERY_START;sql_command_id="91";;'
418 'MYSQL_AUDIT_STORED_PROGRAM_EXECUTE;;;'
419 'MYSQL_AUDIT_QUERY_NESTED_START;sql_command_id="61";;'
420 'MYSQL_AUDIT_QUERY_NESTED_STATUS_END;sql_command_id="61";;'
421 'MYSQL_AUDIT_QUERY_NESTED_START;sql_command_id="5";;'
422 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table_2";;'
423 'MYSQL_AUDIT_QUERY_NESTED_STATUS_END;sql_command_id="5";;'
424 'MYSQL_AUDIT_QUERY_NESTED_START;sql_command_id="5";;'
425 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table_2";;'
426 'MYSQL_AUDIT_QUERY_NESTED_STATUS_END;sql_command_id="5";;'
427 'MYSQL_AUDIT_QUERY_NESTED_START;sql_command_id="54";ABORT_RET',
428 @@null_audit_event_order_check_exact = 1;
429 CALL proc();
430 SELECT @@null_audit_event_order_check;
431 @@null_audit_event_order_check
432 EVENT-ORDER-ABORT
433 SELECT * FROM test_table_2;
434 a
435 DELETE FROM test_table_2;
436 ## ABORT ON COMMIT
437 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
438 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
439 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
440 'MYSQL_AUDIT_GENERAL_LOG;;;'
441 'MYSQL_AUDIT_QUERY_START;sql_command_id="91";;'
442 'MYSQL_AUDIT_STORED_PROGRAM_EXECUTE;;;'
443 'MYSQL_AUDIT_QUERY_NESTED_START;sql_command_id="61";;'
444 'MYSQL_AUDIT_QUERY_NESTED_STATUS_END;sql_command_id="61";;'
445 'MYSQL_AUDIT_QUERY_NESTED_START;sql_command_id="5";;'
446 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table_2";;'
447 'MYSQL_AUDIT_QUERY_NESTED_STATUS_END;sql_command_id="5";;'
448 'MYSQL_AUDIT_QUERY_NESTED_START;sql_command_id="5";;'
449 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table_2";;'
450 'MYSQL_AUDIT_QUERY_NESTED_STATUS_END;sql_command_id="5";;'
451 'MYSQL_AUDIT_QUERY_NESTED_START;sql_command_id="54";;'
452 'MYSQL_AUDIT_QUERY_NESTED_STATUS_END;sql_command_id="54";ABORT_RET',
453 @@null_audit_event_order_check_exact = 1;
454 CALL proc();
455 SELECT @@null_audit_event_order_check;
456 @@null_audit_event_order_check
457 EVENT-ORDER-ABORT
458 SELECT * FROM test_table_2;
459 a
460 1
461 2
462 DELETE FROM test_table_2;
463 ## Not nested queries
464 INSERT INTO test_table VALUES(1),(2),(3);
465 INSERT INTO test_table_2 VALUES(1),(2),(3);
466 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
467 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
468 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
469 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
470 'MYSQL_AUDIT_GENERAL_LOG;;;'
471 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
472 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="test_table";;'
473 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="test_table_2";;'
474 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="0";;'
475 'MYSQL_AUDIT_GENERAL_RESULT;;;'
476 'MYSQL_AUDIT_GENERAL_STATUS;;;'
477 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
478 SELECT test_table.a FROM test_table WHERE EXISTS (SELECT test_table_2.a from test_table_2 WHERE test_table.a = test_table_2.a) ORDER BY test_table.a;
479 a
480 1
481 2
482 3
483 SELECT @@null_audit_event_order_check;
484 @@null_audit_event_order_check
485 EVENT-ORDER-OK
486 ## A query that references single table two times. Two READ events should be triggered.
487 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
488 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
489 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
490 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
491 'MYSQL_AUDIT_GENERAL_LOG;;;'
492 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
493 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="test_table";;'
494 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="test_table";;'
495 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="0";;'
496 'MYSQL_AUDIT_GENERAL_RESULT;;;'
497 'MYSQL_AUDIT_GENERAL_STATUS;;;'
498 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
499 SELECT t1.a FROM test_table as t1 WHERE EXISTS (SELECT t2.a from test_table as t2 WHERE t1.a = t2.a) ORDER BY t1.a;
500 a
501 1
502 2
503 3
504 SELECT @@null_audit_event_order_check;
505 @@null_audit_event_order_check
506 EVENT-ORDER-OK
507 ## A query that references single table two times. Two READ events should be triggered.
508 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
509 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
510 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
511 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
512 'MYSQL_AUDIT_GENERAL_LOG;;;'
513 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
514 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="test_table";;'
515 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="test_table_2";;'
516 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="0";;'
517 'MYSQL_AUDIT_GENERAL_RESULT;;;'
518 'MYSQL_AUDIT_GENERAL_STATUS;;;'
519 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
520 SELECT * FROM test_table AS t1, test_table_2 AS t2 ORDER BY t1.a, t2.a;
521 a a
522 1 1
523 1 2
524 1 3
525 2 1
526 2 2
527 2 3
528 3 1
529 3 2
530 3 3
531 SELECT @@null_audit_event_order_check;
532 @@null_audit_event_order_check
533 EVENT-ORDER-OK
534 DELETE FROM test_table;
535 DELETE FROM test_table_2;
536 #########################
537 ## TABLE_ACCESS - READ ##
538 #########################
539 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
540 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
541 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
542 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
543 'MYSQL_AUDIT_GENERAL_LOG;;;'
544 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
545 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="test_table";;'
546 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="0";;'
547 'MYSQL_AUDIT_GENERAL_RESULT;;;'
548 'MYSQL_AUDIT_GENERAL_STATUS;;;'
549 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
550 SELECT * FROM test_table;
551 a
552 SELECT @@null_audit_event_order_check;
553 @@null_audit_event_order_check
554 EVENT-ORDER-OK
555 LOCK TABLES test_table READ;
556 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
557 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
558 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
559 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
560 'MYSQL_AUDIT_GENERAL_LOG;;;'
561 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
562 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="test_table";;'
563 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="0";;'
564 'MYSQL_AUDIT_GENERAL_RESULT;;;'
565 'MYSQL_AUDIT_GENERAL_STATUS;;;'
566 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
567 SELECT * FROM test_table;
568 a
569 SELECT @@null_audit_event_order_check;
570 @@null_audit_event_order_check
571 EVENT-ORDER-OK
572 UNLOCK TABLES;
573 CREATE TEMPORARY TABLE audit_temp_table (a INT);
574 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
575 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
576 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
577 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
578 'MYSQL_AUDIT_GENERAL_LOG;;;'
579 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
580 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="0";;'
581 'MYSQL_AUDIT_GENERAL_RESULT;;;'
582 'MYSQL_AUDIT_GENERAL_STATUS;;;'
583 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
584 SELECT * FROM audit_temp_table;
585 a
586 SELECT @@null_audit_event_order_check;
587 @@null_audit_event_order_check
588 EVENT-ORDER-OK
589 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
590 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
591 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
592 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
593 'MYSQL_AUDIT_GENERAL_LOG;;;'
594 'MYSQL_AUDIT_QUERY_START;sql_command_id="51";;'
595 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="test_table";;'
596 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="51";;'
597 'MYSQL_AUDIT_GENERAL_RESULT;;;'
598 'MYSQL_AUDIT_GENERAL_STATUS;;;'
599 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
600 ANALYZE TABLE test_table UPDATE HISTOGRAM ON a;
601 Table Op Msg_type Msg_text
602 super_test.test_table histogram status Histogram statistics created for column 'a'.
603 SELECT @@null_audit_event_order_check;
604 @@null_audit_event_order_check
605 EVENT-ORDER-OK
606 ANALYZE TABLE test_table DROP HISTOGRAM ON a;
607 Table Op Msg_type Msg_text
608 super_test.test_table histogram status Histogram statistics removed for column 'a'.
609 ###########################
610 ## TABLE_ACCESS - INSERT ##
611 ###########################
612 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
613 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
614 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
615 'MYSQL_AUDIT_GENERAL_LOG;;;'
616 'MYSQL_AUDIT_QUERY_START;sql_command_id="5";;'
617 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table";ABORT_RET';
618 INSERT INTO test_table VALUES (1),(2);
619 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_TABLE_ACCESS_INSERT';1).
620 SELECT * FROM test_table ORDER BY a;
621 a
622 SELECT @@null_audit_event_order_check;
623 @@null_audit_event_order_check
624 EVENT-ORDER-ABORT
625 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
626 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
627 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
628 'MYSQL_AUDIT_GENERAL_LOG;;;'
629 'MYSQL_AUDIT_QUERY_START;sql_command_id="5";;'
630 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table";;'
631 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="5";;'
632 'MYSQL_AUDIT_GENERAL_RESULT;;;'
633 'MYSQL_AUDIT_GENERAL_STATUS;;;'
634 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
635 INSERT INTO test_table VALUES (1),(2);
636 SELECT * FROM test_table ORDER BY a;
637 a
638 1
639 2
640 SELECT @@null_audit_event_order_check;
641 @@null_audit_event_order_check
642 EVENT-ORDER-OK
643 LOCK TABLES test_table WRITE;
644 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
645 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
646 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
647 'MYSQL_AUDIT_GENERAL_LOG;;;'
648 'MYSQL_AUDIT_QUERY_START;sql_command_id="5";;'
649 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table";;'
650 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="5";;'
651 'MYSQL_AUDIT_GENERAL_RESULT;;;'
652 'MYSQL_AUDIT_GENERAL_STATUS;;;'
653 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
654 INSERT INTO test_table VALUES (101),(102);
655 SELECT * FROM test_table ORDER BY a;
656 a
657 1
658 2
659 101
660 102
661 SELECT @@null_audit_event_order_check;
662 @@null_audit_event_order_check
663 EVENT-ORDER-OK
664 UNLOCK TABLES;
665 LOCK TABLES test_table WRITE;
666 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
667 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
668 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
669 'MYSQL_AUDIT_GENERAL_LOG;;;'
670 'MYSQL_AUDIT_QUERY_START;sql_command_id="5";;'
671 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="5";;'
672 'MYSQL_AUDIT_GENERAL_RESULT;;;'
673 'MYSQL_AUDIT_GENERAL_STATUS;;;'
674 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
675 INSERT INTO audit_temp_table VALUES (1),(2);
676 SELECT * FROM audit_temp_table ORDER BY a;
677 a
678 1
679 2
680 SELECT @@null_audit_event_order_check;
681 @@null_audit_event_order_check
682 EVENT-ORDER-OK
683 UNLOCK TABLES;
684 DELETE FROM test_table WHERE a > 100;
685 ##################################
686 ## TABLE_ACCESS - INSERT SELECT ##
687 ##################################
688 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
689 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
690 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
691 'MYSQL_AUDIT_GENERAL_LOG;;;'
692 'MYSQL_AUDIT_QUERY_START;sql_command_id="6";;'
693 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table";ABORT_RET';
694 INSERT INTO test_table SELECT a+2 FROM test_table;
695 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_TABLE_ACCESS_INSERT';1).
696 SELECT * FROM test_table ORDER BY a;
697 a
698 1
699 2
700 SELECT @@null_audit_event_order_check;
701 @@null_audit_event_order_check
702 EVENT-ORDER-ABORT
703 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
704 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
705 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
706 'MYSQL_AUDIT_GENERAL_LOG;;;'
707 'MYSQL_AUDIT_QUERY_START;sql_command_id="6";;'
708 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table";;'
709 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="test_table";ABORT_RET';
710 INSERT INTO test_table SELECT a+2 FROM test_table;
711 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_TABLE_ACCESS_READ';1).
712 SELECT * FROM test_table ORDER BY a;
713 a
714 1
715 2
716 SELECT @@null_audit_event_order_check;
717 @@null_audit_event_order_check
718 EVENT-ORDER-ABORT
719 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
720 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
721 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
722 'MYSQL_AUDIT_GENERAL_LOG;;;'
723 'MYSQL_AUDIT_QUERY_START;sql_command_id="6";;'
724 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table";;'
725 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="test_table";;'
726 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="6";;'
727 'MYSQL_AUDIT_GENERAL_RESULT;;;'
728 'MYSQL_AUDIT_GENERAL_STATUS;;;'
729 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
730 INSERT INTO test_table SELECT a+2 FROM test_table;
731 SELECT * FROM test_table ORDER BY a;
732 a
733 1
734 2
735 3
736 4
737 SELECT @@null_audit_event_order_check;
738 @@null_audit_event_order_check
739 EVENT-ORDER-OK
740 LOCK TABLES test_table WRITE, test_table AS test_table_l READ;
741 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
742 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
743 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
744 'MYSQL_AUDIT_GENERAL_LOG;;;'
745 'MYSQL_AUDIT_QUERY_START;sql_command_id="6";;'
746 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table";;'
747 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="test_table";;'
748 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="6";;'
749 'MYSQL_AUDIT_GENERAL_RESULT;;;'
750 'MYSQL_AUDIT_GENERAL_STATUS;;;'
751 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
752 INSERT INTO test_table SELECT a+100 FROM test_table AS test_table_l;
753 SELECT * FROM test_table ORDER BY a;
754 a
755 1
756 2
757 3
758 4
759 101
760 102
761 103
762 104
763 SELECT @@null_audit_event_order_check;
764 @@null_audit_event_order_check
765 EVENT-ORDER-OK
766 UNLOCK TABLES;
767 DELETE FROM test_table WHERE a > 100;
768 ###########################
769 ## TABLE_ACCESS - UPDATE ##
770 ###########################
771 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
772 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
773 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
774 'MYSQL_AUDIT_GENERAL_LOG;;;'
775 'MYSQL_AUDIT_QUERY_START;sql_command_id="4";;'
776 'MYSQL_AUDIT_TABLE_ACCESS_UPDATE;db="super_test" table="test_table";ABORT_RET';
777 UPDATE test_table SET a=a+4;
778 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_TABLE_ACCESS_UPDATE';1).
779 SELECT * FROM test_table ORDER BY a;
780 a
781 1
782 2
783 3
784 4
785 SELECT @@null_audit_event_order_check;
786 @@null_audit_event_order_check
787 EVENT-ORDER-ABORT
788 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
789 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
790 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
791 'MYSQL_AUDIT_GENERAL_LOG;;;'
792 'MYSQL_AUDIT_QUERY_START;sql_command_id="4";;'
793 'MYSQL_AUDIT_TABLE_ACCESS_UPDATE;db="super_test" table="test_table";;'
794 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="4";;'
795 'MYSQL_AUDIT_GENERAL_RESULT;;;'
796 'MYSQL_AUDIT_GENERAL_STATUS;;;'
797 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
798 UPDATE test_table SET a=a+4;
799 SELECT * FROM test_table ORDER BY a;
800 a
801 5
802 6
803 7
804 8
805 SELECT @@null_audit_event_order_check;
806 @@null_audit_event_order_check
807 EVENT-ORDER-OK
808 LOCK TABLES test_table WRITE;
809 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
810 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
811 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
812 'MYSQL_AUDIT_GENERAL_LOG;;;'
813 'MYSQL_AUDIT_QUERY_START;sql_command_id="4";;'
814 'MYSQL_AUDIT_TABLE_ACCESS_UPDATE;db="super_test" table="test_table";;'
815 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="4";;'
816 'MYSQL_AUDIT_GENERAL_RESULT;;;'
817 'MYSQL_AUDIT_GENERAL_STATUS;;;'
818 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
819 UPDATE test_table SET a=a+4;
820 SELECT * FROM test_table ORDER BY a;
821 a
822 9
823 10
824 11
825 12
826 SELECT @@null_audit_event_order_check;
827 @@null_audit_event_order_check
828 EVENT-ORDER-OK
829 UNLOCK TABLES;
830 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
831 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
832 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
833 'MYSQL_AUDIT_GENERAL_LOG;;;'
834 'MYSQL_AUDIT_QUERY_START;sql_command_id="4";;'
835 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="4";;'
836 'MYSQL_AUDIT_GENERAL_RESULT;;;'
837 'MYSQL_AUDIT_GENERAL_STATUS;;;'
838 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
839 UPDATE audit_temp_table SET a=a+2;
840 SELECT * FROM audit_temp_table ORDER BY a;
841 a
842 3
843 4
844 SELECT @@null_audit_event_order_check;
845 @@null_audit_event_order_check
846 EVENT-ORDER-OK
847 #################################
848 ## TABLE_ACCESS - UPDATE WHERE ##
849 #################################
850 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
851 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
852 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
853 'MYSQL_AUDIT_GENERAL_LOG;;;'
854 'MYSQL_AUDIT_QUERY_START;sql_command_id="4";;'
855 'MYSQL_AUDIT_TABLE_ACCESS_UPDATE;db="super_test" table="test_table";ABORT_RET';
856 UPDATE test_table SET a=a+10 WHERE a>10;
857 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_TABLE_ACCESS_UPDATE';1).
858 SELECT * FROM test_table ORDER BY a;
859 a
860 9
861 10
862 11
863 12
864 SELECT @@null_audit_event_order_check;
865 @@null_audit_event_order_check
866 EVENT-ORDER-ABORT
867 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
868 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
869 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
870 'MYSQL_AUDIT_GENERAL_LOG;;;'
871 'MYSQL_AUDIT_QUERY_START;sql_command_id="4";;'
872 'MYSQL_AUDIT_TABLE_ACCESS_UPDATE;db="super_test" table="test_table";;'
873 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="4";;'
874 'MYSQL_AUDIT_GENERAL_RESULT;;;'
875 'MYSQL_AUDIT_GENERAL_STATUS;;;'
876 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
877 UPDATE test_table SET a=a+10 WHERE a>10;
878 SELECT * FROM test_table ORDER BY a;
879 a
880 9
881 10
882 21
883 22
884 SELECT @@null_audit_event_order_check;
885 @@null_audit_event_order_check
886 EVENT-ORDER-OK
887 LOCK TABLES test_table WRITE;
888 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
889 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
890 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
891 'MYSQL_AUDIT_GENERAL_LOG;;;'
892 'MYSQL_AUDIT_QUERY_START;sql_command_id="4";;'
893 'MYSQL_AUDIT_TABLE_ACCESS_UPDATE;db="super_test" table="test_table";;'
894 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="4";;'
895 'MYSQL_AUDIT_GENERAL_RESULT;;;'
896 'MYSQL_AUDIT_GENERAL_STATUS;;;'
897 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
898 UPDATE test_table SET a=a+10 WHERE a>10;
899 SELECT * FROM test_table ORDER BY a;
900 a
901 9
902 10
903 31
904 32
905 SELECT @@null_audit_event_order_check;
906 @@null_audit_event_order_check
907 EVENT-ORDER-OK
908 UNLOCK TABLES;
909 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
910 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
911 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
912 'MYSQL_AUDIT_GENERAL_LOG;;;'
913 'MYSQL_AUDIT_QUERY_START;sql_command_id="4";;'
914 'MYSQL_AUDIT_TABLE_ACCESS_UPDATE;db="super_test" table="test_table";;'
915 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="test_table_2";;'
916 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="4";;'
917 'MYSQL_AUDIT_GENERAL_RESULT;;;'
918 'MYSQL_AUDIT_GENERAL_STATUS;;;'
919 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
920 update test_table set test_table.a=test_table.a+10 where test_table.a in (select test_table_2.a + 10 from test_table_2);
921 SELECT @@null_audit_event_order_check;
922 @@null_audit_event_order_check
923 EVENT-ORDER-OK
924 #################################
925 ## TABLE_ACCESS - DELETE WHERE ##
926 #################################
927 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
928 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
929 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
930 'MYSQL_AUDIT_GENERAL_LOG;;;'
931 'MYSQL_AUDIT_QUERY_START;sql_command_id="7";;'
932 'MYSQL_AUDIT_TABLE_ACCESS_DELETE;db="super_test" table="test_table";ABORT_RET';
933 DELETE FROM test_table WHERE a>7;
934 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_TABLE_ACCESS_DELETE';1).
935 SELECT * FROM test_table ORDER BY a;
936 a
937 9
938 10
939 31
940 32
941 SELECT @@null_audit_event_order_check;
942 @@null_audit_event_order_check
943 EVENT-ORDER-ABORT
944 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
945 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
946 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
947 'MYSQL_AUDIT_GENERAL_LOG;;;'
948 'MYSQL_AUDIT_QUERY_START;sql_command_id="7";;'
949 'MYSQL_AUDIT_TABLE_ACCESS_DELETE;db="super_test" table="test_table";;'
950 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="7";;'
951 'MYSQL_AUDIT_GENERAL_RESULT;;;'
952 'MYSQL_AUDIT_GENERAL_STATUS;;;'
953 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
954 DELETE FROM test_table WHERE a>31;
955 SELECT * FROM test_table ORDER BY a;
956 a
957 9
958 10
959 31
960 SELECT @@null_audit_event_order_check;
961 @@null_audit_event_order_check
962 EVENT-ORDER-OK
963 LOCK TABLES test_table WRITE;
964 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
965 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
966 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
967 'MYSQL_AUDIT_GENERAL_LOG;;;'
968 'MYSQL_AUDIT_QUERY_START;sql_command_id="7";;'
969 'MYSQL_AUDIT_TABLE_ACCESS_DELETE;db="super_test" table="test_table";;'
970 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="7";;'
971 'MYSQL_AUDIT_GENERAL_RESULT;;;'
972 'MYSQL_AUDIT_GENERAL_STATUS;;;'
973 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
974 DELETE FROM test_table WHERE a>30;
975 SELECT * FROM test_table ORDER BY a;
976 a
977 9
978 10
979 SELECT @@null_audit_event_order_check;
980 @@null_audit_event_order_check
981 EVENT-ORDER-OK
982 UNLOCK TABLES;
983 ###########################
984 ## TABLE_ACCESS - DELETE ##
985 ###########################
986 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
987 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
988 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
989 'MYSQL_AUDIT_GENERAL_LOG;;;'
990 'MYSQL_AUDIT_QUERY_START;sql_command_id="7";;'
991 'MYSQL_AUDIT_TABLE_ACCESS_DELETE;db="super_test" table="test_table";ABORT_RET';
992 DELETE FROM test_table;
993 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_TABLE_ACCESS_DELETE';1).
994 SELECT * FROM test_table ORDER BY a;
995 a
996 9
997 10
998 SELECT @@null_audit_event_order_check;
999 @@null_audit_event_order_check
1000 EVENT-ORDER-ABORT
1001 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
1002 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1003 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1004 'MYSQL_AUDIT_GENERAL_LOG;;;'
1005 'MYSQL_AUDIT_QUERY_START;sql_command_id="7";;'
1006 'MYSQL_AUDIT_TABLE_ACCESS_DELETE;db="super_test" table="test_table";;'
1007 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="7";;'
1008 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1009 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1010 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
1011 DELETE FROM test_table;
1012 SELECT * FROM test_table ORDER BY a;
1013 a
1014 SELECT @@null_audit_event_order_check;
1015 @@null_audit_event_order_check
1016 EVENT-ORDER-OK
1017 INSERT INTO test_table VALUES (1),(2);
1018 LOCK TABLES test_table WRITE;
1019 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
1020 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1021 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1022 'MYSQL_AUDIT_GENERAL_LOG;;;'
1023 'MYSQL_AUDIT_QUERY_START;sql_command_id="7";;'
1024 'MYSQL_AUDIT_TABLE_ACCESS_DELETE;db="super_test" table="test_table";;'
1025 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="7";;'
1026 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1027 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1028 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
1029 DELETE FROM test_table;
1030 SELECT * FROM test_table ORDER BY a;
1031 a
1032 SELECT @@null_audit_event_order_check;
1033 @@null_audit_event_order_check
1034 EVENT-ORDER-OK
1035 UNLOCK TABLES;
1036 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
1037 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1038 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1039 'MYSQL_AUDIT_GENERAL_LOG;;;'
1040 'MYSQL_AUDIT_QUERY_START;sql_command_id="7";;'
1041 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="7";;'
1042 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1043 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1044 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
1045 DELETE FROM audit_temp_table;
1046 SELECT * FROM audit_temp_table ORDER BY a;
1047 a
1048 SELECT @@null_audit_event_order_check;
1049 @@null_audit_event_order_check
1050 EVENT-ORDER-OK
1051 DROP TABLE audit_temp_table;
1052 ############################
1053 ## TABLE_ACCESS - REPLACE ##
1054 ############################
1055 CREATE TABLE test_table_3 (id INT NOT NULL, data VARCHAR(10) NOT NULL, PRIMARY KEY (id));
1056 INSERT INTO test_table_3 VALUES (1, 'Old'), (2, 'Old');
1057 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
1058 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1059 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1060 'MYSQL_AUDIT_GENERAL_LOG;;;'
1061 'MYSQL_AUDIT_QUERY_START;sql_command_id="40";;'
1062 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table_3";ABORT_RET';
1063 REPLACE INTO test_table_3 VALUES (1, 'New');
1064 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_TABLE_ACCESS_INSERT';1).
1065 SELECT * FROM test_table_3 ORDER BY id;
1066 id data
1067 1 Old
1068 2 Old
1069 SELECT @@null_audit_event_order_check;
1070 @@null_audit_event_order_check
1071 EVENT-ORDER-ABORT
1072 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
1073 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1074 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1075 'MYSQL_AUDIT_GENERAL_LOG;;;'
1076 'MYSQL_AUDIT_QUERY_START;sql_command_id="40";;'
1077 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table_3";;'
1078 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="40";;'
1079 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1080 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1081 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
1082 REPLACE INTO test_table_3 VALUES (1, 'New');
1083 SELECT * FROM test_table_3 ORDER BY id;
1084 id data
1085 1 New
1086 2 Old
1087 SELECT @@null_audit_event_order_check;
1088 @@null_audit_event_order_check
1089 EVENT-ORDER-OK
1090 LOCK TABLES test_table_3 WRITE;
1091 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
1092 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1093 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1094 'MYSQL_AUDIT_GENERAL_LOG;;;'
1095 'MYSQL_AUDIT_QUERY_START;sql_command_id="40";;'
1096 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table_3";;'
1097 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="40";;'
1098 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1099 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1100 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
1101 REPLACE INTO test_table_3 VALUES (2, 'New');
1102 SELECT * FROM test_table_3 ORDER BY id;
1103 id data
1104 1 New
1105 2 New
1106 SELECT @@null_audit_event_order_check;
1107 @@null_audit_event_order_check
1108 EVENT-ORDER-OK
1109 UNLOCK TABLE;
1110 ###################################
1111 ## TABLE_ACCESS - REPLACE SELECT ##
1112 ###################################
1113 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
1114 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1115 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1116 'MYSQL_AUDIT_GENERAL_LOG;;;'
1117 'MYSQL_AUDIT_QUERY_START;sql_command_id="41";;'
1118 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table_3";ABORT_RET';
1119 REPLACE INTO test_table_3 SELECT id, 'Sel' FROM test_table_3;
1120 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_TABLE_ACCESS_INSERT';1).
1121 SELECT * FROM test_table_3 ORDER BY id;
1122 id data
1123 1 New
1124 2 New
1125 SELECT @@null_audit_event_order_check;
1126 @@null_audit_event_order_check
1127 EVENT-ORDER-ABORT
1128 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
1129 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1130 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1131 'MYSQL_AUDIT_GENERAL_LOG;;;'
1132 'MYSQL_AUDIT_QUERY_START;sql_command_id="41";;'
1133 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table_3";;'
1134 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="test_table_3";;'
1135 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="41";;'
1136 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1137 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1138 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
1139 REPLACE INTO test_table_3 SELECT id, 'Sel' FROM test_table_3;
1140 SELECT * FROM test_table_3 ORDER BY id;
1141 id data
1142 1 Sel
1143 2 Sel
1144 SELECT @@null_audit_event_order_check;
1145 @@null_audit_event_order_check
1146 EVENT-ORDER-OK
1147 LOCK TABLES test_table_3 WRITE, test_table_3 AS test_table_3_l READ;
1148 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
1149 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1150 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1151 'MYSQL_AUDIT_GENERAL_LOG;;;'
1152 'MYSQL_AUDIT_QUERY_START;sql_command_id="41";;'
1153 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table_3";;'
1154 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="test_table_3";;'
1155 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="41";;'
1156 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1157 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1158 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
1159 REPLACE INTO test_table_3 SELECT id, 'Sec' FROM test_table_3 AS test_table_3_l;
1160 SELECT * FROM test_table_3 ORDER BY id;
1161 id data
1162 1 Sec
1163 2 Sec
1164 SELECT @@null_audit_event_order_check;
1165 @@null_audit_event_order_check
1166 EVENT-ORDER-OK
1167 UNLOCK TABLES;
1168 #############################
1169 ## TABLE_ACCESS - TRUNCATE ##
1170 #############################
1171 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
1172 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1173 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1174 'MYSQL_AUDIT_GENERAL_LOG;;;'
1175 'MYSQL_AUDIT_QUERY_START;sql_command_id="8";;'
1176 'MYSQL_AUDIT_TABLE_ACCESS_DELETE;db="super_test" table="test_table_3";ABORT_RET';
1177 TRUNCATE test_table_3;
1178 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_TABLE_ACCESS_DELETE';1).
1179 SELECT * FROM test_table_3 ORDER BY id;
1180 id data
1181 1 Sec
1182 2 Sec
1183 SELECT @@null_audit_event_order_check;
1184 @@null_audit_event_order_check
1185 EVENT-ORDER-ABORT
1186 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
1187 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1188 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1189 'MYSQL_AUDIT_GENERAL_LOG;;;'
1190 'MYSQL_AUDIT_QUERY_START;sql_command_id="8";;'
1191 'MYSQL_AUDIT_TABLE_ACCESS_DELETE;db="super_test" table="test_table_3";;'
1192 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="8";;'
1193 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1194 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1195 'MYSQL_AUDIT_COMMAND_END;command_id="3";';
1196 TRUNCATE test_table_3;
1197 SELECT * FROM test_table_3 ORDER BY id;
1198 id data
1199 SELECT @@null_audit_event_order_check;
1200 @@null_audit_event_order_check
1201 EVENT-ORDER-OK
1202 INSERT INTO test_table_3 VALUES (1, 'AAA'),(2, 'BBB');
1203 LOCK TABLES test_table_3 WRITE;
1204 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
1205 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1206 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1207 'MYSQL_AUDIT_GENERAL_LOG;;;'
1208 'MYSQL_AUDIT_QUERY_START;sql_command_id="8";;'
1209 'MYSQL_AUDIT_TABLE_ACCESS_DELETE;db="super_test" table="test_table_3";;'
1210 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="8";;'
1211 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1212 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1213 'MYSQL_AUDIT_COMMAND_END;command_id="3";';
1214 TRUNCATE test_table_3;
1215 SELECT * FROM test_table_3 ORDER BY id;
1216 id data
1217 SELECT @@null_audit_event_order_check;
1218 @@null_audit_event_order_check
1219 EVENT-ORDER-OK
1220 UNLOCK TABLES;
1221 #################################################
1222 ## TABLE_ACCESS - TRUNCATE (HTON_CAN_RECREATE) ##
1223 #################################################
1224 CREATE TABLE test_table_4 (a INT) ENGINE=MyISAM;
1225 INSERT INTO test_table_4 VALUES(1),(2),(3);
1226 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
1227 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1228 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1229 'MYSQL_AUDIT_GENERAL_LOG;;;'
1230 'MYSQL_AUDIT_QUERY_START;sql_command_id="8";;'
1231 'MYSQL_AUDIT_TABLE_ACCESS_DELETE;db="super_test" table="test_table_4";;'
1232 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="8";;'
1233 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1234 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1235 'MYSQL_AUDIT_COMMAND_END;command_id="3";';
1236 TRUNCATE test_table_4;
1237 SELECT @@null_audit_event_order_check;
1238 @@null_audit_event_order_check
1239 EVENT-ORDER-OK
1240 DROP TABLE test_table_4;
1241 ############################
1242 ## TABLE_ACCESS - TRIGGER ##
1243 ############################
1244 CREATE PROCEDURE sp_test_table_insert(val INT)
1245 INSERT INTO test_table VALUES (@val);
1246 CREATE TRIGGER ins_sum BEFORE INSERT ON test_table_2 FOR EACH ROW CALL sp_test_table_insert(@NEW.a + 100);
1247 ALTER TABLE test_table_3 DROP COLUMN data;
1248 INSERT INTO test_table_3 VALUES (1),(2);
1249 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
1250 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1251 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1252 'MYSQL_AUDIT_GENERAL_LOG;;;'
1253 'MYSQL_AUDIT_QUERY_START;sql_command_id="6";;'
1254 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table_2";;'
1255 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="test_table_3";;'
1256 'MYSQL_AUDIT_GENERAL_LOG;;;'
1257 'MYSQL_AUDIT_QUERY_NESTED_START;sql_command_id="91";;'
1258 'MYSQL_AUDIT_STORED_PROGRAM_EXECUTE;;;'
1259 'MYSQL_AUDIT_QUERY_NESTED_START;sql_command_id="5";;'
1260 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table";;'
1261 'MYSQL_AUDIT_GENERAL_LOG;;;'
1262 'MYSQL_AUDIT_QUERY_NESTED_START;sql_command_id="91";;'
1263 'MYSQL_AUDIT_STORED_PROGRAM_EXECUTE;;;'
1264 'MYSQL_AUDIT_QUERY_NESTED_START;sql_command_id="5";;'
1265 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table";;'
1266 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="6";;'
1267 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1268 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1269 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";;';
1270 INSERT INTO test_table_2 SELECT * FROM test_table_3;
1271 SELECT @@null_audit_event_order_check;
1272 @@null_audit_event_order_check
1273 EVENT-ORDER-OK
1274 #################
1275 ## OUTER TABLE ##
1276 #################
1277 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
1278 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1279 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1280 'MYSQL_AUDIT_GENERAL_LOG;;;'
1281 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
1282 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="test_table_3";;'
1283 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="0";;'
1284 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1285 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1286 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
1287 SELECT * FROM (SELECT id FROM test_table_3) AS a;
1288 id
1289 1
1290 2
1291 SELECT @@null_audit_event_order_check;
1292 @@null_audit_event_order_check
1293 EVENT-ORDER-OK
1294 ##########
1295 ## VIEW ##
1296 ##########
1297 TRUNCATE TABLE test_table;
1298 INSERT INTO test_table VALUES (1), (2), (3);
1299 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
1300 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1301 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1302 'MYSQL_AUDIT_GENERAL_LOG;;;'
1303 'MYSQL_AUDIT_QUERY_START;sql_command_id="102";;'
1304 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="102";;'
1305 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1306 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1307 'MYSQL_AUDIT_COMMAND_END;command_id="3";';
1308 CREATE VIEW audit_view AS SELECT * FROM test_table;
1309 SELECT @@null_audit_event_order_check;
1310 @@null_audit_event_order_check
1311 EVENT-ORDER-OK
1312 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
1313 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1314 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1315 'MYSQL_AUDIT_GENERAL_LOG;;;'
1316 'MYSQL_AUDIT_QUERY_START;sql_command_id="5";;'
1317 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table";;'
1318 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="5";;'
1319 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1320 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1321 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
1322 INSERT INTO audit_view VALUES (4), (5), (6);
1323 SELECT @@null_audit_event_order_check;
1324 @@null_audit_event_order_check
1325 EVENT-ORDER-OK
1326 SELECT * FROM test_table;
1327 a
1328 1
1329 2
1330 3
1331 4
1332 5
1333 6
1334 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
1335 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1336 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1337 'MYSQL_AUDIT_GENERAL_LOG;;;'
1338 'MYSQL_AUDIT_QUERY_START;sql_command_id="4";;'
1339 'MYSQL_AUDIT_TABLE_ACCESS_UPDATE;db="super_test" table="test_table";;'
1340 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="4";;'
1341 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1342 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1343 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
1344 UPDATE audit_view SET a = a + 7;
1345 SELECT @@null_audit_event_order_check;
1346 @@null_audit_event_order_check
1347 EVENT-ORDER-OK
1348 SELECT * FROM test_table;
1349 a
1350 8
1351 9
1352 10
1353 11
1354 12
1355 13
1356 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
1357 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1358 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1359 'MYSQL_AUDIT_GENERAL_LOG;;;'
1360 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
1361 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="test_table";;'
1362 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="0";;'
1363 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1364 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1365 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
1366 SELECT * FROM audit_view;
1367 a
1368 8
1369 9
1370 10
1371 11
1372 12
1373 13
1374 SELECT @@null_audit_event_order_check;
1375 @@null_audit_event_order_check
1376 EVENT-ORDER-OK
1377 DROP VIEW audit_view;
1378 ###################
1379 ## DERIVED TABLE ##
1380 ###################
1381 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
1382 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1383 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1384 'MYSQL_AUDIT_GENERAL_LOG;;;'
1385 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
1386 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="test_table";;'
1387 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="0";;'
1388 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1389 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1390 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
1391 SELECT COUNT(*) FROM (SELECT a FROM test_table GROUP BY a) AS a1;
1392 COUNT(*)
1393 6
1394 SELECT @@null_audit_event_order_check;
1395 @@null_audit_event_order_check
1396 EVENT-ORDER-OK
1397 #########################
1398 ## PREPARED STATEMENTS ##
1399 #########################
1400 DELETE FROM test_table;
1401 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
1402 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1403 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1404 'MYSQL_AUDIT_GENERAL_LOG;;;'
1405 'MYSQL_AUDIT_QUERY_START;sql_command_id="99";;'
1406 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1407 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1408 'MYSQL_AUDIT_GENERAL_LOG;;;'
1409 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="99";;'
1410 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1411 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1412 'MYSQL_AUDIT_COMMAND_END;command_id="3";';
1413 PREPARE stmt FROM "INSERT INTO test_table VALUES (1),(2)";
1414 SELECT * FROM test_table ORDER BY a;
1415 a
1416 SELECT @@null_audit_event_order_check;
1417 @@null_audit_event_order_check
1418 EVENT-ORDER-OK
1419 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
1420 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1421 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1422 'MYSQL_AUDIT_GENERAL_LOG;;;'
1423 'MYSQL_AUDIT_QUERY_START;sql_command_id="100";;'
1424 'MYSQL_AUDIT_GENERAL_LOG;;;'
1425 'MYSQL_AUDIT_QUERY_START;sql_command_id="5";;'
1426 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="test_table";;'
1427 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="5";;'
1428 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="100";;'
1429 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1430 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1431 'MYSQL_AUDIT_COMMAND_END;command_id="3";';
1432 EXECUTE stmt;
1433 SELECT * FROM test_table ORDER BY a;
1434 a
1435 1
1436 2
1437 SELECT @@null_audit_event_order_check;
1438 @@null_audit_event_order_check
1439 EVENT-ORDER-OK
1440 ########################################################
1441 ## PREPARED STATEMENTS - DERIVED TABLE ##
1442 ## Bug#23699991 EXECUTE STATEMENT CAUSES SERVER CRASH ##
1443 ## WHEN AUDIT_LOG IS INSTALLED ON SERVER ##
1444 ########################################################
1445 PREPARE stmt FROM 'SELECT COUNT(*) FROM (SELECT a FROM test_table GROUP BY a) AS a1';
1446 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
1447 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1448 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1449 'MYSQL_AUDIT_GENERAL_LOG;;;'
1450 'MYSQL_AUDIT_QUERY_START;sql_command_id="100";;'
1451 'MYSQL_AUDIT_GENERAL_LOG;;;'
1452 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
1453 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="test_table";;'
1454 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="0";;'
1455 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="100";;'
1456 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1457 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1458 'MYSQL_AUDIT_COMMAND_END;command_id="3";';
1459 EXECUTE stmt;
1460 COUNT(*)
1461 2
1462 SELECT @@null_audit_event_order_check;
1463 @@null_audit_event_order_check
1464 EVENT-ORDER-OK
1465 DROP PREPARE stmt;
1466 DROP TABLE test_table_3;
1467 DROP TABLE test_table_2;
1468 DROP TABLE test_table;
1469 ################
1470 ## PARTITIONS ##
1471 ################
1472 CREATE TABLE table_part (id INT NOT NULL PRIMARY KEY, name VARCHAR(16) NOT NULL, year YEAR, INDEX name (name(8)))
1473 PARTITION BY HASH(id) PARTITIONS 2;
1474 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
1475 DROP TABLE table_part;
1476 SET @@null_audit_event_order_check_exact = 1;
1477 ###########
1478 ## MERGE ##
1479 ###########
1480 CREATE TABLE merge_table_1 (message CHAR(20)) ENGINE=MyISAM;
1481 CREATE TABLE merge_table_2 (message CHAR(20)) ENGINE=MyISAM;
1482 INSERT INTO merge_table_1 (message) VALUES ('AAA'),('CCC'),('EEE');
1483 INSERT INTO merge_table_2 (message) VALUES ('BBB'),('DDD'),('FFF');
1484 CREATE TABLE merge_table (message CHAR(20)) ENGINE=MERGE UNION=(merge_table_1,merge_table_2) INSERT_METHOD=LAST;
1485 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
1486 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
1487 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1488 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1489 'MYSQL_AUDIT_GENERAL_LOG;;;'
1490 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
1491 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="merge_table";ABORT_RET';
1492 SELECT * FROM merge_table;
1493 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_TABLE_ACCESS_READ';1).
1494 SELECT @@null_audit_event_order_check;
1495 @@null_audit_event_order_check
1496 EVENT-ORDER-ABORT
1497 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
1498 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1499 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1500 'MYSQL_AUDIT_GENERAL_LOG;;;'
1501 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
1502 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="merge_table";;'
1503 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="merge_table_1";;'
1504 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="merge_table_2";ABORT_RET';
1505 SELECT * FROM merge_table;
1506 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_TABLE_ACCESS_READ';1).
1507 SELECT @@null_audit_event_order_check;
1508 @@null_audit_event_order_check
1509 EVENT-ORDER-ABORT
1510 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
1511 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1512 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1513 'MYSQL_AUDIT_GENERAL_LOG;;;'
1514 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
1515 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="merge_table";;'
1516 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="merge_table_1";;'
1517 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="merge_table_2";;'
1518 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="0";;'
1519 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1520 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1521 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
1522 SELECT * FROM merge_table ORDER BY message;
1523 message
1524 AAA
1525 BBB
1526 CCC
1527 DDD
1528 EEE
1529 FFF
1530 SELECT @@null_audit_event_order_check;
1531 @@null_audit_event_order_check
1532 EVENT-ORDER-OK
1533 DROP TABLE merge_table;
1534 DROP TABLE merge_table_2;
1535 DROP TABLE merge_table_1;
1536 #############
1537 ## HANDLER ##
1538 #############
1539 CREATE TABLE handler_table (message CHAR(20)) ENGINE=MyISAM;
1540 INSERT INTO handler_table VALUES ('AAA'), ('BBB'), ('CCC'), ('DDD');
1541 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
1542 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1543 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1544 'MYSQL_AUDIT_GENERAL_LOG;;;'
1545 'MYSQL_AUDIT_QUERY_START;sql_command_id="70";;'
1546 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="70";;'
1547 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1548 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1549 'MYSQL_AUDIT_COMMAND_END;command_id="3";';
1550 HANDLER handler_table OPEN;
1551 SELECT @@null_audit_event_order_check;
1552 @@null_audit_event_order_check
1553 EVENT-ORDER-OK
1554 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
1555 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1556 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1557 'MYSQL_AUDIT_GENERAL_LOG;;;'
1558 'MYSQL_AUDIT_QUERY_START;sql_command_id="72";;'
1559 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="handler_table";;'
1560 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="72";;'
1561 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1562 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1563 'MYSQL_AUDIT_COMMAND_END;command_id="3";';
1564 HANDLER handler_table READ FIRST;
1565 message
1566 AAA
1567 SELECT @@null_audit_event_order_check;
1568 @@null_audit_event_order_check
1569 EVENT-ORDER-OK
1570 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
1571 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1572 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1573 'MYSQL_AUDIT_GENERAL_LOG;;;'
1574 'MYSQL_AUDIT_QUERY_START;sql_command_id="72";;'
1575 'MYSQL_AUDIT_TABLE_ACCESS_READ;db="super_test" table="handler_table";;'
1576 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="72";;'
1577 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1578 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1579 'MYSQL_AUDIT_COMMAND_END;command_id="3";';
1580 HANDLER handler_table READ NEXT;
1581 message
1582 BBB
1583 SELECT @@null_audit_event_order_check;
1584 @@null_audit_event_order_check
1585 EVENT-ORDER-OK
1586 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
1587 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1588 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1589 'MYSQL_AUDIT_GENERAL_LOG;;;'
1590 'MYSQL_AUDIT_QUERY_START;sql_command_id="71";;'
1591 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="71";;'
1592 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1593 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1594 'MYSQL_AUDIT_COMMAND_END;command_id="3";';
1595 HANDLER handler_table CLOSE;
1596 SELECT @@null_audit_event_order_check;
1597 @@null_audit_event_order_check
1598 EVENT-ORDER-OK
1599 HANDLER handler_table OPEN AS handler_table_alias;
1600 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
1601 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1602 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1603 'MYSQL_AUDIT_GENERAL_LOG;;;'
1604 'MYSQL_AUDIT_QUERY_START;sql_command_id="72";;'
1605 'MYSQL_AUDIT_GENERAL_ERROR;;;'
1606 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="72";;'
1607 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1608 'MYSQL_AUDIT_COMMAND_END;command_id="3";';
1609 HANDLER handler_table_alias READ message NEXT;
1610 ERROR 42000: Key 'message' doesn't exist in table 'handler_table_alias'
1611 SELECT @@null_audit_event_order_check;
1612 @@null_audit_event_order_check
1613 EVENT-ORDER-OK
1614 DROP TABLE handler_table;
1615 ###############
1616 ## LOAD DATA ##
1617 ###############
1618 create table audit_load_data (a varchar(20), b varchar(20));
1619 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
1620 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1621 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1622 'MYSQL_AUDIT_GENERAL_LOG;;;'
1623 'MYSQL_AUDIT_QUERY_START;sql_command_id="30";;'
1624 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="audit_load_data";ABORT_RET';
1625 load data infile '../../std_data/loaddata_dq.dat' into table audit_load_data fields terminated by ',' enclosed by '"' escaped by '"' (a,b);
1626 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_TABLE_ACCESS_INSERT';1).
1627 SELECT * FROM audit_load_data ORDER BY a;
1628 a b
1629 SELECT @@null_audit_event_order_check;
1630 @@null_audit_event_order_check
1631 EVENT-ORDER-ABORT
1632 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
1633 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1634 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1635 'MYSQL_AUDIT_GENERAL_LOG;;;'
1636 'MYSQL_AUDIT_QUERY_START;sql_command_id="30";;'
1637 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="audit_load_data";;'
1638 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="30";;'
1639 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1640 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1641 'MYSQL_AUDIT_COMMAND_END;command_id="3";';
1642 load data infile '../../std_data/loaddata_dq.dat' into table audit_load_data fields terminated by ',' enclosed by '"' escaped by '"' (a,b);
1643 SELECT * FROM audit_load_data ORDER BY a;
1644 a b
1645 a"b cd"ef
1646 a"b c"d"e
1647 field1 field2
1648 SELECT @@null_audit_event_order_check;
1649 @@null_audit_event_order_check
1650 EVENT-ORDER-OK
1651 DROP TABLE audit_load_data;
1652 ##############
1653 ## LOAD XML ##
1654 ##############
1655 create table audit_xml_data (a int, b varchar(64));
1656 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
1657 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1658 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1659 'MYSQL_AUDIT_GENERAL_LOG;;;'
1660 'MYSQL_AUDIT_QUERY_START;sql_command_id="30";;'
1661 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="audit_xml_data";ABORT_RET';
1662 load xml infile '../../std_data/loadxml.dat' into table audit_xml_data rows identified by '<row>';
1663 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_TABLE_ACCESS_INSERT';1).
1664 SELECT @@null_audit_event_order_check;
1665 @@null_audit_event_order_check
1666 EVENT-ORDER-ABORT
1667 select * from audit_xml_data order by a;
1668 a b
1669 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
1670 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1671 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1672 'MYSQL_AUDIT_GENERAL_LOG;;;'
1673 'MYSQL_AUDIT_QUERY_START;sql_command_id="30";;'
1674 'MYSQL_AUDIT_TABLE_ACCESS_INSERT;db="super_test" table="audit_xml_data";;'
1675 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="30";;'
1676 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1677 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1678 'MYSQL_AUDIT_COMMAND_END;command_id="3";';
1679 load xml infile '../../std_data/loadxml.dat' into table audit_xml_data rows identified by '<row>';
1680 SELECT @@null_audit_event_order_check;
1681 @@null_audit_event_order_check
1682 EVENT-ORDER-OK
1683 select * from audit_xml_data order by a;
1684 a b
1685 1 b1
1686 2 b2
1687 3 b3
1688 11 b11
1689 111 b111
1690 112 b112 & < > " ' &unknown; -- check entities
1691 212 b212
1692 213 b213
1693 214 b214
1694 215 b215
1695 216 &bb b;
1696 DROP TABLE audit_xml_data;
1697 USE mysql;
1698 DROP DATABASE super_test;
1699 DROP USER user1@localhost;
1700 ########################
1701 ## INFORMATION SCHEMA ##
1702 ########################
1703 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_id>";;'
1704 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1705 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1706 'MYSQL_AUDIT_GENERAL_LOG;;;'
1707 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";;'
1708 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="0";;'
1709 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1710 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1711 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";';
1712 SELECT * FROM INFORMATION_SCHEMA.CHARACTER_SETS;
1713 SELECT @@null_audit_event_order_check;
1714 @@null_audit_event_order_check
1715 EVENT-ORDER-OK
1716 ########################
1717 ## PERFORMANCE SCHEMA ##
1718 ########################
1719 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
1720 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1721 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1722 'MYSQL_AUDIT_GENERAL_LOG;;;'
1723 'MYSQL_AUDIT_QUERY_START;sql_command_id="16";;'
1724 'MYSQL_AUDIT_QUERY_STATUS_END;sql_command_id="16";;'
1725 'MYSQL_AUDIT_GENERAL_RESULT;;;'
1726 'MYSQL_AUDIT_GENERAL_STATUS;;;'
1727 'MYSQL_AUDIT_COMMAND_END;command_id="3";';
1728 SHOW STATUS;
1729 SELECT @@null_audit_event_order_check;
1730 @@null_audit_event_order_check
1731 EVENT-ORDER-OK
1732 ########################
1733 ## CONNECTION - CLEAN ##
1734 ########################
1735 CREATE USER user1;
1736 CREATE USER user2;
1737 SELECT USER(), CURRENT_USER();
1738 USER() CURRENT_USER()
1739 user1@localhost user1@%
1740 # Try to change user for a given connection (user and database specified)
1741 ERROR 42000: Access denied for user 'user2'@'%' to database 'mysql'
1742 SELECT USER(), CURRENT_USER();
1743 USER() CURRENT_USER()
1744 user1@localhost user1@%
1745 # Allow 'user2' to use 'mysql' database.
1746 GRANT ALL ON mysql.* TO user2;
1747 # Change user with 'mysql' as initial database
1748 SELECT USER(), CURRENT_USER();
1749 USER() CURRENT_USER()
1750 user2@localhost user2@%
1751 # Bring back user1 (no database specified)
1752 SELECT USER(), CURRENT_USER();
1753 USER() CURRENT_USER()
1754 user1@localhost user1@%
1755 ## Reset connection ##
1756 SELECT USER(), CURRENT_USER();
1757 USER() CURRENT_USER()
1758 user1@localhost user1@%
1759 DROP USER user1;
1760 DROP USER user2;
1761 ###############################
1762 ## CONNECTION - INSTRUMENTED ##
1763 ###############################
1764 CREATE USER user1;
1765 CREATE USER user2;
1766 SET @@GLOBAL.null_audit_event_order_check = 'MYSQL_AUDIT_CONNECTION_PRE_AUTHENTICATE;;;'
1767 'MYSQL_AUDIT_GENERAL_LOG;;;'
1768 'MYSQL_AUDIT_CONNECTION_CONNECT;;ABORT_RET';
1769 connect(localhost,user1,,test,MASTER_PORT,MASTER_SOCKET);
1770 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_CONNECTION_CONNECT';1).
1771 SET @@GLOBAL.null_audit_event_order_check = NULL,
1772 @@GLOBAL.null_audit_event_order_check_exact = 1;
1773 #--COM_CHANGE_USER
1774 SET @@GLOBAL.null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="17";ABORT_RET';
1775 # Try to change user for a given connection (user and database specified)
1776 ERROR 42000: Access denied for user 'user2'@'%' to database 'mysql'
1777 # Allow 'user2' to use 'mysql' database.
1778 GRANT ALL ON mysql.* TO user2;
1779 # Change user with 'mysql' as initial database
1780 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_COMMAND_START';1).
1781 SELECT USER(), CURRENT_USER();
1782 USER() CURRENT_USER()
1783 user1@localhost user1@%
1784 # Reset connection
1785 SET @@GLOBAL.null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="31";ABORT_RET';
1786 SELECT USER(), CURRENT_USER();
1787 USER() CURRENT_USER()
1788 user1@localhost user1@%
1789 ## Should no take any effect. COM_QUIT should be possible.
1790 SET @@GLOBAL.null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="1";ABORT_RET';
1791 SET @@GLOBAL.null_audit_event_order_check = NULL;
1792 DROP USER user1;
1793 DROP USER user2;
1794 ## CONNECTION - INSTRUMENTED - END ##
1795 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
1796 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1797 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1798 'MYSQL_AUDIT_GENERAL_LOG;;;'
1799 'MYSQL_AUDIT_QUERY_START;sql_command_id="35";ABORT_RET';
1800 USE mysql;
1801 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_QUERY_START';1).
1802 SELECT @@null_audit_event_order_check;
1803 @@null_audit_event_order_check
1804 EVENT-ORDER-ABORT
1805 USE mysql;
1806 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
1807 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
1808 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1809 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1810 'MYSQL_AUDIT_GENERAL_LOG;;;'
1811 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";ABORT_RET';
1812 SELECT 1;
1813 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_QUERY_START';1).
1814 SELECT @@null_audit_event_order_check;
1815 @@null_audit_event_order_check
1816 EVENT-ORDER-ABORT
1817 SELECT 1;
1818 1
1819 1
1820 ##########################
1821 ## CUSTOM ERROR MESSAGE ##
1822 ##########################
1823 SET @@null_audit_abort_message = "Custom error text.";
1824 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
1825 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
1826 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1827 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1828 'MYSQL_AUDIT_GENERAL_LOG;;;'
1829 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";ABORT_RET';
1830 SELECT 1;
1831 ERROR HY000: Custom error text.
1832 SELECT @@null_audit_event_order_check;
1833 @@null_audit_event_order_check
1834 EVENT-ORDER-ABORT
1835 ## CUSTOM ERROR MESSAGE - END ##
1836 #########################
1837 ## CUSTOM ERROR RESULT ##
1838 #########################
1839 SET @@null_audit_abort_value = 123;
1840 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
1841 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
1842 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1843 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
1844 'MYSQL_AUDIT_GENERAL_LOG;;;'
1845 'MYSQL_AUDIT_QUERY_START;sql_command_id="0";ABORT_RET';
1846 SELECT 1;
1847 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_QUERY_START';123).
1848 SELECT @@null_audit_event_order_check;
1849 @@null_audit_event_order_check
1850 EVENT-ORDER-ABORT
1851 ## CUSTOM ERROR RESULT - END ##
1852 ###########
1853 ## PARSE ##
1854 ###########
1855 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
1856 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
1857 'MYSQL_AUDIT_PARSE_PREPARSE;;ABORT_RET';
1858 SELECT 1;
1859 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_PARSE_PREPARSE';1).
1860 SELECT @@null_audit_event_order_check;
1861 @@null_audit_event_order_check
1862 EVENT-ORDER-ABORT
1863 SET @@null_audit_event_order_check_exact = <expected_check_exact>;
1864 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="<expected_command_start_id>";;'
1865 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
1866 'MYSQL_AUDIT_PARSE_POSTPARSE;;ABORT_RET';
1867 SELECT 1;
1868 ERROR HY000: Aborted by Audit API ('MYSQL_AUDIT_PARSE_POSTPARSE';1).
1869 SELECT @@null_audit_event_order_check;
1870 @@null_audit_event_order_check
1871 EVENT-ORDER-ABORT
1872 ###############################
1873 ## TEST CHECK - INVALID DATA ##
1874 ###############################
1875 SET @@null_audit_event_order_check_exact = 1;
1876 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";;'
1877 'MYSQL_AUDIT_COMMAND_START;command_id="XXX";';
1878 SELECT 1;
1879 ERROR HY000: Invalid data for 'MYSQL_AUDIT_COMMAND_START' -> command_id="INVALID_ID"
1880 SELECT @@null_audit_event_order_check;
1881 @@null_audit_event_order_check
1882 EVENT-ORDER-INVALID-DATA
1883 #########################
1884 ## COMMAND_END - ABORT ##
1885 #########################
1886 SET @@null_audit_abort_message = "Abort with my_message.";
1887 SET @@null_audit_event_order_check_exact = 1;
1888 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_end_id>";ABORT_RET';
1889 SELECT 1;
1890 1
1891 1
1892 SELECT @@null_audit_event_order_check;
1893 @@null_audit_event_order_check
1894 EVENT-ORDER-ABORT
1895 SET @@null_audit_event_order_check_exact = 1;
1896 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_end_id>";ABORT_RET';
1897 SELECT 1;
1898 1
1899 1
1900 SELECT @@null_audit_event_order_check;
1901 @@null_audit_event_order_check
1902 EVENT-ORDER-ABORT
1903 ## CUSTOM ERROR MESSAGE - END ##
1904 ##################
1905 ## Event record ##
1906 ##################
1907 SET @@null_audit_event_record_def = 'MYSQL_AUDIT_GENERAL_RESULT;MYSQL_AUDIT_COMMAND_END';
1908 SELECT 1;
1909 1
1910 1
1911 SELECT @@null_audit_event_record;
1912 @@null_audit_event_record
1913 MYSQL_AUDIT_GENERAL_RESULT;;
1914 MYSQL_AUDIT_GENERAL_STATUS;;
1915 MYSQL_AUDIT_COMMAND_END;command_id="<expected_command_id>";
1916 SET @@null_audit_event_record = '';
1917 ERROR HY000: Variable 'null_audit_event_record' is a read only variable
1918 UNINSTALL PLUGIN null_audit;
1919 Warnings:
1920 Warning 1620 Plugin is busy and will be uninstalled on shutdown