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

DROP TEMPORARY table is logged despite no CREATE was logged

    XMLWordPrintable

Details

    Description

      commit c4bb7cd6dcd83a8c1dc15794d51cfacd10980855
      Date: Thu Mar 20 00:59:13 2014 +0200

      Fix for MDEV-5589: "Discrepancy in binlog on half-failed CREATE OR REPLACE"

      'added code for not logging DROP TEMPORARY TABLE for tables where the CREATE TABLE was not logged. '

      However the DROP query gets logged into binary log despite the fact of no CREATE was logged.

      --connect (one,...)
      set @@binlog_format=row;
      drop temporary table if exists tt;
      show binlog events; # =>
       
      | master-bin.000001 | 371 | Query             |         1 |         485 | use `test`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tt` |
      
      

      The connection close also create the DROP event in binlog.

      Attachments

        Issue Links

          Activity

            People

              sujatha.sivakumar Sujatha Sivakumar (Inactive)
              Elkin Andrei Elkin
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.