[ 
https://issues.apache.org/jira/browse/DERBY-2710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mike Matrigali resolved DERBY-2710.
-----------------------------------

       Resolution: Fixed
    Fix Version/s: 10.3.0.0

disabled < and >= like optimization for non default collated like clauses.  
commit # 542553

> disable dynamic like optimization for collated databases
> --------------------------------------------------------
>
>                 Key: DERBY-2710
>                 URL: https://issues.apache.org/jira/browse/DERBY-2710
>             Project: Derby
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 10.3.0.0
>            Reporter: Mike Matrigali
>            Assignee: Mike Matrigali
>             Fix For: 10.3.0.0
>
>
> I think Code needs to be added to 
> opensource/java/engine/org/apache/derby/impl/sql/compile/LikeEscapeOperatorNode.java
> to disable like optimization for databases with non-default collation.  There 
> is left over code in this routine that says it disables it for national char 
> by adding a cast to one of the two sides which I assume then stops some other 
> code from considering the 
> optimization.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to