diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2013-06-07 10:02:50 +0200 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2013-06-07 10:02:50 +0200 |
| commit | 6625fad8ca9fdb3e9b473bb597f93baa757366ea (patch) | |
| tree | 6940a94a6162a11960006efa94f6b591e820d735 /mysql-test/suite/plugins | |
| parent | 3bc814bedaaa44ee69e47f74a9ebc196e0f44bd7 (diff) | |
| download | mariadb-git-6625fad8ca9fdb3e9b473bb597f93baa757366ea.tar.gz | |
MDEV-4564 ALTER on a temporary table generates an audit event
Diffstat (limited to 'mysql-test/suite/plugins')
| -rw-r--r-- | mysql-test/suite/plugins/r/audit_null.result | 4 | ||||
| -rw-r--r-- | mysql-test/suite/plugins/t/audit_null.test | 1 |
2 files changed, 4 insertions, 1 deletions
diff --git a/mysql-test/suite/plugins/r/audit_null.result b/mysql-test/suite/plugins/r/audit_null.result index 76aef454b94..79de1f7df80 100644 --- a/mysql-test/suite/plugins/r/audit_null.result +++ b/mysql-test/suite/plugins/r/audit_null.result @@ -44,6 +44,7 @@ insert t2 values ('2020-10-09'); select * from t2; a 2020-10-09 +alter table t2 add column b int; drop table t2; explain select distinct * from t2; id select_type table type possible_keys key key_len ref rows Extra @@ -77,8 +78,8 @@ root[root] @ localhost [] test.t1 : read root[root] @ localhost [] >> rename table t1 to t2 root[root] @ localhost [] test.t1 : rename to test.t2 root[root] @ localhost [] >> alter table t2 add column b int -root[root] @ localhost [] test.t2 : alter root[root] @ localhost [] test.t2 : read +root[root] @ localhost [] test.t2 : alter root[root] @ localhost [] >> create definer=testuser@localhost view v1 as select t2.a+1, t2_copy.a+2 from t2, t2 as t2_copy root[root] @ localhost [] test.t2 : read root[root] @ localhost [] test.t2 : read @@ -89,6 +90,7 @@ root[root] @ localhost [] >> drop view v1 root[root] @ localhost [] >> create temporary table t2 (a date) root[root] @ localhost [] >> insert t2 values ('2020-10-09') root[root] @ localhost [] >> select * from t2 +root[root] @ localhost [] >> alter table t2 add column b int root[root] @ localhost [] >> drop table t2 root[root] @ localhost [] >> explain select distinct * from t2 root[root] @ localhost [] test.t2 : read diff --git a/mysql-test/suite/plugins/t/audit_null.test b/mysql-test/suite/plugins/t/audit_null.test index 60883bbe4f9..3e32154ec3d 100644 --- a/mysql-test/suite/plugins/t/audit_null.test +++ b/mysql-test/suite/plugins/t/audit_null.test @@ -38,6 +38,7 @@ drop view v1; create temporary table t2 (a date); insert t2 values ('2020-10-09'); select * from t2; +alter table t2 add column b int; # MDEV-4565 ALTER on a temporary table generates an audit event drop table t2; # internal temp table generates no audit events |