Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
None
-
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
- duplicates
-
MDEV-34683 Types mismatch when cloning items causes debug assertion
- Closed