I'll look into it.<br><br><div class="gmail_quote">On Fri, Feb 20, 2009 at 3:19 AM, Julian Hyde <span dir="ltr"><<a href="mailto:julian@hydromatic.net">julian@hydromatic.net</a>></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> </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> </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> </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> </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 "time_by_day"."the_year" as "c0", "customer"."gender" as
"c1", count(distinct "sales_fact_1997"."customer_id") as "m0",
grouping("customer"."gender") as "g0" from "time_by_day" "time_by_day",
"sales_fact_1997" "sales_fact_1997", "customer" "customer", "store" "store"
where "sales_fact_1997"."time_id" = "time_by_day"."time_id" and
"time_by_day"."the_year" = 1997 and "sales_fact_1997"."customer_id" =
"customer"."customer_id" and "sales_fact_1997"."store_id" = "store"."store_id"
and (("store"."store_country" = 'USA' and "store"."store_state" = 'OR') or
("store"."store_country" = 'CANADA' and "store"."store_state" = 'BC')) group by
grouping sets
(("time_by_day"."the_year","customer"."gender"),("time_by_day"."the_year"))] 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 "store"."store_country" as "c0", "time_by_day"."the_year"
as "c1", "customer"."gender" as "c2", count(distinct
"sales_fact_1997"."customer_id") as "m0", grouping("customer"."gender") as "g0",
grouping("store"."store_country") as "g1" from "store" "store",
"sales_fact_1997" "sales_fact_1997", "time_by_day" "time_by_day", "customer"
"customer" where "sales_fact_1997"."store_id" = "store"."store_id" and
"sales_fact_1997"."time_id" = "time_by_day"."time_id" and
"time_by_day"."the_year" = 1997 and "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets
(("store"."store_country","time_by_day"."the_year","customer"."gender"),("store"."store_country","time_by_day"."the_year"),("time_by_day"."the_year"),("time_by_day"."the_year","customer"."gender"))]
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 "time_by_day"."the_year" as "c0", "customer"."gender" as
"c1", count(distinct "sales_fact_1997"."customer_id") as "m0",
grouping("customer"."gender") as "g0" from "time_by_day" "time_by_day",
"sales_fact_1997" "sales_fact_1997", "customer" "customer" where
"sales_fact_1997"."time_id" = "time_by_day"."time_id" and
"time_by_day"."the_year" = 1997 and "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets
(("time_by_day"."the_year","customer"."gender"),("time_by_day"."the_year"))] 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 "store"."store_state" as "c0", "time_by_day"."the_year"
as "c1", count(distinct "sales_fact_1997"."customer_id") as "m0",
grouping("store"."store_state") as "g0" from "store" "store", "sales_fact_1997"
"sales_fact_1997", "time_by_day" "time_by_day" where
"sales_fact_1997"."store_id" = "store"."store_id" and "store"."store_state" in
('CA', 'OR') and "sales_fact_1997"."time_id" = "time_by_day"."time_id" and
"time_by_day"."the_year" = 1997 group by grouping sets
(("store"."store_state","time_by_day"."the_year"),("time_by_day"."the_year"))]
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 "time_by_day"."the_year" as "c0", "time_by_day"."quarter"
as "c1", "promotion"."media_type" as "c2", count(distinct
"sales_fact_1997"."customer_id") as "m0", grouping("promotion"."media_type") as
"g0" from "time_by_day" "time_by_day", "sales_fact_1997" "sales_fact_1997",
"promotion" "promotion" where "sales_fact_1997"."time_id" =
"time_by_day"."time_id" and "time_by_day"."the_year" = 1997 and
"time_by_day"."quarter" = 'Q1' and "sales_fact_1997"."promotion_id" =
"promotion"."promotion_id" and "promotion"."media_type" in ('Radio', 'TV') group
by grouping sets
(("time_by_day"."the_year","time_by_day"."quarter","promotion"."media_type"),("time_by_day"."the_year","time_by_day"."quarter"))]
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:<select c1 ["c0", c2] "c1", grouping(gf0)...> but was:<select
c1 [as "c0", c2 as] "c1", grouping(gf0)...></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>