You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Mamta A. Satoor (JIRA)" <ji...@apache.org> on 2007/05/29 22:19:15 UTC
[jira] Created: (DERBY-2723) Set correct collation type and
derivation for result from user defined functions' that return character
string type.
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: 10.3.0.0
Reporter: Mamta A. Satoor
Assignee: Mamta A. Satoor
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.
[jira] Closed: (DERBY-2723) Set correct collation type and
derivation for result from user defined functions' that return character
string type.
Posted by "Mamta A. Satoor (JIRA)" <ji...@apache.org>.
[ 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: 10.3.0.0
Commited changes for this Jira entry using revision 547206
The commit comments are as follows
DERBY-2723
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: 10.3.0.0
> Reporter: Mamta A. Satoor
> Assignee: Mamta A. Satoor
> Fix For: 10.3.0.0
>
>
> 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.