Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <14337226.1183720864750.JavaMail.jira@brutus>
Date: Fri, 6 Jul 2007 04:21:04 -0700 (PDT)
From: "Mamta A. Satoor (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Closed: (DERBY-2725) If all the operands involved in
 collation operation have a collation derivation of NONE, then Derby should
 throw an exception for that as per the SQL standards.
In-Reply-To: <2654888.1180471036435.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/DERBY-2725?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mamta A. Satoor closed DERBY-2725.
----------------------------------


> If all the operands involved in collation operation have a collation derivation of NONE, then Derby should throw an exception for that as per the SQL standards.
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2725
>                 URL: https://issues.apache.org/jira/browse/DERBY-2725
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.3.0.0, 10.3.1.1, 10.4.0.0
>            Reporter: Mamta A. Satoor
>            Assignee: Mamta A. Satoor
>             Fix For: 10.3.1.1, 10.4.0.0
>
>
> 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. 
> Derby doesn't yet enforce this rule of having atleast one operand with non-NONE collation derivation when working with collation operation. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.