Debian Codegraph @

mysql-test/suite/audit_null/t/audit_plugin_2.test

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