[Mondrian] Change 12310

Julian Hyde julian at hydromatic.net
Fri Feb 20 03:19:22 EST 2009


Matt,
 
Your change 12310 caused 6 failures in tests run against Oracle. Can you
take a look please.
 
Julian
 
-------------
 
[java] There were 6 failures:
[java] 1)
testGroupingSetForMultipleColumnConstraintAndCompoundConstraint(mondrian.rol
ap.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
[java] at
mondrian.rolap.BatchTestCase.assertRequestSql(BatchTestCase.java:238)
[java] at
mondrian.rolap.GroupingSetQueryTest.testGroupingSetForMultipleColumnConstrai
ntAndCompoundConstraint(GroupingSetQueryTest.java:494)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
[java] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
[java] at
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:129)
[java] at java.lang.Thread.run(Thread.java:619)
[java] 2)
testSQLForTotalOnCJofMembersWithDistinctCount(mondrian.rolap.GroupingSetQuer
yTest)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"),("st
ore"."store_country","time_by_day"."the_year"),("time_by_day"."the_year"),("
time_by_day"."the_year","customer"."gender"))] did not occur
[java] at
mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:399)
[java] at
mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:279)
[java] at
mondrian.rolap.GroupingSetQueryTest.testSQLForTotalOnCJofMembersWithDistinct
Count(GroupingSetQueryTest.java:547)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
[java] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
[java] at
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:129)
[java] at java.lang.Thread.run(Thread.java:619)
[java] 3)
testAggregationOnMembersAndDefaultMemberForDistinctCount(mondrian.rolap.Grou
pingSetQueryTest)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
[java] at
mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:399)
[java] at
mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:279)
[java] at
mondrian.rolap.GroupingSetQueryTest.testAggregationOnMembersAndDefaultMember
ForDistinctCount(GroupingSetQueryTest.java:600)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
[java] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
[java] at
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:129)
[java] at java.lang.Thread.run(Thread.java:619)
[java] 4)
testDistinctCountAggHappensInGSQueryForSubsetOfMembers(mondrian.rolap.agg.Ag
gregationOnDistinctCountMeasuresTest)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
[java] at
mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:399)
[java] at
mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:279)
[java] at
mondrian.rolap.agg.AggregationOnDistinctCountMeasuresTest.testDistinctCountA
ggHappensInGSQueryForSubsetOfMembers(AggregationOnDistinctCountMeasuresTest.
java:806)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
[java] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
[java] at
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:129)
[java] at java.lang.Thread.run(Thread.java:619)
[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
[java] at
mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:399)
[java] at
mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:279)
[java] at
mondrian.rolap.FastBatchingCellReaderTest.testAggregateDistinctCount3(FastBa
tchingCellReaderTest.java:1361)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
[java] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
[java] at
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:129)
[java] at java.lang.Thread.run(Thread.java:619)
[java] 6)
testToStringForSingleGroupingSetSql(mondrian.rolap.sql.SqlQueryTest)junit.fr
amework.ComparisonFailure: expected:<select c1 ["c0", c2] "c1",
grouping(gf0)...> but was:<select c1 [as "c0", c2 as] "c1",
grouping(gf0)...>
[java] at
mondrian.rolap.sql.SqlQueryTest.testToStringForSingleGroupingSetSql(SqlQuery
Test.java:100)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
[java] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
[java] at
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:129)
[java] at java.lang.Thread.run(Thread.java:619)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090220/73d0838c/attachment.html 


More information about the Mondrian mailing list