[
https://issues.apache.org/jira/browse/DERBY-4318?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12737942#action_12737942
]
Eranda Sooriyabandara commented on DERBY-4318:
----------------------------------------------
Hi Bryan,I found some changes with the change of the code.
This is the output when using,
suite.addTest(DatabasePropertyTestSetup.singleProperty(
TestConfiguration.defaultSuite(InbetweenTest.class)
"derby.language.statementCacheSize", "0"));
test_inbetween(org.apache.derbyTesting.functionTests.tests.lang.InbetweenTest)junit.framework.AssertionFailedError:
C
olumn value mismatch @ column '1', row 1:
Expected: >No open scans, etc<
Found: >No open scans, etc.
34 dependencies found In Memory Dependencies:
08264012-0122-d75c-d491-00000dd510ec, type PreparedStatement, is dependent
on SYSCS_SET_DATABASE_PROPERTY, type Alias
286cc01e-0122-d75c-d491-00000dd510ec, type PreparedStatement, is dependent
on getSchemas, type StoredPreparedStatement
560c80d5-0122-d75c-d491-00000dd510ec, type PreparedStatement, is dependent
on CONSISTENCYCHECKER, type Alias
582f8014-0122-d75c-d491-00000dd510ec, type PreparedStatement, is dependent
on SYSCS_SET_DATABASE_PROPERTY, type Alias
601a400f-0122-d75c-d491-00000dd510ec, type PreparedStatement, is dependent
on SYSCS_GET_DATABASE_PROPERTY, type Alias
61e8403f-0122-d75c-d491-00000dd510ec, type PreparedStatement, is dependent
on getTables, type StoredPreparedStatement
8a184042-0122-d75c-d491-00000dd510ec, type PreparedStatement, is dependent
on SYSCS_INPLACE_COMPRESS_TABLE, type Alias
da398044-0122-d75c-d491-00000dd510ec, type PreparedStatement, is dependent
on SYSDEPENDS, type Table
ea5bc046-0122-d75c-d491-00000dd510ec, type PreparedStatement, is dependent
on SYSROLES(ROLEID, ISDEF), type Table
ea5bc046-0122-d75c-d491-00000dd510ec, type PreparedStatement, is dependent
on SYSROLES_INDEX2, type Index
aliasID: 23ffc05b-0122-9ac2-fefa-00000dd510ec
aliasName: SYSCS_SET_DATABASE_PROPERTY
schemaID: c013800d-00fb-2649-07ec-000000134f30
javaClassName: org.apache.derby.catalog.SystemProcedures
aliasType: P
nameSpace: P
systemAlias: false
aliasInfo: SYSCS_SET_DATABASE_PROPERTY(IN KEY VARCHAR(128),IN VALUE
VARCHAR(32672)) LANGUAGE JAVA PARAMETER STYLE JAVA M
ODIFIES SQL DATA
, type Alias, provides for 08264012-0122-d75c-d491-00000dd510ec, type
PreparedStatement
aliasID: 23ffc05b-0122-9ac2-fefa-00000dd510ec
aliasName: SYSCS_SET_DATABASE_PROPERTY
schemaID: c013800d-00fb-2649-07ec-000000134f30
javaClassName: org.apache.derby.catalog.SystemProcedures
aliasType: P
nameSpace: P
systemAlias: false
aliasInfo: SYSCS_SET_DATABASE_PROPERTY(IN KEY VARCHAR(128),IN VALUE
VARCHAR(32672)) LANGUAG<
at
org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1095)
at
org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1007)
at
org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:895)
at
org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:833)
at
org.apache.derbyTesting.functionTests.tests.lang.InbetweenTest.test_inbetween(InbetweenTest.java:700)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at
org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:109)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:23)
at junit.extensions.TestSetup.run(TestSetup.java:27)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:23)
at junit.extensions.TestSetup.run(TestSetup.java:27)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
Output when using the code,
suite.addTest(TestConfiguration.defaultSuite(InbetweenTest.class));
1)
test_inbetween(org.apache.derbyTesting.functionTests.tests.lang.InbetweenTest)junit.framework.AssertionFailedError:
C
olumn value mismatch @ column '1', row 1:
Expected: >No open scans, etc<
Found: >No open scans, etc.
30 dependencies found In Memory Dependencies:
004b0019-0122-d761-1a5b-00000dd510ec, type PreparedStatement, is dependent
on getSchemas, type StoredPreparedStatement
0d0600d0-0122-d761-1a5b-00000dd510ec, type PreparedStatement, is dependent
on CONSISTENCYCHECKER, type Alias
601a400f-0122-d761-1a5b-00000dd510ec, type PreparedStatement, is dependent
on SYSCS_SET_DATABASE_PROPERTY, type Alias
61e8403f-0122-d761-1a5b-00000dd510ec, type PreparedStatement, is dependent
on SYSDEPENDS, type Table
82080041-0122-d761-1a5b-00000dd510ec, type PreparedStatement, is dependent
on SYSROLES(ROLEID, ISDEF), type Table
82080041-0122-d761-1a5b-00000dd510ec, type PreparedStatement, is dependent
on SYSROLES_INDEX2, type Index
c1c9803d-0122-d761-1a5b-00000dd510ec, type PreparedStatement, is dependent
on SYSCS_INPLACE_COMPRESS_TABLE, type Alias
c99d403a-0122-d761-1a5b-00000dd510ec, type PreparedStatement, is dependent
on getTables, type StoredPreparedStatement
aliasID: 23ffc05b-0122-9ac2-fefa-00000dd510ec
aliasName: SYSCS_SET_DATABASE_PROPERTY
schemaID: c013800d-00fb-2649-07ec-000000134f30
javaClassName: org.apache.derby.catalog.SystemProcedures
aliasType: P
nameSpace: P
systemAlias: false
aliasInfo: SYSCS_SET_DATABASE_PROPERTY(IN KEY VARCHAR(128),IN VALUE
VARCHAR(32672)) LANGUAGE JAVA PARAMETER STYLE JAVA M
ODIFIES SQL DATA
, type Alias, provides for 601a400f-0122-d761-1a5b-00000dd510ec, type
PreparedStatement
aliasID: 3a7f0048-0122-d761-1a5b-00000dd510ec
aliasName: CONSISTENCYCHECKER
schemaID: 80000000-00d2-b38f-4cda-000a0a412c00
javaClassName:
org.apache.derbyTesting.functionTests.util.T_ConsistencyChecker
aliasType: F
nameSpace: F
systemAlias: false
aliasInfo: runConsistencyChecker() RETURNS VARCHAR(2000) LANGUAGE JAVA
PARAMETER STYLE JAVA READS SQL DATA CALLED ON NUL
L INPUT
, type Alias, provides for 0d0600d0-0122-d761-1a5b-00000dd510ec, type
PreparedStatement
SPSDescriptor:
name: SYS.getTables
uuid: 41588035-0122-9ac2-fefa-00000dd510ec
text: SELECT CAST (<
at
org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1095)
at
org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:1007)
at
org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:895)
at
org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:833)
at
org.apache.derbyTesting.functionTests.tests.lang.InbetweenTest.test_inbetween(InbetweenTest.java:695)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at
org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:109)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:23)
at junit.extensions.TestSetup.run(TestSetup.java:27)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> convert inbetween.sql to JUNIT
> ------------------------------
>
> Key: DERBY-4318
> URL: https://issues.apache.org/jira/browse/DERBY-4318
> Project: Derby
> Issue Type: Improvement
> Components: Test
> Reporter: Eranda Sooriyabandara
> Assignee: Eranda Sooriyabandara
> Priority: Minor
> Attachments: inbetween.junit, InbetweenTest.diff, InbetweenTest.diff
>
>
> conversion of inbetween.sql to JUNIT
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
