Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.5.4
-
None
Description
The commands
DELIMITER // |
|
|
CREATE PROCEDURE simpleproc (OUT param1 INT)
|
BEGIN
|
SELECT COUNT(*) INTO param1 FROM t;
|
END;
|
//
|
|
|
DELIMITER ;
|
|
|
DROP PROCEDURE simpleproc ;
|
will not be logged with
set global server_audit_events = "CONNECT,QUERY_DDL,QUERY_DCL";
also not with QUERY_DML
set global server_audit_events = "CONNECT,QUERY_DDL,QUERY_DCL,QUERY_DML";
with adding QUERY it works.
set global server_audit_events = "CONNECT,QUERY_DDL,QUERY_DCL,QUERY_DML,QUERY";
In the KB CREATE / DROP PROCEDURE will not classified as DDL.
—except CREATE/DROP [PROCEDURE / FUNCTION / USER] and RENAME USER (they're not DDL)
|
[https://mariadb.com/kb/en/mariadb-audit-plugin-log-settings/|
https://mariadb.com/kb/en/mariadb-audit-plugin-log-settings/]
Even if this would be true, it should be logged with adding QUERY_DML at least,
but SQL standard classify it also as DDL.
https://www.w3schools.in/mysql/ddl-dml-dcl/#DDL
In MariaDB and SQL standard DROP / CREATE Procedures is classified as DDL.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Fix Version/s | 10.5 [ 23123 ] | |
| Assignee | Ralf Gebhardt [ ralf.gebhardt@mariadb.com ] |
| Assignee | Ralf Gebhardt [ ralf.gebhardt@mariadb.com ] | Sergei Golubchik [ serg ] |
| Assignee | Sergei Golubchik [ serg ] | Alexey Botchkov [ holyfoot ] |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| issue.field.resolutiondate | 2021-03-29 14:33:32.0 | 2021-03-29 14:33:32.634 |
| Fix Version/s | 10.3.29 [ 25206 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Fix Version/s | 10.2.38 [ 25207 ] |
| Fix Version/s | 10.5.13 [ 26026 ] | |
| Fix Version/s | 10.4.22 [ 26031 ] |
| Fix Version/s | 10.6.5 [ 26034 ] |
| Link | This issue relates to MENT-919 [ MENT-919 ] |
| Workflow | MariaDB v3 [ 112337 ] | MariaDB v4 [ 158231 ] |
| Zendesk Related Tickets | 169206 166378 |