db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2710) disable dynamic like optimization for collated databases
Date Tue, 29 May 2007 07:01:35 GMT

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


Mime
View raw message