Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.2.16, 10.2.17
-
None
-
centos 7 fully yum updated.
Description
The following script crashes the server. We encountered this on 10.2.16 and I have also tested this on 10.2.17 and its the the same. We think the problem is the EXISTS() element.
DROP TABLE IF EXISTS TEST_TABLE_1;
CREATE TABLE TEST_TABLE_1 (
UID BIGINT
);
DROP TABLE IF EXISTS TEST_TABLE_2;
CREATE TABLE TEST_TABLE_2 (
UID BIGINT
);
DROP TABLE IF EXISTS TEST_TABLE_3;
CREATE TABLE TEST_TABLE_3 (
UID BIGINT
);
SELECT
ROW_NUMBER() OVER (PARTITION BY GROUP_CONCAT(TT1.UID))
FROM TEST_TABLE_1 TT1
WHERE EXISTS (
SELECT *
FROM TEST_TABLE_2 TT2
JOIN TEST_TABLE_3 TT3 ON TT2.UID = TT3.UID
WHERE TT3.UID = TT1.UID
)
GROUP BY TT1.UID
;
Attachments
Issue Links
- duplicates
-
MDEV-15178 Filesort::make_sortorder: Assertion `pos->field != __null || pos->item != __null' failed | SIGSEGV in sortlength (on optimized builds)
- Closed