[MDEV-4564] ALTER on a temporary table generates an audit event Created: 2013-05-22  Updated: 2013-06-09  Resolved: 2013-06-09

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.31
Fix Version/s: 5.5.32

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: plugins

Issue Links:
Relates
relates to MDEV-260 auditing table accesses Closed

 Description   

A comment in audit_null.test says "temp table generates no audit events", but ALTER TABLE still does. I'm not sure if it's intentional.

Test output:

install plugin audit_null soname 'adt_null';
create temporary table t1 (i int);
alter table t1 add j int;
drop table t1;
uninstall plugin audit_null;
Warnings:
Warning	1620	Plugin is busy and will be uninstalled on shutdown
root[root] @ localhost []	>> create temporary table t1 (i int)
root[root] @ localhost []	>> alter table t1 add j int
root[root] @ localhost []	test.t1 : alter
root[root] @ localhost []	>> drop table t1
root[root] @ localhost []	>> uninstall plugin audit_null
root[root] @ localhost []	mysql.plugin : write

Test case:

install plugin audit_null soname 'adt_null';
 
create temporary table t1 (i int);
alter table t1 add j int;
drop table t1;
 
uninstall plugin audit_null;
 
let $MYSQLD_DATADIR= `SELECT @@datadir`;
cat_file $MYSQLD_DATADIR/audit_null_tables.log;

bzr version-info

revision-id: sergii@pisem.net-20130521165635-k9lcq5g95glmrv6r
revno: 3778
branch-nick: 5.5


Generated at Thu Feb 08 06:57:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.