Debian Codegraph @

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

raw
1 call mtr.add_suppression("Event 'MYSQL_AUDIT_AUTHENTICATION_CREDENTIAL_CHANGE' cannot be aborted.");
2 call mtr.add_suppression("Event 'MYSQL_AUDIT_AUTHENTICATION_AUTHID_RENAME' cannot be aborted.");
3 call mtr.add_suppression("Event 'MYSQL_AUDIT_AUTHENTICATION_AUTHID_DROP' cannot be aborted.");
4 call mtr.add_suppression("Event 'MYSQL_AUDIT_AUTHENTICATION_FLUSH' cannot be aborted.");
5 INSTALL PLUGIN null_audit SONAME 'adt_null.so';
6 ###################################################
7 ## MYSQL_AUDIT_AUTHENTICATION_CREDENTIAL_CHANGE ##
8 ###################################################
9 CREATE USER testuser@localhost IDENTIFIED BY 'testpwd';
10 PREPARE stmt FROM 'ALTER USER testuser@localhost IDENTIFIED BY \'NewPass\'';
11 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
12 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
13 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
14 'MYSQL_AUDIT_GENERAL_LOG;;;'
15 'MYSQL_AUDIT_QUERY_START;sql_command_id="100";;'
16 'MYSQL_AUDIT_GENERAL_LOG;;;'
17 'MYSQL_AUDIT_QUERY_START;sql_command_id="134";;'
18 'MYSQL_AUDIT_AUTHENTICATION_CREDENTIAL_CHANGE;;ABORT_RET';
19 EXECUTE stmt;
20 SELECT @@null_audit_event_order_check;
21 @@null_audit_event_order_check
22 EVENT-ORDER-ABORT
23 ##############################################
24 ## MYSQL_AUDIT_AUTHENTICATION_AUTHID_RENAME ##
25 ##############################################
26 PREPARE stmt FROM 'RENAME USER testuser@localhost TO newuser@localhost';
27 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
28 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
29 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
30 'MYSQL_AUDIT_GENERAL_LOG;;;'
31 'MYSQL_AUDIT_QUERY_START;sql_command_id="100";;'
32 'MYSQL_AUDIT_GENERAL_LOG;;;'
33 'MYSQL_AUDIT_QUERY_START;sql_command_id="86";;'
34 'MYSQL_AUDIT_AUTHENTICATION_AUTHID_RENAME;;ABORT_RET';
35 EXECUTE stmt;
36 SELECT @@null_audit_event_order_check;
37 @@null_audit_event_order_check
38 EVENT-ORDER-ABORT
39 ############################################
40 ## MYSQL_AUDIT_AUTHENTICATION_AUTHID_DROP ##
41 ############################################
42 PREPARE stmt FROM 'DROP USER newuser@localhost';
43 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
44 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
45 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
46 'MYSQL_AUDIT_GENERAL_LOG;;;'
47 'MYSQL_AUDIT_QUERY_START;sql_command_id="100";;'
48 'MYSQL_AUDIT_GENERAL_LOG;;;'
49 'MYSQL_AUDIT_QUERY_START;sql_command_id="85";;'
50 'MYSQL_AUDIT_AUTHENTICATION_AUTHID_DROP;;ABORT_RET';
51 EXECUTE stmt;
52 SELECT @@null_audit_event_order_check;
53 @@null_audit_event_order_check
54 EVENT-ORDER-ABORT
55 ######################################
56 ## MYSQL_AUDIT_AUTHENTICATION_FLUSH ##
57 ######################################
58 PREPARE stmt FROM 'FLUSH PRIVILEGES';
59 SET @@null_audit_event_order_check = 'MYSQL_AUDIT_COMMAND_START;command_id="3";;'
60 'MYSQL_AUDIT_PARSE_PREPARSE;;;'
61 'MYSQL_AUDIT_PARSE_POSTPARSE;;;'
62 'MYSQL_AUDIT_GENERAL_LOG;;;'
63 'MYSQL_AUDIT_QUERY_START;sql_command_id="100";;'
64 'MYSQL_AUDIT_GENERAL_LOG;;;'
65 'MYSQL_AUDIT_QUERY_START;sql_command_id="49";;'
66 'MYSQL_AUDIT_AUTHENTICATION_FLUSH;;ABORT_RET';
67 EXECUTE stmt;
68 SELECT @@null_audit_event_order_check;
69 @@null_audit_event_order_check
70 EVENT-ORDER-ABORT
71 DROP PREPARE stmt;
72 UNINSTALL PLUGIN null_audit;
73 Warnings:
74 Warning 1620 Plugin is busy and will be uninstalled on shutdown