db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Houx Zhang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5301) Convert store/TableLockBasic.sql to junit
Date Sat, 27 Aug 2011 15:26:37 GMT

    [ https://issues.apache.org/jira/browse/DERBY-5301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13092314#comment-13092314
] 

Houx Zhang commented on DERBY-5301:
-----------------------------------

Hi,Bryan. In my PC, the test just ran with one failure.

D:\derby\test>java junit.textui.TestRunner org.apache.derbyTesting.functionTests
.tests.store.TableLockBasicTest
..............F..............F
Time: 6.407
There were 2 failures:
1) testRTSOutput(org.apache.derbyTesting.functionTests.tests.store.TableLockBasi
cTest)junit.framework.AssertionFailedError: Column value mismatch @ column '1',
row 1:
    Expected: >Statement Name:
 null
Statement Text:
 select * from rts with cs
Parse Time: 0
Bind Time: 0
Optimize Time: 0
Generate Time: 0
Compile Time: 0
Execute Time: 0
Begin Compilation Timestamp : null
End Compilation Timestamp : null
Begin Execution Timestamp : null
End Execution Timestamp : null
Statement Execution Plan Text:
Table Scan ResultSet for RTS at read committed isolation level using instantaneo
us share row locking chosen by the optimizer (Actual locking used: table level l
ocking.)
Number of opens = 1
Rows seen = 1
Rows filtered = 0
Fetch Size = 16
 constructor time (milliseconds) = 0
 open time (milliseconds) = 0
 next time (milliseconds) = 0
 close time (milliseconds) = 0
 next time in milliseconds/row = 0

scan information:
 Bit set of columns fetched=All
 Number of columns fetched=1
 Number of pages visited=1
 Number of rows qualified=1
 Number of rows visited=1
 Scan type=heap
 start position:
  null
 stop position:
  null
 qualifiers:
  None
optimizer estimated row count:            6.00
optimizer estimated cost:          100.40<
    Found:    >Statement Name:
        null
Statement Text:
        select * from rts with cs
Parse Time: 0
Bind Time: 0
Optimize Time: 0
Generate Time: 0
Compile Time: 0
Execute Time: 0
Begin Compilation Timestamp : null
End Compilation Timestamp : null
Begin Execution Timestamp : null
End Execution Timestamp : null
Statement Execution Plan Text:
Table Scan ResultSet for RTS at read committed isolation level using instantaneo
us share row locking chosen by the optimizer (Actual locking used: table level l
ocking.)
Number of opens = 1
Rows seen = 1
Rows filtered = 0
Fetch Size = 16
        constructor time (milliseconds) = 0
        open time (milliseconds) = 0
        next time (milliseconds) = 0
        close time (milliseconds) = 0
        next time in milliseconds/row = 0

scan information:
        Bit set of columns fetched=All
        Number of columns fetched=1
        Number of pages visited=1
        Number of rows qualified=1
        Number of rows visited=1
        Scan type=heap
        start position:
                null
        stop position:
                null
        qualifiers:
                None
        optimizer estimated row count:            6.00
        optimizer estimated cost:          100.40<
        at org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:121
3)
        at org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:112
5)
        at org.apache.derbyTesting.junit.JDBC.assertFullResultSetMinion(JDBC.jav
a:1012)
        at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:935)

        at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:892)

        at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:850)

        at org.apache.derbyTesting.functionTests.tests.store.TableLockBasicTest.
testRTSOutput(TableLockBasicTest.java:500)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:
112)
        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 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)
2) testRTSOutput(org.apache.derbyTesting.functionTests.tests.store.TableLockBasi
cTest)junit.framework.AssertionFailedError: Column value mismatch @ column '1',
row 1:
    Expected: >Statement Name:
 null
Statement Text:
 select * from rts with cs
Parse Time: 0
Bind Time: 0
Optimize Time: 0
Generate Time: 0
Compile Time: 0
Execute Time: 0
Begin Compilation Timestamp : null
End Compilation Timestamp : null
Begin Execution Timestamp : null
End Execution Timestamp : null
Statement Execution Plan Text:
Table Scan ResultSet for RTS at read committed isolation level using instantaneo
us share row locking chosen by the optimizer (Actual locking used: table level l
ocking.)
Number of opens = 1
Rows seen = 1
Rows filtered = 0
Fetch Size = 16
 constructor time (milliseconds) = 0
 open time (milliseconds) = 0
 next time (milliseconds) = 0
 close time (milliseconds) = 0
 next time in milliseconds/row = 0

scan information:
 Bit set of columns fetched=All
 Number of columns fetched=1
 Number of pages visited=1
 Number of rows qualified=1
 Number of rows visited=1
 Scan type=heap
 start position:
  null
 stop position:
  null
 qualifiers:
  None
optimizer estimated row count:            6.00
optimizer estimated cost:          100.40<
    Found:    >Statement Name:
        SQL_CURLH000C3
Statement Text:
        select * from rts with cs
Parse Time: 0
Bind Time: 0
Optimize Time: 0
Generate Time: 0
Compile Time: 0
Execute Time: 0
Begin Compilation Timestamp : null
End Compilation Timestamp : null
Begin Execution Timestamp : null
End Execution Timestamp : null
Statement Execution Plan Text:
Table Scan ResultSet for RTS at read committed isolation level using instantaneo
us share row locking chosen by the optimizer (Actual locking used: table level l
ocking.)
Number of opens = 1
Rows seen = 1
Rows filtered = 0
Fetch Size = 16
        constructor time (milliseconds) = 0
        open time (milliseconds) = 0
        next time (milliseconds) = 0
        close time (milliseconds) = 0
        next time in milliseconds/row = 0

scan information:
        Bit set of columns fetched=All
        Number of columns fetched=1
        Number of pages visited=1
        Number of rows qualified=1
        Number of rows visited=1
        Scan type=heap
        start position:
                null
        stop position:
                null
        qualifiers:
                None
        optimizer estimated row count:            6.00
        optimizer estimated cost:          100.40<
        at org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:121
3)
        at org.apache.derbyTesting.junit.JDBC.assertRowInResultSet(JDBC.java:112
5)
        at org.apache.derbyTesting.junit.JDBC.assertFullResultSetMinion(JDBC.jav
a:1012)
        at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:935)

        at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:892)

        at org.apache.derbyTesting.junit.JDBC.assertFullResultSet(JDBC.java:850)

        at org.apache.derbyTesting.functionTests.tests.store.TableLockBasicTest.
testRTSOutput(TableLockBasicTest.java:500)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:
112)
        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 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 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)

FAILURES!!!
Tests run: 28,  Failures: 2,  Errors: 0


D:\derby\test>

> Convert store/TableLockBasic.sql  to junit
> ------------------------------------------
>
>                 Key: DERBY-5301
>                 URL: https://issues.apache.org/jira/browse/DERBY-5301
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Test
>            Reporter: Houx Zhang
>            Assignee: Houx Zhang
>              Labels: gsoc2011
>         Attachments: 5301-1-part.patch, junit.out
>
>


--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message