[DERBY-3651] Current DataTypeDescriptor.comparable() is subset of SQL spec. Enhance it to fully implement SQL spec

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: SQL
• Labels: derby_triage10_10
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Mamta A. Satoor
• Created: 29/Apr/08 18:11
• Updated: 01/Oct/12 02:16

Description

Collation functionality(DERBY-1478) was implemented in 10.3 The functionality in 10.3 and 10.4 currently has DataTypeDescriptor.comparable() implement subset of SQL standard. More info on this can be found in DERBY-2876 and other related task is DERBY-2875.

The current implementation of comparable requires that collation type and derivation must match for the types to be comparable. According to SQL Standard 9.13, e.g. with non-matching types and one derivation of implicit and one of none, then the types are comparable.