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="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div style="">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-family: Verdana; font-size: 11px; border-collapse: collapse;"><table style="border: 1px solid rgb(187, 187, 187); font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; margin-top: 4px; white-space: nowrap; width: 1003px; border-collapse: collapse;">
<tbody><tr><td style="border-style: solid none; border-top: 1px solid rgb(187, 187, 187); border-bottom: 1px solid rgb(187, 187, 187); padding: 4px 4px 3px; font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; vertical-align: top; background-color: rgb(240, 240, 240); font-weight: bold;">
<a href="http://ci.pentaho.com/job/mondrian/lastBuild/testReport/#" style="text-decoration: none; color: black; display: block;" target="_blank">Test Name<span style="color: black; text-decoration: none;"> </span></a></td>
<td style="border-style: solid none; border-top: 1px solid rgb(187, 187, 187); border-bottom: 1px solid rgb(187, 187, 187); padding: 4px 4px 3px; font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; vertical-align: top; background-color: rgb(240, 240, 240); font-weight: bold; width: 4em;">
<a href="http://ci.pentaho.com/job/mondrian/lastBuild/testReport/#" style="text-decoration: none; color: black; display: block;" target="_blank">Duration<span style="color: black; text-decoration: none;"> </span></a></td>
<td style="border-style: solid none; border-top: 1px solid rgb(187, 187, 187); border-bottom: 1px solid rgb(187, 187, 187); padding: 4px 4px 3px; font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; vertical-align: top; background-color: rgb(240, 240, 240); font-weight: bold; width: 4em;">
<a href="http://ci.pentaho.com/job/mondrian/lastBuild/testReport/#" style="text-decoration: none; color: black; display: block;" target="_blank">Age<span style="color: black; text-decoration: none;"> </span></a></td> </tr>
<tr><td style="border: 1px solid rgb(187, 187, 187); padding: 3px 4px; font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; vertical-align: middle; margin-top: 4px; white-space: nowrap;"> <a href="http://ci.pentaho.com/job/mondrian/lastBuild/testReport/mondrian.rolap/VirtualCubeTest/testNonEmptyCJConstraintOnVirtualCube" style="text-decoration: underline; color: rgb(92, 53, 102);" target="_blank">mondrian.rolap.VirtualCubeTest.testNonEmptyCJConstraintOnVirtualCube</a></td>
<td style="border: 1px solid rgb(187, 187, 187); padding: 3px 4px; font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; vertical-align: middle; margin-top: 4px; white-space: nowrap; text-align: right;"> 1.038</td>
<td style="border: 1px solid rgb(187, 187, 187); padding: 3px 4px; font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; vertical-align: middle; margin-top: 4px; white-space: nowrap; text-align: right;"> 40</td>
</tr><tr><td style="border: 1px solid rgb(187, 187, 187); padding: 3px 4px; font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; vertical-align: middle; margin-top: 4px; white-space: nowrap;"> <a href="http://ci.pentaho.com/job/mondrian/lastBuild/testReport/mondrian.rolap/VirtualCubeTest/testNonEmptyConstraintOnVirtualCubeWithCalcMeasure" style="text-decoration: underline; color: rgb(92, 53, 102);" target="_blank">mondrian.rolap.VirtualCubeTest.testNonEmptyConstraintOnVirtualCubeWithCalcMeasure</a></td>
<td style="border: 1px solid rgb(187, 187, 187); padding: 3px 4px; font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; vertical-align: middle; margin-top: 4px; white-space: nowrap; text-align: right;"> 0.342</td>
<td style="border: 1px solid rgb(187, 187, 187); padding: 3px 4px; font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; vertical-align: middle; margin-top: 4px; white-space: nowrap; text-align: right;"> 40</td>
</tr><tr><td style="border: 1px solid rgb(187, 187, 187); padding: 3px 4px; font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; vertical-align: middle; margin-top: 4px; white-space: nowrap;"> <a href="http://ci.pentaho.com/job/mondrian/lastBuild/testReport/mondrian.rolap/NonEmptyTest/testMultiLevelMemberConstraintNonNullParent" style="text-decoration: underline; color: rgb(92, 53, 102);" target="_blank">mondrian.rolap.NonEmptyTest.testMultiLevelMemberConstraintNonNullParent</a></td>
<td style="border: 1px solid rgb(187, 187, 187); padding: 3px 4px; font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; vertical-align: middle; margin-top: 4px; white-space: nowrap; text-align: right;"> 0.47</td>
<td style="border: 1px solid rgb(187, 187, 187); padding: 3px 4px; font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; vertical-align: middle; margin-top: 4px; white-space: nowrap; text-align: right;"> 40</td>
</tr><tr><td style="border: 1px solid rgb(187, 187, 187); padding: 3px 4px; font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; vertical-align: middle; margin-top: 4px; white-space: nowrap;"> <a href="http://ci.pentaho.com/job/mondrian/lastBuild/testReport/mondrian.rolap/NonEmptyTest/testMultiLevelMemberConstraintNullParent" style="text-decoration: underline; color: rgb(92, 53, 102);" target="_blank">mondrian.rolap.NonEmptyTest.testMultiLevelMemberConstraintNullParent</a></td>
<td style="border: 1px solid rgb(187, 187, 187); padding: 3px 4px; font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; vertical-align: middle; margin-top: 4px; white-space: nowrap; text-align: right;"> 0.276</td>
<td style="border: 1px solid rgb(187, 187, 187); padding: 3px 4px; font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; vertical-align: middle; margin-top: 4px; white-space: nowrap; text-align: right;"> 40</td>
</tr><tr><td style="border: 1px solid rgb(187, 187, 187); padding: 3px 4px; font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; vertical-align: middle; margin-top: 4px; white-space: nowrap;"> <a href="http://ci.pentaho.com/job/mondrian/lastBuild/testReport/mondrian.rolap/NonEmptyTest/testMultiLevelMemberConstraintMixedNullNonNullParent" style="text-decoration: underline; color: rgb(92, 53, 102);" target="_blank">mondrian.rolap.NonEmptyTest.testMultiLevelMemberConstraintMixedNullNonNullParent</a></td>
<td style="border: 1px solid rgb(187, 187, 187); padding: 3px 4px; font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; vertical-align: middle; margin-top: 4px; white-space: nowrap; text-align: right;"> 0.31</td>
<td style="border: 1px solid rgb(187, 187, 187); padding: 3px 4px; font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; vertical-align: middle; margin-top: 4px; white-space: nowrap; text-align: right;"> 40</td>
</tr><tr><td style="border: 1px solid rgb(187, 187, 187); padding: 3px 4px; font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; vertical-align: middle; margin-top: 4px; white-space: nowrap;"> <a href="http://ci.pentaho.com/job/mondrian/lastBuild/testReport/mondrian.rolap/NonEmptyTest/testMultiLevelMemberConstraintWithMixedNullNonNullChild" style="text-decoration: underline; color: rgb(32, 74, 135);" target="_blank">mondrian.rolap.NonEmptyTest.testMultiLevelMemberConstraintWithMixedNullNonNullChild</a></td>
<td style="border: 1px solid rgb(187, 187, 187); padding: 3px 4px; font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; vertical-align: middle; margin-top: 4px; white-space: nowrap; text-align: right;"> 0.273</td>
<td style="border: 1px solid rgb(187, 187, 187); padding: 3px 4px; font-family: Verdana,Helvetica,'sans serif'; font-size: 11px; vertical-align: middle; margin-top: 4px; 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>