[
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.
