db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John H. Embretsen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2962) Change functional tests to use casts for System table queries to avoid conversion errors when run with TERRITORY_BASED collation
Date Thu, 02 Aug 2007 14:11:53 GMT

    [ https://issues.apache.org/jira/browse/DERBY-2962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12517271
] 

John H. Embretsen commented on DERBY-2962:
------------------------------------------

I observed that the change to miscerrors.sql in revision 558801 are causing test failures
in junit suites in some environments, see for example
http://dbtg.thresher.com/derby/test/Daily/jvm1.5/testing/Limited/testSummary-561847.html

miscerrors(org.apache.derbyTesting.functionTests.tests.lang.LangScripts)junit.framework.ComparisonFailure:
Output at line 69 expected:<...where CAST(SQL_TEXT [AS LONG VARCHAR) LIKE '%932432%' ]
                   ...> but was:<...where CAST(SQL_TEXT [ AS LONG VARCHAR) LIKE '%932432%']
                   ...>

I think, from reading logs from nightly regression tests and my own tests, that the order
of the two output rows from the statement

ij> select SQL_TEXT from syscs_diag.statement_cache where CAST(SQL_TEXT  AS LONG VARCHAR)
LIKE '%932432%';

varies between JVM versions (e.g. Sun JVM 1.6 has correct order according to the master file,
while JVM versions 1.4 and 1.5 have the opposite order), hence causing the failure.

Kathey, was it intentional to include an extra space in the above mentioned statement (between
"TEXT" and "AS")?
I think if the second space is removed, the result will contain one row instead of two, and
we won't see this diff any longer...


> Change functional tests to use casts for System table queries to avoid conversion errors
when run with TERRITORY_BASED collation
> --------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2962
>                 URL: https://issues.apache.org/jira/browse/DERBY-2962
>             Project: Derby
>          Issue Type: Task
>    Affects Versions: 10.4.0.0
>            Reporter: Kathey Marsden
>            Assignee: Kathey Marsden
>
> Many of the tests use system table queries which fail when run against a database with
TERRITORY_BASED collation with exceptions like:
> Caused by: org.apache.derby.client.am.SqlException: Comparisons between 'VARCHAR' and
'CHAR' are not supported.
> and can be seen when running lang/FullCollationTests.java
> It would be good to change the tests to use casts so that the queries succeed and the
tests can complete.

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