[DERBY-2723] Set correct collation type and derivation for result from user defined functions' that return character string type.

• Type: Improvement
• 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: 29/May/07 20:19
• Updated: 01/Jul/09 00:34
• Resolved: 14/Jun/07 10:36

Description

As per the wiki page http://wiki.apache.org/db-derby/BuiltInLanguageBasedOrderingDERBY-1478, assign correct collation type for results of user defined functions. The rule as copied from the wiki page is as follows
7)For user defined functions' that return character string type, the return type's collation will have the same collation as of the character set of the schema that the function is defined in. The collation derivation will be implicit.

Issue Links

• is part of: DERBY-2599 Set correct collation type and derivation on DataTypeDescriptor(DTD).
• relates to: DERBY-1478 Add built in language based ordering and like processing to Derby