Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <1566082954.1141220986221.JavaMail.jira@ajax.apache.org>
Date: Wed, 1 Mar 2006 14:49:46 +0100 (CET)
From: "Andreas Korneliussen (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-1070) add tests for holdable SUR
In-Reply-To: <46805205.1141209252470.JavaMail.jira@ajax.apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

     [ http://issues.apache.org/jira/browse/DERBY-1070?page=all ]

Andreas Korneliussen updated DERBY-1070:
----------------------------------------

    Attachment: DERBY-1070.diff
                DERBY-1070.stat

Adding a new junit test called jdbcapi/HoldabilityTest.junit. There are 7 testcases, all for scrollable resultsets.

The testcases creates different states in the scan controllers  (init, in progress, or ended), and verifies that after a commit, the scan can continue, and the resultset is scrollable. For updatable resultset, it also verifies updatability.

One of the testcases is also written to provoke an error situation in holdable scrollable updatable resultsets. It provokes a truncate of pages which the resultset have read rows from, and a situation which will cause the SUR to update another row if not DERBY-1067 gets implemented correctly.  The tests are adaptive to updatability, meaning that if SUR is not implemented for the framework being tested, updatability will not be tested. This can later be changed when updatability of scrollable resultset is fully supported in Derby.

One of the testcases fails, due to DERBY-1058.

Expected result when running in embedded:

java org.apache.derbyTesting.functionTests.harness.RunTest jdbcapi/HoldabilityTest.junit 

*** Start: HoldabilityTest jdk1.4.2_02 2006-03-01 14:42:35 ***
0 add
> ..E.....
> There was 1 error:
> 1) testHeldScrollableResultSetScanInProgress(org.apache.derbyTesting.functionTests.tests.jdbcapi.HoldabilityTest)ERROR XSCB8: The btree conglomerate 1,141,220,557,702 is closed.
> FAILURES!!!
> Tests run: 7,  Failures: 0,  Errors: 1
Test Failed.
*** End:   HoldabilityTest jdk1.4.2_02 2006-03-01 14:42:51 ***

No errors expected if DERBY-1058 gets fixed.


> add tests for holdable SUR
> --------------------------
>
>          Key: DERBY-1070
>          URL: http://issues.apache.org/jira/browse/DERBY-1070
>      Project: Derby
>         Type: Sub-task
>     Reporter: Andreas Korneliussen
>     Assignee: Andreas Korneliussen
>  Attachments: DERBY-1070.diff, DERBY-1070.stat
>


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira