[DERBY-2336] Enable collation based ordering for CHAR data type.

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.3.1.4
• Fix Version/s: 10.3.1.4
• Component/s: SQL
• Assignee: Mamta A. Satoor
• Reporter: Mamta A. Satoor
• Created: 14/Feb/07 20:30
• Updated: 02/May/13 02:29
• Resolved: 16/May/07 16:57

Description

I am breaking down the Parent task DERBY-1478 (Add built in language based ordering and like processing to Derby) into multiple sub tasks. One of them is to concentrate on enabling the collation based ordering on (hopefully the simplest of all the character data types) CHAR data type. This task in itself might need subtasks if it is later found that it can be subdivided into multiple smaller steps.

Issue Links

• depends upon: DERBY-2416 Provide collation sensitive subclasses for SQLChar, SQLVarchar, SQLLongvarchar and SQLClob which will use the passed Collator to do the collation rather than the default collation of UCS_BASIC
• depends upon: DERBY-2524 DataTypeDescriptor(DTD) needs to have collation type and collation derivation. These new fields will apply only for character string types. Other types should ignore them.
• depends upon: DERBY-2528 Set the correct collation type in SchemaDescriptor. The collation type will be UCS_BASIC for system schemas but it can be TERRITORY_BASED/UCS_BASIC for user schemas.
• depends upon: DERBY-2530 When character type columns are added by CREATE TABLE and ALTER TABLE, their collation type should be set to the containing schema's collation type.
• depends upon: DERBY-2534 Add new api "public StringDataValue getValue(RuleBasedCollator)" on StringDataValue. This method will return either the base DVDs for char datatypes or it will return collation sensitive DVD for char datatypes.
• depends upon: DERBY-2535 Make Locale available in DataValueFactory(DVF). This Locale object will be used to construct Collator object if the user has requested territory based collation.
• depends upon: DERBY-2583 At code generation time, look at collation type to determine what kind of DVD should get generated for character types.
• is depended upon by: DERBY-2340 Enable collation based ordering for VARCHAR, LONG VARCHAR and CLOB data types.
• is part of: DERBY-1478 Add built in language based ordering and like processing to Derby