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] Closed: (DERBY-2723) Set correct collation type and derivation for result from user defined functions' that return character string type.
Date Thu, 14 Jun 2007 10:38:26 GMT

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

Mamta A. Satoor closed DERBY-2723.

       Resolution: Fixed
    Fix Version/s:

Commited changes for this Jira entry using revision 547206

The commit comments are as follows
The RoutineAliasInfo for user defined function stores the collation infomraiton about it's
return type and parameters if they happen to be character string type. This commit makes sure
that for those DTDs, we use the collation of the schema in which the function is getting defined.
The existing code creates these DTDs at the parse time but the SchemaDescriptor for the function
is not available at that stage. To get around this, at the bind time, we check in CreateAliasNode
if we are dealing with any character string types in the function definition. If yes, then
we create new DTDs which are based on the ones created during the parse time, but we set the
correct collation informaiton on them. And then we recreate a new RoutineAliasInfo using the
infomration from parse time RoutineAliasInfo and the newly created DTDs. I have added a CREATE
FUNCTION using character string types in CollationTest. Code to use this collation information
correctly when the function gets used inside a sql will go in as a separate patch.

>  Set correct collation type and derivation for result from user defined functions' that
return character string type.
> ---------------------------------------------------------------------------------------------------------------------
>                 Key: DERBY-2723
>                 URL: https://issues.apache.org/jira/browse/DERBY-2723
>             Project: Derby
>          Issue Type: New Feature
>          Components: SQL
>    Affects Versions:
>            Reporter: Mamta A. Satoor
>            Assignee: Mamta A. Satoor
>             Fix For:
> 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. 

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

View raw message