[jira] Resolved: (DERBY-2710) disable dynamic like optimization for collated databases

["Mike Matrigali (JIRA)" <ji...@apache.org>]

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