<!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.18203" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=971270503-20022009><FONT face="Lucida Sans" color=#000080 
size=2>Matt,</FONT></SPAN></DIV>
<DIV><SPAN class=971270503-20022009><FONT face="Lucida Sans" color=#000080 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=971270503-20022009><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 class=971270503-20022009><FONT face="Lucida Sans" color=#000080 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=971270503-20022009><FONT face="Lucida Sans" color=#000080 
size=2>Julian</FONT></SPAN></DIV>
<DIV><SPAN class=971270503-20022009><FONT face="Lucida Sans" color=#000080 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=971270503-20022009><FONT face="Lucida Sans" color=#000080 
size=2>-------------</FONT></SPAN></DIV>
<DIV><SPAN class=971270503-20022009><FONT face="Lucida Sans" color=#000080 
size=2></FONT></SPAN>&nbsp;</DIV><SPAN class=971270503-20022009><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:&lt;select c1 ["c0", c2] "c1", grouping(gf0)...&gt; but was:&lt;select 
c1 [as "c0", c2 as] "c1", 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></BODY></HTML>