db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "BuiltInLanguageBasedOrderingDERBY-1478" by MamtaSatoor
Date Fri, 01 Jun 2007 19:03:49 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by MamtaSatoor:
http://wiki.apache.org/db-derby/BuiltInLanguageBasedOrderingDERBY-1478

The comment on the change is:
Collation of return value of CURRENT ISOLATION same as CURRENT SCHEMA.

------------------------------------------------------------------------------
  
  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. 
+ 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. 
  
  11)Aggregate operators involving all character string type operands(Concatenation, CASE,
NULLIF, COALESCE) will follow SQL spec Section 9.3 Data types of results of aggregations.
In other words, if all the operands have the same collation associated with them, then the
collation of result character string type will be same and the collation derivation will be
implicit. But if operands of different collation types are involved, then the result character
string type will have collation derivation of none. 
  

Mime
View raw message