[MDEV-7444] Server audit: DDL executed via a stored procedure is invisible for QUERY_DDL Created: 2015-01-12  Updated: 2016-02-13  Resolved: 2016-02-13

Status: Closed
Project: MariaDB Server
Component/s: Plugin - Audit
Affects Version/s: N/A
Fix Version/s: 10.0.24

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Alexey Botchkov
Resolution: Fixed Votes: 0
Labels: audit

Sprint: 5.5.48-0

 Description    

MariaDB [test]> set global server_audit_events='QUERY_DDL';
 
Query OK, 0 rows affected (0.00 sec)
 
 
 
MariaDB [test]> create procedure p1() create table tmp (i int);
 
Query OK, 0 rows affected (0.00 sec)
 
 
 
MariaDB [test]> call p1();
 
Query OK, 0 rows affected (0.21 sec)

Only procedure creation is logged, but neither procedure call nor table creation appear in the log.

 Comments   
Comment by Alexey Botchkov [ 2016-02-13 ]

The problem is that notifications weren't sent at all about the PS internals.
Fixed in 10.0

Generated at Thu Feb 08 07:19:38 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.