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

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13174 Repeatable daemon crash in 10.2.6 on show procedure / select sql_derived.cc:1081

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13365 Crash when select where not in select distinct subquery

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13174 Repeatable daemon crash in 10.2.6 on show procedure / select sql_derived.cc:1081

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            mnewcomb2016 Michael Newcomb created issue -
            mnewcomb2016 Michael Newcomb made changes -
            Field Original Value New Value
            Summary Repeatable crash in 10.1, 10.2 Linux/Mac/Windows Insert from select / view / union -- repeatable crash in 10.1, 10.2 Linux/Mac/Windows
            elenst Elena Stepanova made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.2 [ 14601 ]
            Affects Version/s 10.1 [ 16100 ]
            Affects Version/s 10.2 [ 14601 ]
            Assignee Oleksandr Byelkin [ sanja ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.1.19 [ 109 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.1.19 [ 109 ] 10.1.19, 10.1.21 [ 109, 130 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            sanja Oleksandr Byelkin made changes -
            Status Confirmed [ 10101 ] In Progress [ 3 ]
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Sergei Petrunia [ psergey ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.1.19, 10.1.21 [ 109, 130 ] 10.1.19, 10.2.4-1 [ 109, 132 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.1.19, 10.2.4-1 [ 109, 132 ] 10.1.19, 10.2.4-1, 10.2.4-2 [ 109, 132, 134 ]
            mnewcomb2016 Michael Newcomb made changes -
            psergei Sergei Petrunia made changes -
            Assignee Sergei Petrunia [ psergey ] Oleksandr Byelkin [ sanja ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            sanja Oleksandr Byelkin made changes -
            Fix Version/s 10.1.27 [ 22609 ]
            Fix Version/s 10.2.9 [ 22611 ]
            Fix Version/s 10.3.2 [ 22533 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            sanja Oleksandr Byelkin made changes -
            sanja Oleksandr Byelkin made changes -
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 77692 ] MariaDB v4 [ 151020 ]

            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.