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] Reopened: (DERBY-2722) Set correct collation type and derivation for result character string types from CHAR, VARCHAR and XMLSERIALIZE functions
Date Thu, 31 May 2007 18:44:15 GMT

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

Mamta A. Satoor reopened DERBY-2722:
------------------------------------


Army found following issue with the test contributed by me for XML type

Army wrote:
> +
> +      s.executeUpdate("set schema APP");
> +      checkLangBasedQuery(s, "SELECT XMLSERIALIZE(x as CHAR(10)) " +
> +             " FROM xmlTable, SYS.SYSTABLES WHERE " +
> +                     " XMLSERIALIZE(x as CHAR(10)) = TABLENAME",
> +                     null);

Just for the record, I think use of XMLSERIALIZE here will fail if the test
classpath does not include the required Xalan/JAXP classes (ex. Sun jdk15 with
no external XML jars).  It might be good to wrap this particular test inside of an

    if (XML.classpathMeetsXMLReqs())
     ....

where "XML" is junit/XML.java.  I think that's all that would be needed, though
I haven't actually tried it out...

> Set correct collation type and derivation for result character string types from CHAR,
VARCHAR and XMLSERIALIZE functions
> -------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2722
>                 URL: https://issues.apache.org/jira/browse/DERBY-2722
>             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: DERBY2722_set_collation_for_xmlserialize_char_varchar_functions_v1_diff.txt,
DERBY2722_set_collation_for_xmlserialize_char_varchar_functions_v1_stat.txt
>
>
> As per the wiki page http://wiki.apache.org/db-derby/BuiltInLanguageBasedOrderingDERBY-1478,
assign correct collation type for results of CHAR, VARCHAR and XMLSERIALIZE functions. The
rule as copied from the wiki page is as follows
> 6)CHAR, VARCHAR and XMLSERIALIZE functions do not look like they are defined in the SQL
spec. Their behavior can be defined as similar to CAST ie, the result character string of
CHAR/VARCHAR/XMLSERIALIZE will have the same collation as current schema's character set.
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.


Mime
View raw message