Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5.52
-
None
-
CentOS Linux release 7.3.1611
Description
The server crashes both on query and (sometimes) when trying to execute «EXPLAIN».
In 10.1.19-MariaDB is also reproduced.
It is noteworthy that a pretty formatted query like
"SELECT rbResult.`id`,
CONCAT_WS(' | ', code, name,
(SELECT rbEventTypePurpose.`name`
FROM rbEventTypePurpose
WHERE id=rbResult.`eventPurpose_id`) )
FROM rbResult
ORDER BY CONCAT_WS(' | ', code, name,
(SELECT rbEventTypePurpose.`name`
FROM rbEventTypePurpose
WHERE id=rbResult.`eventPurpose_id`) );
"
is processed normally. But when query formatted in single line
"SELECT rbResult.`id`, CONCAT_WS(' | ', code, name, (SELECT rbEventTypePurpose.`name` FROM rbEventTypePurpose WHERE id=rbResult.`eventPurpose_id`)) FROM rbResult ORDER BY CONCAT_WS(' | ', code, name, (SELECT rbEventTypePurpose.`name` FROM rbEventTypePurpose WHERE id=rbResult.`eventPurpose_id`));" server crashes.
Attachments:
serv.samson.err: log of 5.5.52-MariaDB,
test-dump.sql: test database dump