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

ALTER on a temporary table generates an audit event

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5.31
    • 5.5.32
    • None

    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

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.