'Empty right rows returned = 0' expected '... = 1' in lang/outerjoin.sql

• Key: DERBY-3261
• Type: Bug
• Status: Closed
• Resolution: Fixed
• Priority: Minor
• Assignee: Mamta A. Satoor
• Reporter: Ole Solberg
• Component/s: Test
• Affects Version/s: 10.4.1.3
• Fix Version/s: 10.3.3.0, 10.4.1.3

Environment

OS: Solaris 10 6/06 s10x_u2wos_09a X86 64bits - SunOS 5.10 Generic_118855-14
JVM: Sun Microsystems Inc. 1.6.0_02-b05

Description

See

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

Failure Details:
********* Diff file derbyall/derbylang/outerjoin.diff
*** Start: outerjoin jdk1.6.0_02 derbyall:derbylang 2007-12-06 22:22:35 ***
1737 del
< Empty right rows returned = 1
1737a1737
> Empty right rows returned = 0
Test Failed.
*** End: outerjoin jdk1.6.0_02 derbyall:derbylang 2007-12-06 22:22:43 ***

Comments

[Kathey Marsden]

This appears to be related to the following checkin:
r601830 | mamta | 2007-12-06 11:47:40 -0800 (Thu, 06 Dec 2007) | 14 lines

DERBY-3037

Mamta, could you take a look?

Kathey

[Mamta A. Satoor]

Olg, I tried going to http://clustra.norway.sun.com/~os136789/Apache/tinderbox_trunk16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/601833-derbyall_diff.txt to see the test results but looks like the url is incorrect. Could you please check if there is some typo in the url that you posted? thanks

[Ole Solberg]

Sorry, wrong (internal) link. This is the correct one @ thresher:

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

[Mamta A. Satoor]

I am working on invesitgating this failure. It appears that the problem is that the run time stats are getting cleared before they are collected. I hope to have a fix for this in couple days if not sooner,

[Mamta A. Satoor]

Checked in fix for this into trunk using revision 603823. The commit comments were as follow
DERBY-3261 and part of DERBY-3037

The outerjoin.sql was failing because the part of the runtime statistcis info was getting erased before LanguageResultSet.close() code collected it all. I moved the erasing of runtime stat code so that it happened once the stat was collected successfully.

In addition, I removed redundant code of closing and finishing the LanguageResultSet from EmbedResultSet.java because these steps happen as part of activation.close

I will merge this into 10.3 codeline and fire the tests there.

[Ole Solberg]

Fixed in trunk tinderbox run on svn 603823: http://dbtg.thresher.com/derby/test/tinderbox_trunk16/jvm1.6/testing/Limited/testSummary-603823.html

[Mamta A. Satoor]

Thanks Ole for checking that the fix actually worked with the tinerbox runs. I am running derbyall right now on 10.3 codeline and then will merge the fix there too. Junit tests ran fine on 10.3 on the merged codeline.

[Mamta A. Satoor]

Merged changes from trunk(603823) into 10.3 codeline(r603980). All the tests ran fine.