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
    • 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
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

              There are no comments yet on this issue.

                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:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 15 minutes
                    15m