Details
-
Sub-task
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
10.3.1.4
-
None
Description
DERBY-47 changed the static rewrite logic for IN lists. Whereas we used to create a BETWEEN predicate for IN-lists that contain all constants and then use that predicate to limit the scan, we now create a "probe predicate" for IN-lists that contain all constants and/or parameter nodes and then use that new predicate to perform execution-time probing.
The documentation in the Tuning Guide needs to be updated to reflect this change in behavior.