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
|
Bug
Major
MDEV-260 auditing table accesses