db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "A B (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2642) Convert lang/dynamicLikeOptimization.sql to JUnit
Date Tue, 15 May 2007 19:05:16 GMT

    [ 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.


Mime
View raw message