[
https://issues.apache.org/jira/browse/DERBY-2724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mamta A. Satoor resolved DERBY-2724.
------------------------------------
Resolution: Fixed
Fix Version/s: 10.3.0.0
> Set correct collation type and derivation for result character string types
> from CURRENT ISOLATION, CURRENT_USER, SESSION_USER, SYSTEM_USER, CURRENT
> SCHEMA and CURRENT SQLID.
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2724
> URL: https://issues.apache.org/jira/browse/DERBY-2724
> 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
>
> Attachments:
> DERBY2724_set_collation_of_some_buiilt_in_functions_diff_v1.txt,
> DERBY2724_set_collation_of_some_buiilt_in_functions_stat_v1.txt
>
>
> As per the wiki page
> http://wiki.apache.org/db-derby/BuiltInLanguageBasedOrderingDERBY-1478,
> assign correct collation type for esult character string types from CURRENT
> ISOLATION, CURRENT_USER, SESSION_USER, SYSTEM_USER, CURRENT SCHEMA and
> CURRENT SQLID. The rule as copied from the wiki page is as follows
> 9)For CURRENT_USER, SESSION_USER, SYSTEM_USER, SQL spec Section 6.4 Syntax
> Rule 4 says that their collation type is the collation of character set
> SQL_IDENTIFIER. In Derby's case, that will mean, the collation of these
> functions will be UCS_BASIC. The collation derivation will be implicit.
> 10)CURRENT ISOLATION, CURRENT SCHEMA and CURRENT SQLID seem to be Derby
> specific functions, I didn't find them in the SQL spec. But in order to match
> their behavior with the other functions covered in 9) above, their return
> character string type's collation will be the collation of character set
> SQL_IDENTIFIER. 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.
