Mike, the CollationTest has few negative test cases. I looked through the
stack trace you provided and it happens for following test in CollationTest
assertStatementError("42818", s, "SELECT ID, NAME FROM
APP.CUSTOMERWHERE NAME <= 'Smith' ");
And hence, this particular exception you are seeing in derby.log is
expected.
Mamta
On 5/12/07, Mike Matrigali <[EMAIL PROTECTED]> wrote:
I would like to run just the CollationTest, junit test.
I tried:
java junit.textui.TestRunner
org.apache.derbyTesting.functionTests.tests.lang.CollationTest
This ran and reported:
+ java junit.textui.TestRunner
org.apache.derbyTesting.functionTests.tests.lang.
CollationTest
........
Time: 48.9
OK (8 tests)
making me think everything is good.
But when I go look at derby.log I see that there are a bunch of
exceptions, like the following. :
2007-05-12 09:04:20.318 GMT Thread[main,5,main] (XID = 145), (SESSIONID
= 1), (D
ATABASE = singleUse/oneuse3), (DRDAID = null), Failed Statement is:
SELECT ID, N
AME FROM APP.CUSTOMER WHERE NAME <= 'Smith' ^M
ERROR 42818: Por≤wnania mi?dzy 'VARCHAR' i 'CHAR' nie s? obs?ugiwane.^M
at
org.apache.derby.iapi.error.StandardException.newException(StandardExcept
ion.java:316)^M
at
org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindCompar
isonOperator(BinaryComparisonOperatorNode.java:250)^M
at
org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpres
sion(BinaryComparisonOperatorNode.java:213)^M
at
org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(SelectNode.j
ava:456)^M
at
org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(DMLSta
tementNode.java:227)^M
at
org.apache.derby.impl.sql.compile.DMLStatementNode.bind(DMLStatementNode.
java:140)^M
at
org.apache.derby.impl.sql.compile.CursorNode.bindStatement(CursorNode.jav
a:236)^M
at
org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.ja
va:314)^M
at
org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:
88)^M
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareIn
ternalStatement(GenericLanguageConnectionContext.java:742)^M
at
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:567
)^M
at
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:516
)^M
at
org.apache.derbyTesting.junit.BaseJDBCTestCase.assertStatementError(BaseJ
DBCTestCase.java:701)^M
at
org.apache.derbyTesting.functionTests.tests.lang.CollationTest.testPolish
Collation(CollationTest.java:158)^M
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)^M
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
:64)^M
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI
mpl.java:43)^M
at java.lang.reflect.Method.invoke(Method.java:615)^M
at junit.framework.TestCase.runTest(TestCase.java:154)^M
at junit.framework.TestCase.runBare(TestCase.java:127)^M
at
org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)^
M
at junit.framework.TestResult$1.protect(TestResult.java:106)^M
at junit.framework.TestResult.runProtected(TestResult.java:124)^M
at junit.framework.TestResult.run(TestResult.java:109)^M
at junit.framework.TestCase.run(TestCase.java:118)^M
at junit.framework.TestSuite.runTest(TestSuite.java:208)^M
at junit.framework.TestSuite.run(TestSuite.java:203)^M
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)^M
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)^M
at junit.framework.TestResult.runProtected(TestResult.java:124)^M
at junit.extensions.TestSetup.run(TestSetup.java:23)^M
at junit.framework.TestSuite.runTest(TestSuite.java:208)^M
at junit.framework.TestSuite.run(TestSuite.java:203)^M
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)^M
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)^M
at junit.framework.TestResult.runProtected(TestResult.java:124)^M
at junit.extensions.TestSetup.run(TestSetup.java:23)^M
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)^M
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)^M
at junit.framework.TestResult.runProtected(TestResult.java:124)^M
at junit.extensions.TestSetup.run(TestSetup.java:23)^M
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)^M
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)^M
at junit.framework.TestResult.runProtected(TestResult.java:124)^M
at junit.extensions.TestSetup.run(TestSetup.java:23)^M
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)^M
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)^M
at junit.framework.TestResult.runProtected(TestResult.java:124)^M
at junit.extensions.TestSetup.run(TestSetup.java:23)^M
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)^M
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)^M
at junit.framework.TestResult.runProtected(TestResult.java:124)^M
at junit.extensions.TestSetup.run(TestSetup.java:23)^M
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)^M
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)^M
at junit.framework.TestResult.runProtected(TestResult.java:124)^M
at junit.extensions.TestSetup.run(TestSetup.java:23)^M
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)^M
