Debian Codegraph @

mysql-test/suite/plugins/r/server_audit_query_id.result

raw
1 set global server_audit_logging=on;
2 USE test;
3 CREATE TABLE source (
4 id bigint(20) NOT NULL AUTO_INCREMENT,
5 PRIMARY KEY (id)
6 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
7 CREATE TABLE dest (
8 id bigint(20) NOT NULL,
9 PRIMARY KEY (id)
10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
11 CREATE TABLE dest_2 (
12 id bigint(20) NOT NULL,
13 PRIMARY KEY (id)
14 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
15 CREATE TRIGGER test_trigger
16 AFTER INSERT ON source
17 FOR EACH ROW
18 INSERT INTO dest (id) VALUES(NEW.id)//
19 CREATE TRIGGER test_trigger_2
20 AFTER INSERT ON dest
21 FOR EACH ROW
22 INSERT INTO dest_2 (id) VALUES(NEW.id)//
23 CREATE PROCEDURE test_procedure (IN id bigint(20))
24 NOT DETERMINISTIC MODIFIES SQL DATA
25 BEGIN
26 INSERT INTO source VALUES (id), (NULL);
27 END;//
28 # Insert a row to trigger the AFTER trigger
29 INSERT INTO source VALUES (NULL);
30 # Insert another row to see the pattern
31 INSERT INTO source VALUES (NULL);
32 # Test with multi-row insert
33 INSERT INTO source VALUES (NULL), (NULL);
34 # Test with stored procedure
35 CALL test_procedure(NULL);
36 # Clean up
37 DROP PROCEDURE test_procedure;
38 DROP TABLE source, dest, dest_2;
39 set global server_audit_logging=off;
40 # Wait for audit events to be written
41 FOUND 1 /set global server_audit_logging=off/ in server_audit_query_id.log
42 TIMESTAMP,HOSTNAME,root,localhost,4,0,QUERY,test,'set global server_audit_logging=on',0
43 TIMESTAMP,HOSTNAME,root,localhost,4,1,QUERY,test,'USE test',0
44 TIMESTAMP,HOSTNAME,root,localhost,4,2,QUERY,test,'CREATE TABLE source (\nid bigint(20) NOT NULL AUTO_INCREMENT,\nPRIMARY KEY (id)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4',0
45 TIMESTAMP,HOSTNAME,root,localhost,4,3,QUERY,test,'CREATE TABLE dest (\nid bigint(20) NOT NULL,\nPRIMARY KEY (id)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4',0
46 TIMESTAMP,HOSTNAME,root,localhost,4,4,QUERY,test,'CREATE TABLE dest_2 (\nid bigint(20) NOT NULL,\nPRIMARY KEY (id)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4',0
47 TIMESTAMP,HOSTNAME,root,localhost,4,5,QUERY,test,'CREATE TRIGGER test_trigger\nAFTER INSERT ON source\nFOR EACH ROW\nINSERT INTO dest (id) VALUES(NEW.id)',0
48 TIMESTAMP,HOSTNAME,root,localhost,4,6,QUERY,test,'CREATE TRIGGER test_trigger_2\nAFTER INSERT ON dest\nFOR EACH ROW\nINSERT INTO dest_2 (id) VALUES(NEW.id)',0
49 TIMESTAMP,HOSTNAME,root,localhost,4,7,QUERY,test,'CREATE PROCEDURE test_procedure (IN id bigint(20))\nNOT DETERMINISTIC MODIFIES SQL DATA\nBEGIN\nINSERT INTO source VALUES (id), (NULL);\nEND',0
50 TIMESTAMP,HOSTNAME,root,localhost,4,10,QUERY,test,'INSERT INTO dest_2 (id) VALUES(NEW.id)',0
51 TIMESTAMP,HOSTNAME,root,localhost,4,9,QUERY,test,'INSERT INTO dest (id) VALUES(NEW.id)',0
52 TIMESTAMP,HOSTNAME,root,localhost,4,8,QUERY,test,'INSERT INTO source VALUES (NULL)',0
53 TIMESTAMP,HOSTNAME,root,localhost,4,13,QUERY,test,'INSERT INTO dest_2 (id) VALUES(NEW.id)',0
54 TIMESTAMP,HOSTNAME,root,localhost,4,12,QUERY,test,'INSERT INTO dest (id) VALUES(NEW.id)',0
55 TIMESTAMP,HOSTNAME,root,localhost,4,11,QUERY,test,'INSERT INTO source VALUES (NULL)',0
56 TIMESTAMP,HOSTNAME,root,localhost,4,16,QUERY,test,'INSERT INTO dest_2 (id) VALUES(NEW.id)',0
57 TIMESTAMP,HOSTNAME,root,localhost,4,15,QUERY,test,'INSERT INTO dest (id) VALUES(NEW.id)',0
58 TIMESTAMP,HOSTNAME,root,localhost,4,18,QUERY,test,'INSERT INTO dest_2 (id) VALUES(NEW.id)',0
59 TIMESTAMP,HOSTNAME,root,localhost,4,17,QUERY,test,'INSERT INTO dest (id) VALUES(NEW.id)',0
60 TIMESTAMP,HOSTNAME,root,localhost,4,14,QUERY,test,'INSERT INTO source VALUES (NULL), (NULL)',0
61 TIMESTAMP,HOSTNAME,root,localhost,4,22,QUERY,test,'INSERT INTO dest_2 (id) VALUES(NEW.id)',0
62 TIMESTAMP,HOSTNAME,root,localhost,4,21,QUERY,test,'INSERT INTO dest (id) VALUES(NEW.id)',0
63 TIMESTAMP,HOSTNAME,root,localhost,4,24,QUERY,test,'INSERT INTO dest_2 (id) VALUES(NEW.id)',0
64 TIMESTAMP,HOSTNAME,root,localhost,4,23,QUERY,test,'INSERT INTO dest (id) VALUES(NEW.id)',0
65 TIMESTAMP,HOSTNAME,root,localhost,4,20,QUERY,test,'INSERT INTO source VALUES ( NAME_CONST(\'id\',NULL)), (NULL)',0
66 TIMESTAMP,HOSTNAME,root,localhost,4,19,QUERY,test,'CALL test_procedure(NULL)',0
67 TIMESTAMP,HOSTNAME,root,localhost,4,25,QUERY,test,'DROP PROCEDURE test_procedure',0
68 TIMESTAMP,HOSTNAME,root,localhost,4,26,QUERY,test,'DROP TABLE source, dest, dest_2',0
69 TIMESTAMP,HOSTNAME,root,localhost,4,27,QUERY,test,'set global server_audit_logging=off',0