db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eranda Sooriyabandara (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4318) convert inbetween.sql to JUNIT
Date Sat, 01 Aug 2009 19:38:14 GMT

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


Mime
View raw message