[DERBY-5147] Convert remaining store SQL tests into JUnit tests

• Type: Task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.8.1.2
• Fix Version/s: 10.10.2.1
• Component/s: SQL, Store, Test
• Labels: derby_triage10_10 gsoc11
• Urgency: Normal
• Issue & fix info: Newcomer
• Assignee: Houx Zhang
• Reporter: Tiago R. Espinha
• Created: 22/Mar/11 20:11
• Updated: 09/Sep/16 09:53
• Resolved: 06/Oct/14 20:11

Description

Some of the store SQL tests are still being ran on the harness. It would be interesting to have these converted over to JUnit as part of GSoC.

From checking storemats.runall, it seems the following tests are still left:
store/RowLockBasic.sql
store/TableLockBasic.sql
store/longColumn.sql
store/madhare.sql
store/updatelocksJDBC30.sql
store/updatelocks.sql

For whichever student ends up taking the GSoC project, please file individual JIRA issues for each of these test conversions.

Issue Links

• incorporates: DERBY-5977 Run storemore and possibly other store .sql tests in junit harness using ScriptTest mechanism.
• incorporates: DERBY-5127 Convert madhare.sql to JUnit
• incorporates: DERBY-5156 convert store/longColumn.sql into junit test case
• is depended upon by: DERBY-5091 Derby Test and Fix 2011 GSoC Project
• is related to: DERBY-6247 updatelocksJDBC30 test failing in nightly regression tests
• is related to: DERBY-5305 Convert store/updatelocks.sql to JUnit
• relates to: DERBY-5305 Convert store/updatelocks.sql to JUnit

Sub-Tasks

• Convert store/RowLockBasic.sql to junit: Closed
• Convert store/TableLockBasic.sql to junit: Closed