Debian Codegraph @

mysql-test/suite/plugins/t/server_audit_query_id.test

raw
1 --source include/have_innodb.inc
2 --source include/have_plugin_auth.inc
3 --source include/not_embedded.inc
4
5 if (!$SERVER_AUDIT_SO) {
6 skip No SERVER_AUDIT plugin;
7 }
8
9 # An unfortunate wait for check-testcase.inc to complete disconnect.
10 let count_sessions= 1;
11 source include/wait_until_count_sessions.inc;
12
13 let $MYSQLD_DATADIR= `SELECT @@datadir`;
14 let SEARCH_FILE= $MYSQLD_DATADIR/server_audit_query_id.log;
15
16 --disable_ps_protocol
17
18 set global server_audit_logging=on;
19
20 USE test;
21
22 CREATE TABLE source (
23 id bigint(20) NOT NULL AUTO_INCREMENT,
24 PRIMARY KEY (id)
25 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
26
27 CREATE TABLE dest (
28 id bigint(20) NOT NULL,
29 PRIMARY KEY (id)
30 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
31
32 CREATE TABLE dest_2 (
33 id bigint(20) NOT NULL,
34 PRIMARY KEY (id)
35 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
36
37 DELIMITER //;
38 CREATE TRIGGER test_trigger
39 AFTER INSERT ON source
40 FOR EACH ROW
41 INSERT INTO dest (id) VALUES(NEW.id)//
42 DELIMITER ;//
43
44 DELIMITER //;
45 CREATE TRIGGER test_trigger_2
46 AFTER INSERT ON dest
47 FOR EACH ROW
48 INSERT INTO dest_2 (id) VALUES(NEW.id)//
49 DELIMITER ;//
50
51 DELIMITER //;
52 CREATE PROCEDURE test_procedure (IN id bigint(20))
53 NOT DETERMINISTIC MODIFIES SQL DATA
54 BEGIN
55 INSERT INTO source VALUES (id), (NULL);
56 END;//
57 DELIMITER ;//
58
59 --echo # Insert a row to trigger the AFTER trigger
60 INSERT INTO source VALUES (NULL);
61
62 --echo # Insert another row to see the pattern
63 INSERT INTO source VALUES (NULL);
64
65 --echo # Test with multi-row insert
66 INSERT INTO source VALUES (NULL), (NULL);
67
68 --echo # Test with stored procedure
69 CALL test_procedure(NULL);
70
71 --echo # Clean up
72 DROP PROCEDURE test_procedure;
73 DROP TABLE source, dest, dest_2;
74
75 set global server_audit_logging=off;
76
77 --echo # Wait for audit events to be written
78 --let SEARCH_FILE = $MYSQLD_DATADIR/server_audit_query_id.log
79 --let SEARCH_PATTERN = set global server_audit_logging=off
80 --source include/search_pattern_in_file.inc
81
82 # Read and normalize the log
83 --exec perl $MYSQL_TEST_DIR/suite/plugins/t/normalize_query_id.pl $SEARCH_FILE
84
85 # Output the log without heavy replacements so we can see the actual order
86 --replace_regex /\d\d\d\d\d\d\d\d \d\d:\d\d:\d\d/TIMESTAMP/ /,[^,]+,root,localhost,/,HOSTNAME,root,localhost,/
87
88 cat_file $SEARCH_FILE;
89 remove_file $SEARCH_FILE;