I&#39;ll look into it.<br><br><div class="gmail_quote">On Fri, Feb 20, 2009 at 3:19 AM, Julian Hyde <span dir="ltr">&lt;<a href="mailto:julian@hydromatic.net">julian@hydromatic.net</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">




<div>
<div><span><font face="Lucida Sans" color="#000080" size="2">Matt,</font></span></div>
<div><span><font face="Lucida Sans" color="#000080" size="2"></font></span>&nbsp;</div>
<div><span><font face="Lucida Sans" color="#000080" size="2">Your change 12310 caused 6 failures in tests run against Oracle. Can you 
take a look please.</font></span></div>
<div><span><font face="Lucida Sans" color="#000080" size="2"></font></span>&nbsp;</div>
<div><span><font face="Lucida Sans" color="#000080" size="2">Julian</font></span></div>
<div><span><font face="Lucida Sans" color="#000080" size="2"></font></span>&nbsp;</div>
<div><span><font face="Lucida Sans" color="#000080" size="2">-------------</font></span></div>
<div><span><font face="Lucida Sans" color="#000080" size="2"></font></span>&nbsp;</div><span><span lang="EN">
<div><font face="Arial">[java] There were 6 failures:</font></div>
<div><font face="Arial">[java] 1) 
testGroupingSetForMultipleColumnConstraintAndCompoundConstraint(mondrian.rolap.GroupingSetQueryTest)junit.framework.AssertionFailedError: 
expected query [select &quot;time_by_day&quot;.&quot;the_year&quot; as &quot;c0&quot;, &quot;customer&quot;.&quot;gender&quot; as 
&quot;c1&quot;, count(distinct &quot;sales_fact_1997&quot;.&quot;customer_id&quot;) as &quot;m0&quot;, 
grouping(&quot;customer&quot;.&quot;gender&quot;) as &quot;g0&quot; from &quot;time_by_day&quot; &quot;time_by_day&quot;, 
&quot;sales_fact_1997&quot; &quot;sales_fact_1997&quot;, &quot;customer&quot; &quot;customer&quot;, &quot;store&quot; &quot;store&quot; 
where &quot;sales_fact_1997&quot;.&quot;time_id&quot; = &quot;time_by_day&quot;.&quot;time_id&quot; and 
&quot;time_by_day&quot;.&quot;the_year&quot; = 1997 and &quot;sales_fact_1997&quot;.&quot;customer_id&quot; = 
&quot;customer&quot;.&quot;customer_id&quot; and &quot;sales_fact_1997&quot;.&quot;store_id&quot; = &quot;store&quot;.&quot;store_id&quot; 
and ((&quot;store&quot;.&quot;store_country&quot; = &#39;USA&#39; and &quot;store&quot;.&quot;store_state&quot; = &#39;OR&#39;) or 
(&quot;store&quot;.&quot;store_country&quot; = &#39;CANADA&#39; and &quot;store&quot;.&quot;store_state&quot; = &#39;BC&#39;)) group by 
grouping sets 
((&quot;time_by_day&quot;.&quot;the_year&quot;,&quot;customer&quot;.&quot;gender&quot;),(&quot;time_by_day&quot;.&quot;the_year&quot;))] did 
not occur</font></div>
<div><font face="Arial">[java] at 
mondrian.rolap.BatchTestCase.assertRequestSql(BatchTestCase.java:238)</font></div>
<div><font face="Arial">[java] at 
mondrian.rolap.GroupingSetQueryTest.testGroupingSetForMultipleColumnConstraintAndCompoundConstraint(GroupingSetQueryTest.java:494)</font></div>
<div><font face="Arial">[java] at 
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</font></div>
<div><font face="Arial">[java] at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</font></div>
<div><font face="Arial">[java] at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</font></div>
<div><font face="Arial">[java] at 
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:129)</font></div>
<div><font face="Arial">[java] at 
java.lang.Thread.run(Thread.java:619)</font></div>
<div><font face="Arial">[java] 2) 
testSQLForTotalOnCJofMembersWithDistinctCount(mondrian.rolap.GroupingSetQueryTest)junit.framework.AssertionFailedError: 
expected query [select &quot;store&quot;.&quot;store_country&quot; as &quot;c0&quot;, &quot;time_by_day&quot;.&quot;the_year&quot; 
as &quot;c1&quot;, &quot;customer&quot;.&quot;gender&quot; as &quot;c2&quot;, count(distinct 
&quot;sales_fact_1997&quot;.&quot;customer_id&quot;) as &quot;m0&quot;, grouping(&quot;customer&quot;.&quot;gender&quot;) as &quot;g0&quot;, 
grouping(&quot;store&quot;.&quot;store_country&quot;) as &quot;g1&quot; from &quot;store&quot; &quot;store&quot;, 
&quot;sales_fact_1997&quot; &quot;sales_fact_1997&quot;, &quot;time_by_day&quot; &quot;time_by_day&quot;, &quot;customer&quot; 
&quot;customer&quot; where &quot;sales_fact_1997&quot;.&quot;store_id&quot; = &quot;store&quot;.&quot;store_id&quot; and 
&quot;sales_fact_1997&quot;.&quot;time_id&quot; = &quot;time_by_day&quot;.&quot;time_id&quot; and 
&quot;time_by_day&quot;.&quot;the_year&quot; = 1997 and &quot;sales_fact_1997&quot;.&quot;customer_id&quot; = 
&quot;customer&quot;.&quot;customer_id&quot; group by grouping sets 
((&quot;store&quot;.&quot;store_country&quot;,&quot;time_by_day&quot;.&quot;the_year&quot;,&quot;customer&quot;.&quot;gender&quot;),(&quot;store&quot;.&quot;store_country&quot;,&quot;time_by_day&quot;.&quot;the_year&quot;),(&quot;time_by_day&quot;.&quot;the_year&quot;),(&quot;time_by_day&quot;.&quot;the_year&quot;,&quot;customer&quot;.&quot;gender&quot;))] 
did not occur</font></div>
<div><font face="Arial">[java] at 
mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:399)</font></div>
<div><font face="Arial">[java] at 
mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:279)</font></div>
<div><font face="Arial">[java] at 
mondrian.rolap.GroupingSetQueryTest.testSQLForTotalOnCJofMembersWithDistinctCount(GroupingSetQueryTest.java:547)</font></div>
<div><font face="Arial">[java] at 
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</font></div>
<div><font face="Arial">[java] at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</font></div>
<div><font face="Arial">[java] at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</font></div>
<div><font face="Arial">[java] at 
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:129)</font></div>
<div><font face="Arial">[java] at 
java.lang.Thread.run(Thread.java:619)</font></div>
<div><font face="Arial">[java] 3) 
testAggregationOnMembersAndDefaultMemberForDistinctCount(mondrian.rolap.GroupingSetQueryTest)junit.framework.AssertionFailedError: 
expected query [select &quot;time_by_day&quot;.&quot;the_year&quot; as &quot;c0&quot;, &quot;customer&quot;.&quot;gender&quot; as 
&quot;c1&quot;, count(distinct &quot;sales_fact_1997&quot;.&quot;customer_id&quot;) as &quot;m0&quot;, 
grouping(&quot;customer&quot;.&quot;gender&quot;) as &quot;g0&quot; from &quot;time_by_day&quot; &quot;time_by_day&quot;, 
&quot;sales_fact_1997&quot; &quot;sales_fact_1997&quot;, &quot;customer&quot; &quot;customer&quot; where 
&quot;sales_fact_1997&quot;.&quot;time_id&quot; = &quot;time_by_day&quot;.&quot;time_id&quot; and 
&quot;time_by_day&quot;.&quot;the_year&quot; = 1997 and &quot;sales_fact_1997&quot;.&quot;customer_id&quot; = 
&quot;customer&quot;.&quot;customer_id&quot; group by grouping sets 
((&quot;time_by_day&quot;.&quot;the_year&quot;,&quot;customer&quot;.&quot;gender&quot;),(&quot;time_by_day&quot;.&quot;the_year&quot;))] did 
not occur</font></div>
<div><font face="Arial">[java] at 
mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:399)</font></div>
<div><font face="Arial">[java] at 
mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:279)</font></div>
<div><font face="Arial">[java] at 
mondrian.rolap.GroupingSetQueryTest.testAggregationOnMembersAndDefaultMemberForDistinctCount(GroupingSetQueryTest.java:600)</font></div>
<div><font face="Arial">[java] at 
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</font></div>
<div><font face="Arial">[java] at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</font></div>
<div><font face="Arial">[java] at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</font></div>
<div><font face="Arial">[java] at 
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:129)</font></div>
<div><font face="Arial">[java] at 
java.lang.Thread.run(Thread.java:619)</font></div>
<div><font face="Arial">[java] 4) 
testDistinctCountAggHappensInGSQueryForSubsetOfMembers(mondrian.rolap.agg.AggregationOnDistinctCountMeasuresTest)junit.framework.AssertionFailedError: 
expected query [select &quot;store&quot;.&quot;store_state&quot; as &quot;c0&quot;, &quot;time_by_day&quot;.&quot;the_year&quot; 
as &quot;c1&quot;, count(distinct &quot;sales_fact_1997&quot;.&quot;customer_id&quot;) as &quot;m0&quot;, 
grouping(&quot;store&quot;.&quot;store_state&quot;) as &quot;g0&quot; from &quot;store&quot; &quot;store&quot;, &quot;sales_fact_1997&quot; 
&quot;sales_fact_1997&quot;, &quot;time_by_day&quot; &quot;time_by_day&quot; where 
&quot;sales_fact_1997&quot;.&quot;store_id&quot; = &quot;store&quot;.&quot;store_id&quot; and &quot;store&quot;.&quot;store_state&quot; in 
(&#39;CA&#39;, &#39;OR&#39;) and &quot;sales_fact_1997&quot;.&quot;time_id&quot; = &quot;time_by_day&quot;.&quot;time_id&quot; and 
&quot;time_by_day&quot;.&quot;the_year&quot; = 1997 group by grouping sets 
((&quot;store&quot;.&quot;store_state&quot;,&quot;time_by_day&quot;.&quot;the_year&quot;),(&quot;time_by_day&quot;.&quot;the_year&quot;))] 
did not occur</font></div>
<div><font face="Arial">[java] at 
mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:399)</font></div>
<div><font face="Arial">[java] at 
mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:279)</font></div>
<div><font face="Arial">[java] at 
mondrian.rolap.agg.AggregationOnDistinctCountMeasuresTest.testDistinctCountAggHappensInGSQueryForSubsetOfMembers(AggregationOnDistinctCountMeasuresTest.java:806)</font></div>
<div><font face="Arial">[java] at 
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</font></div>
<div><font face="Arial">[java] at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</font></div>
<div><font face="Arial">[java] at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</font></div>
<div><font face="Arial">[java] at 
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:129)</font></div>
<div><font face="Arial">[java] at 
java.lang.Thread.run(Thread.java:619)</font></div>
<div><font face="Arial">[java] 5) 
testAggregateDistinctCount3(mondrian.rolap.FastBatchingCellReaderTest)junit.framework.AssertionFailedError: 
expected query [select &quot;time_by_day&quot;.&quot;the_year&quot; as &quot;c0&quot;, &quot;time_by_day&quot;.&quot;quarter&quot; 
as &quot;c1&quot;, &quot;promotion&quot;.&quot;media_type&quot; as &quot;c2&quot;, count(distinct 
&quot;sales_fact_1997&quot;.&quot;customer_id&quot;) as &quot;m0&quot;, grouping(&quot;promotion&quot;.&quot;media_type&quot;) as 
&quot;g0&quot; from &quot;time_by_day&quot; &quot;time_by_day&quot;, &quot;sales_fact_1997&quot; &quot;sales_fact_1997&quot;, 
&quot;promotion&quot; &quot;promotion&quot; where &quot;sales_fact_1997&quot;.&quot;time_id&quot; = 
&quot;time_by_day&quot;.&quot;time_id&quot; and &quot;time_by_day&quot;.&quot;the_year&quot; = 1997 and 
&quot;time_by_day&quot;.&quot;quarter&quot; = &#39;Q1&#39; and &quot;sales_fact_1997&quot;.&quot;promotion_id&quot; = 
&quot;promotion&quot;.&quot;promotion_id&quot; and &quot;promotion&quot;.&quot;media_type&quot; in (&#39;Radio&#39;, &#39;TV&#39;) group 
by grouping sets 
((&quot;time_by_day&quot;.&quot;the_year&quot;,&quot;time_by_day&quot;.&quot;quarter&quot;,&quot;promotion&quot;.&quot;media_type&quot;),(&quot;time_by_day&quot;.&quot;the_year&quot;,&quot;time_by_day&quot;.&quot;quarter&quot;))] 
did not occur</font></div>
<div><font face="Arial">[java] at 
mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:399)</font></div>
<div><font face="Arial">[java] at 
mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:279)</font></div>
<div><font face="Arial">[java] at 
mondrian.rolap.FastBatchingCellReaderTest.testAggregateDistinctCount3(FastBatchingCellReaderTest.java:1361)</font></div>
<div><font face="Arial">[java] at 
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</font></div>
<div><font face="Arial">[java] at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</font></div>
<div><font face="Arial">[java] at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</font></div>
<div><font face="Arial">[java] at 
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:129)</font></div>
<div><font face="Arial">[java] at 
java.lang.Thread.run(Thread.java:619)</font></div>
<div><font face="Arial">[java] 6) 
testToStringForSingleGroupingSetSql(mondrian.rolap.sql.SqlQueryTest)junit.framework.ComparisonFailure: 
expected:&lt;select c1 [&quot;c0&quot;, c2] &quot;c1&quot;, grouping(gf0)...&gt; but was:&lt;select 
c1 [as &quot;c0&quot;, c2 as] &quot;c1&quot;, grouping(gf0)...&gt;</font></div>
<div><font face="Arial">[java] at 
mondrian.rolap.sql.SqlQueryTest.testToStringForSingleGroupingSetSql(SqlQueryTest.java:100)</font></div>
<div><font face="Arial">[java] at 
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</font></div>
<div><font face="Arial">[java] at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</font></div>
<div><font face="Arial">[java] at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</font></div>
<div><font face="Arial">[java] at 
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:129)</font></div>
<div><font face="Arial">[java] at 
java.lang.Thread.run(Thread.java:619)</font></div></span></span></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>