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

MariaDB 10.11.9 Server (Docker Container) crashes on a simple query

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • None
    • N/A
    • N/A
    • None
    • Ubuntu 22.04.5 LTS (Official docker image from MariaDB)

    Description

      Below simple query causes the MariaDB 10.11.9 docker container to crash.
      There's no such issue with MariaDB 10.11.7 or 10.11.8.

      SELECT * FROM (
          (
              SELECT MAX(`dateCreated`) AS `latestDate`, A.* FROM (
                  SELECT E.`empNo` AS `empNo`, E.`terminationId` AS `empTerminationId`, CR.`requestId`, CR.`dateCreated`
                  FROM `ClaimRequest` CR INNER JOIN `Employee` E ON (CR.`empNo` = E.`empNo`)
                  LIMIT 18446744073709551615
              ) AS A
              GROUP BY `requestId`
          )
          UNION
          (
              SELECT (`dateCreated`) AS `latestDate`, B.* FROM (
                  SELECT E.`empNo` AS `empNo`, E.`terminationId` AS `empTerminationId`, CR.`requestId`, CR.`dateCreated`
                  FROM `ClaimRequest` CR INNER JOIN `Employee` E ON (CR.`empNo` = E.`empNo`)
                  LIMIT 18446744073709551615
              ) AS B
          )
      ) AS ED
      WHERE
          CASE '1'
              WHEN 1 THEN `empTerminationId` IS NULL
              WHEN 2 THEN TRUE
              ELSE `empTerminationId` IS NOT NULL
          END;
      

      Table structure with sample data is available in attached data.sql.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              amilwaduwawara Amil Waduwawara
              Votes:
              2 Vote for this issue
              Watchers:
              5 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.