[
https://issues.apache.org/jira/browse/DERBY-2499?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Laura Stewart updated DERBY-2499:
---------------------------------
Attachment: rtuntransform582.html
derby2499_2.diff
Army - I believe that I have addressed all of your corrections with the
exception of 1. Typically all examples start flush left. Then we indent for
different parts of the command and SQL statement. For the smaller examples, I
did indent. but for the JDBC and SQL examples I kept them as is.
Please let me know if you see anything else that needs to be corrected !
> Update Tuning Guide documentation to reflect the new static IN list
> transformation that occurs as a result of DERBY-47.
> -----------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2499
> URL: https://issues.apache.org/jira/browse/DERBY-2499
> Project: Derby
> Issue Type: Sub-task
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: A B
> Assigned To: Laura Stewart
> Priority: Minor
> Attachments: derby2499_1.diff, derby2499_2.diff,
> rtuntransform582.html, rtuntransform582.html
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
