Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Duplicate
-
Affects Version/s: 10.2.16, 10.2.17
-
Fix Version/s: N/A
-
Component/s: Data Manipulation - Subquery, Storage Engine - InnoDB
-
Labels:None
-
Environment: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)
-
- In Review
-