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-2678) Derby should follow SQL standards when operand(s) in the collation operation have collation derivation of NONE
Date Tue, 22 May 2007 06:31:16 GMT

    [ https://issues.apache.org/jira/browse/DERBY-2678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12497731
] 

Mamta A. Satoor commented on DERBY-2678:
----------------------------------------

Derby 10.3 implements the item number 2) above but item number 1) has not been tackled yet.

> Derby should follow SQL standards when operand(s) in the collation operation have collation
derivation of NONE
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2678
>                 URL: https://issues.apache.org/jira/browse/DERBY-2678
>             Project: Derby
>          Issue Type: New Feature
>          Components: SQL
>    Affects Versions: 10.3.0.0
>            Reporter: Mamta A. Satoor
>
> The collation methods in Derby should follow the rules defined by SQL spec in Section
9.13 Collation determination Syntax Rules 2 and 3e. 
> According to those rules, 
> 1)at least one operand shall have a declared type collation (that means if the comparison
is sysChar1|userChar1 > sysChar2|userChar2, then such a comparison will fail because both
sides of > operator have collation derivation of NONE. But if the comparison is sysChar|userChar1
> sysChar2, then it shouldn't fail because although the left hand operand has collation
derivation of NONE, the right hand operand has collation derivation of IMPLICIT and hence
the comparison is possible). 
> 2)every operand whose collation derivation is IMPLICIT shall have the same declared type
collation (that means if the comparison is sysChar1 > userChar1WithTerritoryBasedCollation,
then such a comparison will fail because left operand has collation derivation as IMPLICIT
and collation type as UCS_BASIC and the right operand has collation derivation IMPLICIT and
collation type as TERRITORY_BASED. But if the comparison is sysChar1 > sysChar2, then comparison
won't fail because both the operands have same collation derivation and type.) 

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