<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6001.18248" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=859464917-22062009><FONT face="Lucida Sans" color=#000080
size=2>So, we have:</FONT></SPAN></DIV>
<UL>
<LI><SPAN class=859464917-22062009><FONT face="Lucida Sans" color=#000080
size=2> 6 failures on MySQL, all of them 'expected query did not
occur';</FONT></SPAN></LI>
<LI><SPAN class=859464917-22062009><FONT face="Lucida Sans" color=#000080
size=2> 4 failures on PostgreSQL, 3 of which are 'expected query did not
occur', but different than MySQL, and an error in testNullCollation;
and</FONT></SPAN></LI>
<LI><SPAN class=859464917-22062009><FONT face="Lucida Sans" color=#000080
size=2> 1 failure on Oracle, in testNullCollation.</FONT></SPAN></LI></UL>
<DIV><SPAN class=859464917-22062009><FONT face="Lucida Sans" color=#000080
size=2>I don't view any of these as serious. The 'expected query did not occur'
probably just requires someone to fix a hard-coded string in a test, and
testNullCollation is fairly esoteric unless you're writing queries that sort
null values and need to run on more than one DBMS.</FONT></SPAN></DIV>
<DIV><SPAN class=859464917-22062009><FONT face="Lucida Sans" color=#000080
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=859464917-22062009><FONT face="Lucida Sans" color=#000080
size=2>But, it's irritating to have test exceptions. I'll look into the MySQL
exceptions (since it's probably me that introduced them) and testNullCollation.
Can someone look into the PostgreSQL errors?</FONT></SPAN></DIV>
<DIV><SPAN class=859464917-22062009><FONT face="Lucida Sans" color=#000080
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=859464917-22062009><FONT face="Lucida Sans" color=#000080
size=2>Julian</FONT></SPAN></DIV><FONT face="Lucida Sans" color=#000080
size=2></FONT><BR>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of
</B>kcheng<BR><B>Sent:</B> Friday, June 12, 2009 11:04 PM<BR><B>To:</B>
Mondrian developer mailing list<BR><B>Subject:</B> Re: [Mondrian] Failed tests
on hudson<BR></FONT><BR></DIV>
<DIV></DIV>Hi all,<BR> I run
the unit test again with PostgreSQL 8.3 and I got 4 failures, the
failures in PostgreSQL are totally different from MySQL( There are 6 failures
with MySQL) . Below are the failures in
PostgreSQL<BR><BR> [java] 1)
queryTest_96a0ffa3a8ce52f5_GENERATE.xml(mondrian.test.comp.ResultComparatorTest)junit.framework.ComparisonFailure:
Row tuple 32 member 0; ; expected=[Promotions].[All Promotions].[Sale
Winners]; actual=[Promotions].[All Promotions].[Sales
Days]<BR> [java] Query: select
{Generate([Time].[Year].Members, {[Time].CurrentMember,
[Time].CurrentMember.Children})} ON COLUMNS,<BR>
[java] [Promotions].[All Promotions].Children ON
ROWS<BR> [java] from
[Sales]<BR> [java] where [Measures].[Unit
Sales]<BR><BR> [java] 2)
queryTest_3b6a02511345dcc.xml(mondrian.test.comp.ResultComparatorTest)junit.framework.ComparisonFailure:
Row tuple 32 member 0; ; expected=[Promotions].[All Promotions].[Sale
Winners]; actual=[Promotions].[All Promotions].[Sales
Days]<BR> [java] Query: select {[Measures].[Store
Sales]} ON COLUMNS,<BR> [java]
Generate([Product].[All Products].[Drink].Children,
Crossjoin([Promotions].Children, {[Product].CurrentMember})) ON
ROWS<BR> [java] from
[Sales]<BR><BR> [java] 3)
testGrandNonVisualColumn(mondrian.test.clearview.GrandTotalTest)junit.framework.ComparisonFailure:
expected:<...ll Promotions].[Sale[ Winners], [Measures].[Unit
Sales]}<BR> [java] 4)
testNullCollation(mondrian.test.CompatibilityTest)junit.framework.ComparisonFailure:
Expected:<BR><BR><BR><BR><BR clear=all>Thanks,<BR>kcheng<BR><BR><BR>
<DIV class=gmail_quote>On Fri, Jun 12, 2009 at 6:53 PM, Eric McDermid <SPAN
dir=ltr><<A
href="mailto:mcdermid@stonecreek.com">mcdermid@stonecreek.com</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV>I believe Hudson is running against MySQL, so if you're running against
another RDBMS that might be the reason. I do get the same 6
failures on my synced-to-latest sandbox (MySQL 5.1.35 on OSX 10.5.7).
<DIV><BR></DIV>
<DIV>Haven't looked into the failures yet, as I'm just starting to move code
over from a Mondrian 2.4-based project.
<DIV>
<DIV><BR></DIV>
<DIV> -- Eric</DIV>
<DIV><BR></DIV>
<DIV>
<DIV>
<DIV>On Jun 12, 2009, at 2:57 PM, Matt Campbell wrote:</DIV><BR>
<BLOCKQUOTE type="cite">We've had 6 failed tests in hudson for a very long
time. These tests don't fail in my environment. Does anyone
know why they're failing on hudson?
<DIV><BR></DIV>
<DIV><SPAN
style="FONT-SIZE: 11px; FONT-FAMILY: Verdana; BORDER-COLLAPSE: collapse">
<TABLE
style="BORDER-RIGHT: rgb(187,187,187) 1px solid; BORDER-TOP: rgb(187,187,187) 1px solid; MARGIN-TOP: 4px; FONT-SIZE: 11px; BORDER-LEFT: rgb(187,187,187) 1px solid; WIDTH: 1003px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; WHITE-SPACE: nowrap; BORDER-COLLAPSE: collapse">
<TBODY>
<TR>
<TD
style="PADDING-RIGHT: 4px; BORDER-TOP: rgb(187,187,187) 1px solid; PADDING-LEFT: 4px; FONT-WEIGHT: bold; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: top; PADDING-TOP: 4px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; BACKGROUND-COLOR: rgb(240,240,240)"><A
style="DISPLAY: block; COLOR: black; TEXT-DECORATION: none"
href="http://ci.pentaho.com/job/mondrian/lastBuild/testReport/#"
target=_blank>Test Name<SPAN
style="COLOR: black; TEXT-DECORATION: none"> </SPAN></A></TD>
<TD
style="PADDING-RIGHT: 4px; BORDER-TOP: rgb(187,187,187) 1px solid; PADDING-LEFT: 4px; FONT-WEIGHT: bold; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: top; WIDTH: 4em; PADDING-TOP: 4px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; BACKGROUND-COLOR: rgb(240,240,240)"><A
style="DISPLAY: block; COLOR: black; TEXT-DECORATION: none"
href="http://ci.pentaho.com/job/mondrian/lastBuild/testReport/#"
target=_blank>Duration<SPAN
style="COLOR: black; TEXT-DECORATION: none"> </SPAN></A></TD>
<TD
style="PADDING-RIGHT: 4px; BORDER-TOP: rgb(187,187,187) 1px solid; PADDING-LEFT: 4px; FONT-WEIGHT: bold; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: top; WIDTH: 4em; PADDING-TOP: 4px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; BACKGROUND-COLOR: rgb(240,240,240)"><A
style="DISPLAY: block; COLOR: black; TEXT-DECORATION: none"
href="http://ci.pentaho.com/job/mondrian/lastBuild/testReport/#"
target=_blank>Age<SPAN
style="COLOR: black; TEXT-DECORATION: none"> </SPAN></A></TD></TR>
<TR>
<TD
style="BORDER-RIGHT: rgb(187,187,187) 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: rgb(187,187,187) 1px solid; MARGIN-TOP: 4px; PADDING-LEFT: 4px; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: middle; BORDER-LEFT: rgb(187,187,187) 1px solid; PADDING-TOP: 3px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; WHITE-SPACE: nowrap"><A
style="COLOR: rgb(92,53,102); TEXT-DECORATION: underline"
href="http://ci.pentaho.com/job/mondrian/lastBuild/testReport/mondrian.rolap/VirtualCubeTest/testNonEmptyCJConstraintOnVirtualCube"
target=_blank>mondrian.rolap.VirtualCubeTest.testNonEmptyCJConstraintOnVirtualCube</A></TD>
<TD
style="BORDER-RIGHT: rgb(187,187,187) 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: rgb(187,187,187) 1px solid; MARGIN-TOP: 4px; PADDING-LEFT: 4px; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: middle; BORDER-LEFT: rgb(187,187,187) 1px solid; PADDING-TOP: 3px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; WHITE-SPACE: nowrap; TEXT-ALIGN: right">1.038</TD>
<TD
style="BORDER-RIGHT: rgb(187,187,187) 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: rgb(187,187,187) 1px solid; MARGIN-TOP: 4px; PADDING-LEFT: 4px; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: middle; BORDER-LEFT: rgb(187,187,187) 1px solid; PADDING-TOP: 3px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; WHITE-SPACE: nowrap; TEXT-ALIGN: right">40</TD></TR>
<TR>
<TD
style="BORDER-RIGHT: rgb(187,187,187) 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: rgb(187,187,187) 1px solid; MARGIN-TOP: 4px; PADDING-LEFT: 4px; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: middle; BORDER-LEFT: rgb(187,187,187) 1px solid; PADDING-TOP: 3px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; WHITE-SPACE: nowrap"><A
style="COLOR: rgb(92,53,102); TEXT-DECORATION: underline"
href="http://ci.pentaho.com/job/mondrian/lastBuild/testReport/mondrian.rolap/VirtualCubeTest/testNonEmptyConstraintOnVirtualCubeWithCalcMeasure"
target=_blank>mondrian.rolap.VirtualCubeTest.testNonEmptyConstraintOnVirtualCubeWithCalcMeasure</A></TD>
<TD
style="BORDER-RIGHT: rgb(187,187,187) 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: rgb(187,187,187) 1px solid; MARGIN-TOP: 4px; PADDING-LEFT: 4px; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: middle; BORDER-LEFT: rgb(187,187,187) 1px solid; PADDING-TOP: 3px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; WHITE-SPACE: nowrap; TEXT-ALIGN: right">0.342</TD>
<TD
style="BORDER-RIGHT: rgb(187,187,187) 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: rgb(187,187,187) 1px solid; MARGIN-TOP: 4px; PADDING-LEFT: 4px; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: middle; BORDER-LEFT: rgb(187,187,187) 1px solid; PADDING-TOP: 3px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; WHITE-SPACE: nowrap; TEXT-ALIGN: right">40</TD></TR>
<TR>
<TD
style="BORDER-RIGHT: rgb(187,187,187) 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: rgb(187,187,187) 1px solid; MARGIN-TOP: 4px; PADDING-LEFT: 4px; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: middle; BORDER-LEFT: rgb(187,187,187) 1px solid; PADDING-TOP: 3px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; WHITE-SPACE: nowrap"><A
style="COLOR: rgb(92,53,102); TEXT-DECORATION: underline"
href="http://ci.pentaho.com/job/mondrian/lastBuild/testReport/mondrian.rolap/NonEmptyTest/testMultiLevelMemberConstraintNonNullParent"
target=_blank>mondrian.rolap.NonEmptyTest.testMultiLevelMemberConstraintNonNullParent</A></TD>
<TD
style="BORDER-RIGHT: rgb(187,187,187) 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: rgb(187,187,187) 1px solid; MARGIN-TOP: 4px; PADDING-LEFT: 4px; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: middle; BORDER-LEFT: rgb(187,187,187) 1px solid; PADDING-TOP: 3px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; WHITE-SPACE: nowrap; TEXT-ALIGN: right">0.47</TD>
<TD
style="BORDER-RIGHT: rgb(187,187,187) 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: rgb(187,187,187) 1px solid; MARGIN-TOP: 4px; PADDING-LEFT: 4px; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: middle; BORDER-LEFT: rgb(187,187,187) 1px solid; PADDING-TOP: 3px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; WHITE-SPACE: nowrap; TEXT-ALIGN: right">40</TD></TR>
<TR>
<TD
style="BORDER-RIGHT: rgb(187,187,187) 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: rgb(187,187,187) 1px solid; MARGIN-TOP: 4px; PADDING-LEFT: 4px; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: middle; BORDER-LEFT: rgb(187,187,187) 1px solid; PADDING-TOP: 3px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; WHITE-SPACE: nowrap"><A
style="COLOR: rgb(92,53,102); TEXT-DECORATION: underline"
href="http://ci.pentaho.com/job/mondrian/lastBuild/testReport/mondrian.rolap/NonEmptyTest/testMultiLevelMemberConstraintNullParent"
target=_blank>mondrian.rolap.NonEmptyTest.testMultiLevelMemberConstraintNullParent</A></TD>
<TD
style="BORDER-RIGHT: rgb(187,187,187) 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: rgb(187,187,187) 1px solid; MARGIN-TOP: 4px; PADDING-LEFT: 4px; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: middle; BORDER-LEFT: rgb(187,187,187) 1px solid; PADDING-TOP: 3px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; WHITE-SPACE: nowrap; TEXT-ALIGN: right">0.276</TD>
<TD
style="BORDER-RIGHT: rgb(187,187,187) 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: rgb(187,187,187) 1px solid; MARGIN-TOP: 4px; PADDING-LEFT: 4px; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: middle; BORDER-LEFT: rgb(187,187,187) 1px solid; PADDING-TOP: 3px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; WHITE-SPACE: nowrap; TEXT-ALIGN: right">40</TD></TR>
<TR>
<TD
style="BORDER-RIGHT: rgb(187,187,187) 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: rgb(187,187,187) 1px solid; MARGIN-TOP: 4px; PADDING-LEFT: 4px; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: middle; BORDER-LEFT: rgb(187,187,187) 1px solid; PADDING-TOP: 3px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; WHITE-SPACE: nowrap"><A
style="COLOR: rgb(92,53,102); TEXT-DECORATION: underline"
href="http://ci.pentaho.com/job/mondrian/lastBuild/testReport/mondrian.rolap/NonEmptyTest/testMultiLevelMemberConstraintMixedNullNonNullParent"
target=_blank>mondrian.rolap.NonEmptyTest.testMultiLevelMemberConstraintMixedNullNonNullParent</A></TD>
<TD
style="BORDER-RIGHT: rgb(187,187,187) 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: rgb(187,187,187) 1px solid; MARGIN-TOP: 4px; PADDING-LEFT: 4px; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: middle; BORDER-LEFT: rgb(187,187,187) 1px solid; PADDING-TOP: 3px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; WHITE-SPACE: nowrap; TEXT-ALIGN: right">0.31</TD>
<TD
style="BORDER-RIGHT: rgb(187,187,187) 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: rgb(187,187,187) 1px solid; MARGIN-TOP: 4px; PADDING-LEFT: 4px; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: middle; BORDER-LEFT: rgb(187,187,187) 1px solid; PADDING-TOP: 3px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; WHITE-SPACE: nowrap; TEXT-ALIGN: right">40</TD></TR>
<TR>
<TD
style="BORDER-RIGHT: rgb(187,187,187) 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: rgb(187,187,187) 1px solid; MARGIN-TOP: 4px; PADDING-LEFT: 4px; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: middle; BORDER-LEFT: rgb(187,187,187) 1px solid; PADDING-TOP: 3px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; WHITE-SPACE: nowrap"><A
style="COLOR: rgb(32,74,135); TEXT-DECORATION: underline"
href="http://ci.pentaho.com/job/mondrian/lastBuild/testReport/mondrian.rolap/NonEmptyTest/testMultiLevelMemberConstraintWithMixedNullNonNullChild"
target=_blank>mondrian.rolap.NonEmptyTest.testMultiLevelMemberConstraintWithMixedNullNonNullChild</A></TD>
<TD
style="BORDER-RIGHT: rgb(187,187,187) 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: rgb(187,187,187) 1px solid; MARGIN-TOP: 4px; PADDING-LEFT: 4px; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: middle; BORDER-LEFT: rgb(187,187,187) 1px solid; PADDING-TOP: 3px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; WHITE-SPACE: nowrap; TEXT-ALIGN: right">0.273</TD>
<TD
style="BORDER-RIGHT: rgb(187,187,187) 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: rgb(187,187,187) 1px solid; MARGIN-TOP: 4px; PADDING-LEFT: 4px; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; VERTICAL-ALIGN: middle; BORDER-LEFT: rgb(187,187,187) 1px solid; PADDING-TOP: 3px; BORDER-BOTTOM: rgb(187,187,187) 1px solid; FONT-FAMILY: Verdana,Helvetica,'sans serif'; WHITE-SPACE: nowrap; TEXT-ALIGN: right">40</TD></TR></TBODY></TABLE></SPAN></DIV>_______________________________________________<BR>Mondrian
mailing list<BR><A href="mailto:Mondrian@pentaho.org"
target=_blank>Mondrian@pentaho.org</A><BR><A
href="http://lists.pentaho.org/mailman/listinfo/mondrian"
target=_blank>http://lists.pentaho.org/mailman/listinfo/mondrian</A><BR></BLOCKQUOTE></DIV><BR></DIV></DIV></DIV></DIV><BR>_______________________________________________<BR>Mondrian
mailing list<BR><A
href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</A><BR><A
href="http://lists.pentaho.org/mailman/listinfo/mondrian"
target=_blank>http://lists.pentaho.org/mailman/listinfo/mondrian</A><BR><BR></BLOCKQUOTE></DIV><BR></BLOCKQUOTE></BODY></HTML>