Julius Stroffek wrote:
Hi All,
I am getting this failure during my junit test run on trunk...
1)
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%'] ...>
at
org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:100)
at
org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:124)
at
org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:95)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
Anybody else seeing this? I do not see this failure on regular
thinderbox and daily test runs...
I changed this test but am not seeing the failure myself. I did see it
on one of the IBM runs, so it is not just you. I took out the
extraneous space in the test and updated the master. Could you try the
attached patch and see if it fixes your problem?
Kathey
Index:
java/testing/org/apache/derbyTesting/functionTests/tests/lang/miscerrors.sql
===================================================================
---
java/testing/org/apache/derbyTesting/functionTests/tests/lang/miscerrors.sql
(revision 559646)
+++
java/testing/org/apache/derbyTesting/functionTests/tests/lang/miscerrors.sql
(working copy)
@@ -54,4 +54,4 @@
SELECT * FROM BILL932432;
SELECT 932432;
-select SQL_TEXT from syscs_diag.statement_cache where CAST(SQL_TEXT AS LONG
VARCHAR) LIKE '%932432%';
+select SQL_TEXT from syscs_diag.statement_cache where CAST(SQL_TEXT AS LONG
VARCHAR) LIKE '%932432%';
Index: java/testing/org/apache/derbyTesting/functionTests/master/miscerrors.out
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/master/miscerrors.out
(revision 559646)
+++ java/testing/org/apache/derbyTesting/functionTests/master/miscerrors.out
(working copy)
@@ -63,9 +63,8 @@
ERROR 42X05: Table/View 'BILL932432' does not exist.
ij> SELECT 932432;
ERROR 42X01: Syntax error: Encountered "<EOF>" at line 1, column 13.
-ij> select SQL_TEXT from syscs_diag.statement_cache where CAST(SQL_TEXT AS
LONG VARCHAR) LIKE '%932432%';
+ij> select SQL_TEXT from syscs_diag.statement_cache where CAST(SQL_TEXT AS
LONG VARCHAR) LIKE '%932432%';
SQL_TEXT
--------------------------------------------------------------------------------------------------------------------------------
select SQL_TEXT from syscs_diag.statement_cache where CAST(SQL_TEXT AS LONG
VARCHAR) LIKE '%932432%'
-select SQL_TEXT from syscs_diag.statement_cache where CAST(SQL_TEXT AS LONG
VARCHAR) LIKE '%932432%'
ij>
\ No newline at end of file
