Set correct collation type and derivation for result character string types
from 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
As per the wiki page
http://wiki.apache.org/db-derby/BuiltInLanguageBasedOrderingDERBY-1478, assign
correct collation type for esult character string types from 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 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.
