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

Insert from select / view / union -- repeatable crash in 10.1, 10.2 Linux/Mac/Windows

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1.18, 10.2.1, 10.1(EOL), 10.2(EOL)
    • 10.1.27, 10.2.9, 10.3.2
    • Optimizer
    • None
    • Centos 7 AWS but also Sierra and Windows 10
    • 10.1.19, 10.2.4-1, 10.2.4-2

    Description

      I've hit what appears to be an optimizer bug that crashes the server daemon. The test case works fine on 10.0.x but fails on 10.1.18 and 10.2.1.

      Attachments

        Issue Links

          Activity

            Problem present in 5.5/10.0 but do not lead to crash, because it has different EXPLAIN system.

            sanja Oleksandr Byelkin added a comment - Problem present in 5.5/10.0 but do not lead to crash, because it has different EXPLAIN system.

            revision-id: f360516046af16336e874b1ab9fb22efb1881723 (mariadb-10.1.20-33-gf360516046a)
            parent(s): 5044dae239d094582879792de7a762d3428223ce
            committer: Oleksandr Byelkin
            timestamp: 2017-01-17 13:09:04 +0100
            message:

            MDEV-10972: Insert from select / view / union – repeatable crash in 10.1, 10.2 Linux/Mac/Windows

            save thd->select_number between parsing and executions (in case it was not complete executed due to errors (for example epsent table))

            sanja Oleksandr Byelkin added a comment - revision-id: f360516046af16336e874b1ab9fb22efb1881723 (mariadb-10.1.20-33-gf360516046a) parent(s): 5044dae239d094582879792de7a762d3428223ce committer: Oleksandr Byelkin timestamp: 2017-01-17 13:09:04 +0100 message: MDEV-10972 : Insert from select / view / union – repeatable crash in 10.1, 10.2 Linux/Mac/Windows save thd->select_number between parsing and executions (in case it was not complete executed due to errors (for example epsent table)) —

            The very first SELECT_LEX which belong to LEX should not be a problem.

            sanja Oleksandr Byelkin added a comment - The very first SELECT_LEX which belong to LEX should not be a problem.

            revision-id: c62864b57568e81d77a1ffa2d7ad96d5daccfe97 (mariadb-10.1.26-26-gc62864b5756)
            parent(s): 4d158d71a667dfbf8f679e1e6abd5f46813b5e2f
            author: Oleksandr Byelkin
            committer: Oleksandr Byelkin
            timestamp: 2017-09-04 15:29:58 +0200
            message:

            Post review change (prevents contant increasing, which harmless but not right)

            sanja Oleksandr Byelkin added a comment - revision-id: c62864b57568e81d77a1ffa2d7ad96d5daccfe97 (mariadb-10.1.26-26-gc62864b5756) parent(s): 4d158d71a667dfbf8f679e1e6abd5f46813b5e2f author: Oleksandr Byelkin committer: Oleksandr Byelkin timestamp: 2017-09-04 15:29:58 +0200 message: Post review change (prevents contant increasing, which harmless but not right) —

            Review input provided in chat window. Ok to push after addressed.

            psergei Sergei Petrunia added a comment - Review input provided in chat window. Ok to push after addressed.

            People

              sanja Oleksandr Byelkin
              mnewcomb2016 Michael Newcomb
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.