[DERBY-5099] PrepareStatementTest depends on ordering of test cases

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.8.1.2
• Fix Version/s: 10.8.1.2
• Component/s: Test
• Bug behavior facts: Regression Test Failure
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 08/Mar/11 11:57
• Updated: 30/Jun/11 09:21
• Resolved: 08/Mar/11 12:07

Description

PrepareStatementTest contains two test cases for DERBY-614: testSplitQRYDTABlock and testServerStatementCleanUp.

testServerStatementCleanUp uses a table created by testSplitQRYDTABlock, so if testServerStatementCleanUp runs before testSplitQRYDTABlock, the test will fail with the following error message:

java.sql.SQLSyntaxErrorException: Table/View 'JIRA614' does not exist.

Seen a couple of times in the nightly tests. For example here: http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.7/testing/testlog/vista-64/1076682-suitesAll_diff.txt

Issue Links

• relates to: DERBY-614 Execution failed because of a Distributed Protocol Error