[DERBY-4378] Create test cases for MultiProbeTableScanResultSet with duplicates in the probe list

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.6.1.0
• Fix Version/s: 10.11.1.1
• Component/s: Test
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 16/Sep/09 15:41
• Updated: 03/Sep/14 08:31
• Resolved: 26/Jul/13 08:30

Description

See the coverage report for MultiProbeTableScanResultSet: http://dbtg.foundry.sun.com/derby/test/coverage/jvm1.6/sol/suitesAll82289/_files/401.html

There are three red lines (lines that are not exercised by the tests).

Adding a test case where the probe list contains duplicate values will exercise the first red line in getNextProbeValue().

If the duplicates are also the last elements in the probe list, the other two red lines (in getNextProbeValue() and reopenScanController()) will be exercised too.

Note that MultiProbeTableScanResultSet will sort the probe list, so the last element in the probe list is not necessarily identical to the last element in the query's IN list. It will also remove duplicates at compile time, if possible, so the IN list needs to contain parameters.

Issue Links

• is related to: DERBY-4376 Simple select runs forever