|
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
|