[
https://issues.apache.org/jira/browse/DERBY-2750?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12517108
]
Kathey Marsden commented on DERBY-2750:
---------------------------------------
Hi Ravinder,
It is looking close, but hit a few issues:
When I run the test I get: Perhaps you need to cleanup the database before
running.
junit.framework.AssertionFailedError: expected:<42Y07> but
was:<java.sql.SQLException: Schema 'SESSION' does not exist>
at junit.framework.Assert.fail(Assert.java:47)
at junit.framework.Assert.failNotEquals(Assert.java:282)
at junit.framework.Assert.assertEquals(Assert.java:64)
at junit.framework.Assert.assertEquals(Assert.java:71)
at
org.apache.derbyTesting.functionTests.tests.lang.DeclareGlobalTempTableJavaTest.testDerby1706(DeclareGlobalTempTableJavaTest.java:82)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)
at java.lang.reflect.Method.invoke(Method.java:391)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at
org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:95)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at
org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
at
org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
2) Please remove the test from the old suite.
3) In suite() please use TestConfiguration.embeddedSuite(Class) instead of new
TestSuite() I think this will help ensure proper cleanup after the test runs.
4) Can you put casts in your system table queries so it can be run with
collation, e.g.
select count(*) from sys.systables where CAST(tablename AS VARCHAR(128)) like
'T2'
Thanks for tackling this mammoth test.
Kathey
> Convert lang/declareGlobalTempTableJava.java to JUnit
> -----------------------------------------------------
>
> Key: DERBY-2750
> URL: https://issues.apache.org/jira/browse/DERBY-2750
> Project: Derby
> Issue Type: Test
> Components: Test
> Affects Versions: 10.3.0.0
> Reporter: Ravinder Reddy
> Assignee: Ravinder Reddy
> Attachments: DeclareGlobalTempTableJavaTest.java,
> DERBY-2750.diff-01-08-07, DERBY-2750.diff-2-7-7, DERBY-2750.diff-final,
> DERBY-2750.diff.final, derby-2750_diff.txt, derby-2750_new_fixture.txt
>
>
> Unchecking 10.3. This is not necessary for 10.3. If it does get implemented
> before 10.3, fixin can be set when the issue gets resolved.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
