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

        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:

                Smart Checklist