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

View raw message