Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5703

UNION/INTERSECT/EXCEPT VALUES crashes the server if a ColumnStore table is involved

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 23.10.1
    • 23.10.3
    • MDB Plugin
    • None
    • 2024-2

    Description

      MariaDB [test]> SELECT * FROM t UNION ALL VALUES (1, 2);
      		 
      ERROR 2013 (HY000): Lost connection to server during query

      MariaDB crashed.

      Same results with:

      • UNION [ ALL | DISTINCT ] VALUES
      • INTERSECT [ ALL | DISTINCT ] VALUES
      • EXCEPT [ ALL | DISTINCT ] VALUES

      These queries work with InnoDB.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          f_razzoli Federico Razzoli created issue -
          leonid.fedorov Leonid Fedorov made changes -
          Field Original Value New Value
          Affects Version/s 23.10.1 [ 29105 ]
          leonid.fedorov Leonid Fedorov made changes -
          Fix Version/s 23.10.3 [ 29862 ]
          leonid.fedorov Leonid Fedorov made changes -
          Assignee Alexey Antipovsky [ JIRAUSER47594 ]
          leonid.fedorov Leonid Fedorov made changes -
          Sprint 2024-2 [ 764 ]
          alexey.antipovsky Alexey Antipovsky made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          JIraAutomate JiraAutomate made changes -
          Status In Progress [ 3 ] Stalled [ 10000 ]
          alexey.antipovsky Alexey Antipovsky made changes -
          Status Stalled [ 10000 ] In Progress [ 3 ]
          drrtuy Roman made changes -
          Status In Progress [ 3 ] In Testing [ 10301 ]
          drrtuy Roman made changes -
          Assigned for Review Roman [ drrtuy ]
          alexey.antipovsky Alexey Antipovsky made changes -
          Component/s MDB Plugin [ 13801 ]
          Resolution Fixed [ 1 ]
          Status In Testing [ 10301 ] Closed [ 6 ]

          People

            alexey.antipovsky Alexey Antipovsky
            f_razzoli Federico Razzoli
            Roman Roman
            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.