[
https://issues.apache.org/jira/browse/DERBY-2710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12499701
]
Mamta A. Satoor commented on DERBY-2710:
----------------------------------------
The code for collation checking for = operator is in
DataTypeDescriptor.comparable method.
> 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
>
> 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.
