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

delete_returning.test fails in mdev8646 tree

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • N/A
    • N/A
    • Optimizer
    • None
    • 10.2.0-5

    Description

      delete_returning test fails in MDEV-8646 tree.

      Crashing queries:

      CREATE TABLE t1 (i1 int);
      		 
      INSERT INTO t1 VALUES (1),(2);
      		 
      CREATE TABLE t2 (i2 int);
      		 
      INSERT INTO t2 VALUES (1),(2);
      		 
      DELETE FROM t1 ORDER BY i1 RETURNING ( SELECT i2 FROM t2 );

      The reason the last one crashes is that the execution code first calls:

      JOIN::cleanup (this=0x7fff64065c68, full=true)

      and then it calls

      JOIN::exec (this=0x7fff64065c68)

      that is, attempts to execute a join where it already did a cleanup.

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-8646 Re-engineer the code for post-join operations

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13776 mysqld got signal 11 on delete returning

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            psergei Sergei Petrunia created issue -
            psergei Sergei Petrunia made changes -
            Field Original Value New Value
            psergei Sergei Petrunia made changes -
            Sprint 10.2.0-5 [ 32 ]
            psergei Sergei Petrunia added a comment -

            The "exec-after-cleanup" can be observed on MariaDB 10.0, too. It doesn't crash, because in 10.0, a join can survive JOIN::exec() after JOIN::cleanup(full=true).

            psergei Sergei Petrunia added a comment - The "exec-after-cleanup" can be observed on MariaDB 10.0, too. It doesn't crash, because in 10.0, a join can survive JOIN::exec() after JOIN::cleanup(full=true).
            elenst Elena Stepanova made changes -
            Affects Version/s N/A [ 14700 ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.2 [ 14601 ]
            psergei Sergei Petrunia added a comment -

            Pushed into bb-10.1-mdev8646 branch.

            psergei Sergei Petrunia added a comment - Pushed into bb-10.1-mdev8646 branch.
            psergei Sergei Petrunia made changes -
            Fix Version/s N/A [ 14700 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            mohit_chandel23@yahoo.com Mohit Chandel made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 73821 ] MariaDB v4 [ 150045 ]

            People

              psergei Sergei Petrunia
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.