Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.5.9, 10.5
-
Windows 10 x64
Description
I've just upgraded from 10.4 to 10.5 and now some queries results in a server crash.
The issue can be reproduced by creating this simple table and make a query on it. It doesn't matter if the table is empty or not.
CREATE TABLE `test` (
|
`a` BIGINT(20) NOT NULL,
|
`b` BIGINT(20) NOT NULL,
|
`c` BIGINT(20) NOT NULL,
|
PRIMARY KEY (`a`, `b`, `c`) USING BTREE,
|
INDEX `KEY_2` (`b`) USING BTREE
|
) ENGINE=InnoDB;
|
Then running this query produce the crash:
SELECT count(*) FROM test
|
WHERE c = 1
|
AND a IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,
|
31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,
|
58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90)
|
AND b IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,
|
31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,
|
58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90);
|
I've found out, that it is important how many values are in the lists. Less number seems to work.
Attachments
Issue Links
- is duplicated by
-
-
- Closed
-
- relates to
-
-
- Closed
-