[DERBY-3479] Changed/unexpected query plan when running test 'lang/predicatePushdown.sql'

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.4.1.3
• Fix Version/s: 10.4.1.3
• Component/s: Test

Environment

OS: Solaris 10 6/06 s10x_u2wos_09a X86 64bits - SunOS 5.10 Generic_118855-14
JVM: Sun Microsystems Inc., java version "1.6.0_04", Java(TM) SE Runtime Environment (build 1.6.0_04-b12), Java HotSpot(TM) Client VM (build 10.0-b19, mixed mode)

• Bug behavior facts: Regression Test Failure
• Assignee: A B
• Reporter: Ole Solberg
• Created: 28/Feb/08 20:06
• Updated: 29/Jun/09 22:58
• Resolved: 06/Mar/08 22:50

Description

Seen in tinderbox since r631930.

See e.g. http://dbtg.thresher.com/derby/test/tinderbox_trunk16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/631932-derbyall_diff.txt :

• • • Start: predicatePushdown jdk1.6.0_04 derbyall:derbylang 2008-02-28 14:02:49 ***
      9285 del
      < Rows seen from the left = 20
      9285a9285
      > Rows seen from the left = 10
      9297 del
      < Rows seen from the right = 20
      9297a9297
      > Rows seen from the right = 10
      9299 del
      < Rows returned = 20
      9299a9299
      > Rows returned = 10
      .
      .
      .

Issue Links

• is related to: DERBY-1902 Intermittent failures in predicatePushdown.sql
• is related to: DERBY-2911 Implement a buffer manager using java.util.concurrent classes