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

SET STATEMENT last_insert_id FOR ... does not affect the value written to the binlog

Details

    Description

      MariaDB [test]> set statement last_insert_id = 112 for create table tmp as select last_insert_id();
      		 
      Query OK, 1 row affected (1.30 sec)
      		 
      Records: 1  Duplicates: 0  Warnings: 0
      		 
       
      		 
      MariaDB [test]> show binlog events;
      		 
      ...
      		 
      | wheezy-64-bin.000001 | 316 | Gtid              |         1 |         354 | GTID 0-1-1                                                                                     |
      		 
      | wheezy-64-bin.000001 | 354 | Intvar            |         1 |         382 | LAST_INSERT_ID=0                                                                               |
      		 
      | wheezy-64-bin.000001 | 382 | Query             |         1 |         527 | use `test`; set statement last_insert_id = 112 for create table tmp as select last_insert_id() |
      		 
      +----------------------+-----+-------------------+-----------+-------------+------------------------------------------------------------------------------------------------+
      		 

      commit d6981391eb8f904135dfdedb5b90a7592b35e648
      		 
      Author: Oleksandr Byelkin <sanja@mariadb.com>
      		 
      Date:   Thu Oct 30 19:34:54 2014 +0100
      		 
       
      		 
          MDEV_6976: Assertion `! is_set() || m_can_overwrite_status' failed in Diagnostics_area::set_error_status on SET STATEMENT debug_sync
      		 
          
          DEBUG_SYNC has complex logic of using different from other variables so it is prohibited in SEt STATENT

      Percona server works okay.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-5231 Per query variables from Percona Server [patch]

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Technical task - A technical task. MDEV-6923 Testing for SET STATEMENT .. FOR (MDEV-5231, per-query variables)

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            sanja Oleksandr Byelkin added a comment -

            The variable prohibited as a workaround.

            sanja Oleksandr Byelkin added a comment - The variable prohibited as a workaround.
            sanja Oleksandr Byelkin added a comment - - edited

            Problem was in reinitialization of first_successful_insert_id_in_prev_stmt_for_binlog after setting variables.

            sanja Oleksandr Byelkin added a comment - - edited Problem was in reinitialization of first_successful_insert_id_in_prev_stmt_for_binlog after setting variables.
            sanja Oleksandr Byelkin added a comment -

            Fixed test commit:

            revision-id: 60c1dc1ab24bfe9b3f4a898fe5e7cb070ee02cf7
            parent(s): d0d6284cab70af148269d95744f615454cac24bb
            committer: Oleksandr Byelkin
            branch nick: work-maria-10.1-MDEV-6997-real
            timestamp: 2015-02-25 19:00:57 +0100
            message:

            MDEV-6997: SET STATEMENT last_insert_id FOR ... does not affect the value written to the binlog

            sanja Oleksandr Byelkin added a comment - Fixed test commit: revision-id: 60c1dc1ab24bfe9b3f4a898fe5e7cb070ee02cf7 parent(s): d0d6284cab70af148269d95744f615454cac24bb committer: Oleksandr Byelkin branch nick: work-maria-10.1- MDEV-6997 -real timestamp: 2015-02-25 19:00:57 +0100 message: MDEV-6997 : SET STATEMENT last_insert_id FOR ... does not affect the value written to the binlog
            sanja Oleksandr Byelkin added a comment -

            Checked with stored functions everything is OK.

            sanja Oleksandr Byelkin added a comment - Checked with stored functions everything is OK.
            sanja Oleksandr Byelkin added a comment -

            revision-id: b7237786f5b8e74ba9558db8325d29a64f1a1d9b
            parent(s): ba3573cae8f0d269452cc6213f1a8243e455830e
            committer: Oleksandr Byelkin
            branch nick: server
            timestamp: 2015-03-13 16:32:47 +0100
            message:

            MDEV-6997: SET STATEMENT last_insert_id FOR ... does not affect the value written to the binlog

            Problem was in reinitialization of first_successful_insert_id_in_prev_stmt_for_binlog after setting variables.

            sanja Oleksandr Byelkin added a comment - revision-id: b7237786f5b8e74ba9558db8325d29a64f1a1d9b parent(s): ba3573cae8f0d269452cc6213f1a8243e455830e committer: Oleksandr Byelkin branch nick: server timestamp: 2015-03-13 16:32:47 +0100 message: MDEV-6997 : SET STATEMENT last_insert_id FOR ... does not affect the value written to the binlog Problem was in reinitialization of first_successful_insert_id_in_prev_stmt_for_binlog after setting variables.

            People

              sanja Oleksandr Byelkin
              elenst Elena Stepanova
              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.