[Mondrian] Change 12310

Matt Campbell mkambol at gmail.com
Fri Feb 20 07:50:06 EST 2009


I'll look into it.

On Fri, Feb 20, 2009 at 3:19 AM, Julian Hyde <julian at hydromatic.net> wrote:

>  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.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
> [java] at
> mondrian.rolap.BatchTestCase.assertRequestSql(BatchTestCase.java:238)
> [java] at
> mondrian.rolap.GroupingSetQueryTest.testGroupingSetForMultipleColumnConstraintAndCompoundConstraint(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.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
> [java] at
> mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:399)
> [java] at
> mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:279)
> [java] at
> mondrian.rolap.GroupingSetQueryTest.testSQLForTotalOnCJofMembersWithDistinctCount(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.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
> [java] at
> mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:399)
> [java] at
> mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:279)
> [java] at
> mondrian.rolap.GroupingSetQueryTest.testAggregationOnMembersAndDefaultMemberForDistinctCount(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.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
> [java] at
> mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:399)
> [java] at
> mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:279)
> [java] at
> mondrian.rolap.agg.AggregationOnDistinctCountMeasuresTest.testDistinctCountAggHappensInGSQueryForSubsetOfMembers(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(FastBatchingCellReaderTest.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.framework.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(SqlQueryTest.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)
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090220/c6b60391/attachment.html 


More information about the Mondrian mailing list