Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4564

ALTER on a temporary table generates an audit event

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.5.31
    • Fix Version/s: 5.5.32
    • Component/s: None
    • Labels:

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: