Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.4(EOL), 10.5(EOL)
-
None
Description
Fix the bug encountered when the size of (v1,v2,v3...) value list in “select * from tb where id in (v1, v2, v3...)” is greater than 1000 (IN_SUBQUERY_CONVERSION_THRESHOLD‘s default value)
Set IN_SUBQUERY_CONVERSION_THRESHOLD's to uint_max to disable this optimization on spider
Attachments
Issue Links
- relates to
-
MDEV-33560 Spider: query with long IN clause has performance issues
-
- Closed
-