[
https://issues.apache.org/jira/browse/DERBY-2642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12496091
]
A B commented on DERBY-2642:
----------------------------
I think the optimization in question here is described:
http://db.apache.org/derby/docs/dev/tuning/rtuntransform472.html
In particular, note the following line:
"In this situation, the LIKE predicate is likewise transformed into three
predicates: one LIKE predicate,
one predicate using the >= operator, and one predicate using the < operator."
This correlates to what you have noted about the qualifiers, so my guess is
that Yes, this is what demonstrates the "dynamic like optimization".
> Convert lang/dynamicLikeOptimization.sql to JUnit
> -------------------------------------------------
>
> Key: DERBY-2642
> URL: https://issues.apache.org/jira/browse/DERBY-2642
> Project: Derby
> Issue Type: Improvement
> Components: Test
> Affects Versions: 10.3.0.0
> Reporter: Knut Anders Hatlen
> Priority: Minor
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
