Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-1816

LP #1711781: Redundant GTID unsafe mark for CREATE/DROP TEMPORARY TABLE in RBR/MBR

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by Nickolay Ihalainen last update 28-09-2017 15:00:23

      Temporary tables are not logged in binlog for RBR after:
      https://bugs.launchpad.net/percona-server/+bug/1668602

      This makes tests passing for: https://bugs.mysql.com/bug.php?id=77354
      even with:

      @@ -11005,7 +11005,8 @@ bool THD::is_ddl_gtid_compatible()
      GTID even if the transaction is rolled back.
      This includes the execution inside Functions and Triggers.
      */

      • if (in_multi_stmt_transaction_mode() || in_sub_stmt)
        + if ((in_multi_stmt_transaction_mode() || in_sub_stmt)
        + && !is_current_stmt_binlog_format_row())

      Patch provided by customer fixes forever-opened Hibernate bug related to gtid and temporary tables inside transactions:
      https://hibernate.atlassian.net/browse/HHH-9289

      The bug is not applicable for upstream, because
      https://bugs.mysql.com/bug.php?id=85258 still not applied

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              lpjirasync lpjirasync (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: