[Mondrian] FW: Cron <jhyde at marmalade> nice bash --login/home/jhyde/open2/mondrian/testAll --nightly

Rushan Chen rchen at lucidera.com
Fri Aug 10 13:53:09 EDT 2007


Hi Julian,

I looked at these two:

- testNativeSetCaching
The test run turned off both native crossjoin and native nonempty, which causes the SQL pattern to be different. Fixed in 9742.

- testMultiLevelMemberConstraint since I recently modified it(and renamed it to testMultiLevelMemberConstraintNonNullParent)
Could not reproduce with the test run setting. Let me know if this one happens again.

Rushan

-----Original Message-----
From: mondrian-bounces at pentaho.org on behalf of Julian Hyde
Sent: Fri 8/10/2007 10:36 AM
To: mondrian at pentaho.org
Subject: [Mondrian] FW: Cron <jhyde at marmalade> nice bash --login/home/jhyde/open2/mondrian/testAll --nightly
 
Update on the regress. My change last night broke a few tests in
GroupingSetQueryTest. Not to mention introduced a javadoc warning. I will
fix today.

Still waiting on Richard and Rushan. 

Julian

-----Original Message-----
From: Cron Daemon [mailto:root at marmalade.hydromatic.net] 
Sent: Friday, August 10, 2007 1:14 AM
To: julianhyde at gmail.com
Subject: Cron <jhyde at marmalade> nice bash --login
/home/jhyde/open2/mondrian/testAll --nightly

//open/mondrian/src/main/mondrian/olap/MondrianServerImpl.java#6 - updating
/home/jhyde/open2/mondrian/src/main/mondrian/olap/MondrianServerImpl.java
No file(s) to resolve.
At revision 25.

::: Summary :::::::::::::::::::::::::::::::::::::
Tests completed at Fri Aug 10 03:52:06 PDT 2007.
Running test with JDK=jdk1.6 database=oracle props={}
     [java] 1)
testGroupingSetForSingleColumnConstraint(mondrian.rolap.GroupingSetQueryTest
)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 2)
testGroupingSetForMultipleMeasureAndSingleConstraint(mondrian.rolap.Grouping
SetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 3)
testGroupingSetForASummaryCanBeGroupedWith2DetailBatch(mondrian.rolap.Groupi
ngSetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 4)
testGroupingSetForMultipleColumnConstraint(mondrian.rolap.GroupingSetQueryTe
st)junit.framework.AssertionFailedError
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
Running test with JDK=jdk1.5 database=oracle props={}
     [java] 1)
testGroupingSetForSingleColumnConstraint(mondrian.rolap.GroupingSetQueryTest
)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 2)
testGroupingSetForMultipleMeasureAndSingleConstraint(mondrian.rolap.Grouping
SetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 3)
testGroupingSetForASummaryCanBeGroupedWith2DetailBatch(mondrian.rolap.Groupi
ngSetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 4)
testGroupingSetForMultipleColumnConstraint(mondrian.rolap.GroupingSetQueryTe
st)junit.framework.AssertionFailedError
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
Running test with JDK=jdk1.5 database=derby props={ mondrian.test.VUsers=1}
     [java] OK (1462 tests)
Running test with JDK=jdk1.4 database=mysql props={ mondrian.test.VUsers=1
mondrian.rolap.aggregates.Use=true mondrian.rolap.aggregates.Read=true}
     [java] 1)
testUnknownUsages(mondrian.test.SchemaTest)junit.framework.ComparisonFailure
: expected:<......> but was:<...06_sales_fact_1997' for fact table
'sales_fact_1997' has a column 'city' with unknown usage.
     [java] 2)
testUnknownUsages1(mondrian.test.SchemaTest)junit.framework.ComparisonFailur
e: expected:<...> but was:<...WARN - Recognizer.checkUnusedColumns:
Candidate aggregate table 'agg_lc_06_sales_fact_1997' for fact table
'sales_fact_1997' has a column 'city' with unknown usage.
     [java] Tests run: 1462,  Failures: 2,  Errors: 0
Running test with JDK=jdk1.5 database=mysql props={ mondrian.test.VUsers=1
mondrian.rolap.aggregates.Use=true mondrian.rolap.aggregates.Read=true}
     [java] 1)
testUnknownUsages(mondrian.test.SchemaTest)junit.framework.ComparisonFailure
: expected:<......> but was:<...06_sales_fact_1997' for fact table
'sales_fact_1997' has a column 'city' with unknown usage.
     [java] 2)
testUnknownUsages1(mondrian.test.SchemaTest)junit.framework.ComparisonFailur
e: expected:<...> but was:<...WARN - Recognizer.checkUnusedColumns:
Candidate aggregate table 'agg_lc_06_sales_fact_1997' for fact table
'sales_fact_1997' has a column 'city' with unknown usage.
     [java] Tests run: 1462,  Failures: 2,  Errors: 0
Running test with JDK=jdk1.4 database=oracle props={ mondrian.test.VUsers=1}
     [java] 1)
queryTest_prevMember_79545abdc7d7cab7.xml(mondrian.test.comp.ResultComparato
rTest)mondrian.olap.MondrianException: Mondrian Error:Internal error: Error
while executing query [select {[Education Level].[All Education
Levels].[Partial College].PrevMember} ON COLUMNS,
     [java] 1)
testGroupingSetForASummaryCanBeGroupedWith2DetailBatch(mondrian.rolap.Groupi
ngSetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 2)
testGroupingSetForMultipleColumnConstraint(mondrian.rolap.GroupingSetQueryTe
st)junit.framework.AssertionFailedError
     [java] 3)
testGroupingSetForMultipleMeasureAndSingleConstraint(mondrian.rolap.Grouping
SetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 4)
testGroupingSetForSingleColumnConstraint(mondrian.rolap.GroupingSetQueryTest
)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] Tests run: 1462,  Failures: 4,  Errors: 1
Running test with JDK=jdk1.5 database=oracle props={ mondrian.test.VUsers=1}
     [java] 1)
testGroupingSetForSingleColumnConstraint(mondrian.rolap.GroupingSetQueryTest
)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 2)
testGroupingSetForMultipleMeasureAndSingleConstraint(mondrian.rolap.Grouping
SetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 3)
testGroupingSetForASummaryCanBeGroupedWith2DetailBatch(mondrian.rolap.Groupi
ngSetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 4)
testGroupingSetForMultipleColumnConstraint(mondrian.rolap.GroupingSetQueryTe
st)junit.framework.AssertionFailedError
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
Running test with JDK=jdk1.6 database=oracle props={ mondrian.test.VUsers=1}
     [java] 1)
testGroupingSetForSingleColumnConstraint(mondrian.rolap.GroupingSetQueryTest
)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 2)
testGroupingSetForMultipleMeasureAndSingleConstraint(mondrian.rolap.Grouping
SetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 3)
testGroupingSetForASummaryCanBeGroupedWith2DetailBatch(mondrian.rolap.Groupi
ngSetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 4)
testGroupingSetForMultipleColumnConstraint(mondrian.rolap.GroupingSetQueryTe
st)junit.framework.AssertionFailedError
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
Running test with JDK=jdk1.5 database=oracle props={
mondrian.test.ExpDependencies=10 mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.test.random.seed=-1 mondrian.expCache.enable=false}
     [java] 1)
testGroupingSetForSingleColumnConstraint(mondrian.rolap.GroupingSetQueryTest
)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 2)
testGroupingSetForMultipleMeasureAndSingleConstraint(mondrian.rolap.Grouping
SetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 3)
testGroupingSetForASummaryCanBeGroupedWith2DetailBatch(mondrian.rolap.Groupi
ngSetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 4)
testGroupingSetForMultipleColumnConstraint(mondrian.rolap.GroupingSetQueryTe
st)junit.framework.AssertionFailedError
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
Running test with JDK=jdk1.5 database=oracle props={
mondrian.rolap.aggregates.Use=true mondrian.rolap.aggregates.Read=true}
     [java] 1)
testUnknownUsages(mondrian.test.SchemaTest)junit.framework.ComparisonFailure
: expected:<......> but was:<...06_sales_fact_1997' for fact table
'sales_fact_1997' has a column 'city' with unknown usage.
     [java] 2)
testUnknownUsages1(mondrian.test.SchemaTest)junit.framework.ComparisonFailur
e: expected:<...> but was:<...WARN - Recognizer.checkUnusedColumns:
Candidate aggregate table 'agg_lc_06_sales_fact_1997' for fact table
'sales_fact_1997' has a column 'city' with unknown usage.
     [java] 3)
testGroupingSetForSingleColumnConstraint(mondrian.rolap.GroupingSetQueryTest
)junit.framework.AssertionFailedError
     [java] 4)
testNotUsingGroupingSet(mondrian.rolap.GroupingSetQueryTest)junit.framework.
AssertionFailedError
     [java] 5)
testGroupingSetForMultipleMeasureAndSingleConstraint(mondrian.rolap.Grouping
SetQueryTest)junit.framework.AssertionFailedError
     [java] 6)
testGroupingSetForASummaryCanBeGroupedWith2DetailBatch(mondrian.rolap.Groupi
ngSetQueryTest)junit.framework.AssertionFailedError
     [java] 7)
testGroupingSetForMultipleColumnConstraint(mondrian.rolap.GroupingSetQueryTe
st)junit.framework.AssertionFailedError
     [java] Tests run: 1462,  Failures: 7,  Errors: 0
Running test with JDK=jdk1.5 database=oracle props={
mondrian.olap.case.sensitive=false}
     [java] 1)
testGroupingSetForSingleColumnConstraint(mondrian.rolap.GroupingSetQueryTest
)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 2)
testGroupingSetForMultipleMeasureAndSingleConstraint(mondrian.rolap.Grouping
SetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 3)
testGroupingSetForASummaryCanBeGroupedWith2DetailBatch(mondrian.rolap.Groupi
ngSetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 4)
testGroupingSetForMultipleColumnConstraint(mondrian.rolap.GroupingSetQueryTe
st)junit.framework.AssertionFailedError
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
Running test with JDK=jdk1.5 database=derby props={
mondrian.rolap.aggregates.Use=true mondrian.rolap.aggregates.Read=true
mondrian.olap.case.sensitive=false mondrian.rolap.star.disableCaching=true
mondrian.native.crossjoin.enable=false mondrian.native.filter.enable=false
mondrian.native.nonempty.enable=false mondrian.expCache.enable=false
mondrian.rolap.LargeDimensionThreshold=25000
mondrian.olap.fun.crossjoin.optimizer.size=0
mondrian.rolap.groupingsets.enable=true}
     [java] 1)
testNativeSetCaching(mondrian.rolap.VirtualCubeTest)junit.framework.Assertio
nFailedError: expected query [select "store"."store_country" from "store" as
"store", "sales_fact_1997" as "sales_fact_1997" where
"sales_fact_1997"."store_id" = "store"."store_id" group by
"store"."store_country" order by 1 ASC] did not occur
     [java] Tests run: 1365,  Failures: 1,  Errors: 0
Running test with JDK=jdk1.5 database=oracle props={
mondrian.test.ExpDependencies=10 mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.test.random.seed=-1 mondrian.expCache.enable=false}
     [java] 1)
testGroupingSetForSingleColumnConstraint(mondrian.rolap.GroupingSetQueryTest
)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 2)
testGroupingSetForMultipleMeasureAndSingleConstraint(mondrian.rolap.Grouping
SetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 3)
testGroupingSetForASummaryCanBeGroupedWith2DetailBatch(mondrian.rolap.Groupi
ngSetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 4)
testGroupingSetForMultipleColumnConstraint(mondrian.rolap.GroupingSetQueryTe
st)junit.framework.AssertionFailedError
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
Running test with JDK=jdk1.5 database=oracle props={
mondrian.test.ExpDependencies=100 mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.test.random.seed=15583 mondrian.expCache.enable=false}
     [java] 1)
testGroupingSetForSingleColumnConstraint(mondrian.rolap.GroupingSetQueryTest
)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 2)
testGroupingSetForMultipleMeasureAndSingleConstraint(mondrian.rolap.Grouping
SetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 3)
testGroupingSetForASummaryCanBeGroupedWith2DetailBatch(mondrian.rolap.Groupi
ngSetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 4)
testGroupingSetForMultipleColumnConstraint(mondrian.rolap.GroupingSetQueryTe
st)junit.framework.AssertionFailedError
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
Running test with JDK=jdk1.5 database=oracle props={
mondrian.expCache.enable=false}
     [java] 1)
testGroupingSetForSingleColumnConstraint(mondrian.rolap.GroupingSetQueryTest
)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 2)
testGroupingSetForMultipleMeasureAndSingleConstraint(mondrian.rolap.Grouping
SetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 3)
testGroupingSetForASummaryCanBeGroupedWith2DetailBatch(mondrian.rolap.Groupi
ngSetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 4)
testGroupingSetForMultipleColumnConstraint(mondrian.rolap.GroupingSetQueryTe
st)junit.framework.AssertionFailedError
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
Running test with JDK=jdk1.5 database=oracle props={
mondrian.rolap.aggregates.Use=true mondrian.rolap.aggregates.Read=true}
     [java] 1)
testUnknownUsages(mondrian.test.SchemaTest)junit.framework.ComparisonFailure
: expected:<......> but was:<...06_sales_fact_1997' for fact table
'sales_fact_1997' has a column 'city' with unknown usage.
     [java] 2)
testUnknownUsages1(mondrian.test.SchemaTest)junit.framework.ComparisonFailur
e: expected:<...> but was:<...WARN - Recognizer.checkUnusedColumns:
Candidate aggregate table 'agg_lc_06_sales_fact_1997' for fact table
'sales_fact_1997' has a column 'city' with unknown usage.
     [java] 3)
testGroupingSetForSingleColumnConstraint(mondrian.rolap.GroupingSetQueryTest
)junit.framework.AssertionFailedError
     [java] 4)
testNotUsingGroupingSet(mondrian.rolap.GroupingSetQueryTest)junit.framework.
AssertionFailedError
     [java] 5)
testGroupingSetForMultipleMeasureAndSingleConstraint(mondrian.rolap.Grouping
SetQueryTest)junit.framework.AssertionFailedError
     [java] 6)
testGroupingSetForASummaryCanBeGroupedWith2DetailBatch(mondrian.rolap.Groupi
ngSetQueryTest)junit.framework.AssertionFailedError
     [java] 7)
testGroupingSetForMultipleColumnConstraint(mondrian.rolap.GroupingSetQueryTe
st)junit.framework.AssertionFailedError
     [java] Tests run: 1462,  Failures: 7,  Errors: 0
Running test with JDK=jdk1.5 database=oracle props={
mondrian.rolap.star.disableCaching=true}
     [java] 1)
testGroupingSetForSingleColumnConstraint(mondrian.rolap.GroupingSetQueryTest
)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 2)
testGroupingSetForMultipleMeasureAndSingleConstraint(mondrian.rolap.Grouping
SetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 3)
testGroupingSetForASummaryCanBeGroupedWith2DetailBatch(mondrian.rolap.Groupi
ngSetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 4)
testGroupingSetForMultipleColumnConstraint(mondrian.rolap.GroupingSetQueryTe
st)junit.framework.AssertionFailedError
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
Running test with JDK=jdk1.5 database=oracle props={
mondrian.olap.case.sensitive=false}
     [java] 1)
testGroupingSetForSingleColumnConstraint(mondrian.rolap.GroupingSetQueryTest
)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 2)
testGroupingSetForMultipleMeasureAndSingleConstraint(mondrian.rolap.Grouping
SetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 3)
testGroupingSetForASummaryCanBeGroupedWith2DetailBatch(mondrian.rolap.Groupi
ngSetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 4)
testGroupingSetForMultipleColumnConstraint(mondrian.rolap.GroupingSetQueryTe
st)junit.framework.AssertionFailedError
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
Running test with JDK=jdk1.6 database=mysql props={
mondrian.native.crossjoin.enable=false mondrian.native.topcount.enable=false
mondrian.xmla.drillthroughTotalCount.enable=false
mondrian.rolap.LargeDimensionThreshold=1}
     [java] OK (1365 tests)
Running test with JDK=jdk1.6 database=oracle props={
mondrian.rolap.aggregates.Use=true mondrian.rolap.aggregates.Read=true
mondrian.rolap.aggregates.ChooseByVolume=true
mondrian.rolap.star.disableCaching=true mondrian.native.filter.enable=false
mondrian.native.nonempty.enable=false
mondrian.xmla.drillthroughTotalCount.enable=false
mondrian.olap.fun.crossjoin.optimizer.size=0
mondrian.rolap.groupingsets.enable=true}
     [java] 1)
testUnknownUsages(mondrian.test.SchemaTest)junit.framework.ComparisonFailure
: expected:<......> but was:<...06_sales_fact_1997' for fact table
'sales_fact_1997' has a column 'city' with unknown usage.
     [java] 2)
testUnknownUsages1(mondrian.test.SchemaTest)junit.framework.ComparisonFailur
e: expected:<...> but was:<...WARN - Recognizer.checkUnusedColumns:
Candidate aggregate table 'agg_lc_06_sales_fact_1997' for fact table
'sales_fact_1997' has a column 'city' with unknown usage.
     [java] 3)
testGroupingSetForSingleColumnConstraint(mondrian.rolap.GroupingSetQueryTest
)junit.framework.AssertionFailedError
     [java] 4)
testNotUsingGroupingSet(mondrian.rolap.GroupingSetQueryTest)junit.framework.
AssertionFailedError
     [java] 5)
testGroupingSetForMultipleMeasureAndSingleConstraint(mondrian.rolap.Grouping
SetQueryTest)junit.framework.AssertionFailedError
     [java] 6)
testGroupingSetForASummaryCanBeGroupedWith2DetailBatch(mondrian.rolap.Groupi
ngSetQueryTest)junit.framework.AssertionFailedError
     [java] 7)
testGroupingSetForMultipleColumnConstraint(mondrian.rolap.GroupingSetQueryTe
st)junit.framework.AssertionFailedError
     [java] Tests run: 1365,  Failures: 7,  Errors: 0
Running test with JDK=jdk1.6 database=oracle props={
mondrian.test.ExpDependencies=10 mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.native.crossjoin.enable=false}
     [java] 1)
testGroupingSetForSingleColumnConstraint(mondrian.rolap.GroupingSetQueryTest
)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 2)
testGroupingSetForMultipleMeasureAndSingleConstraint(mondrian.rolap.Grouping
SetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 3)
testGroupingSetForASummaryCanBeGroupedWith2DetailBatch(mondrian.rolap.Groupi
ngSetQueryTest)junit.framework.ComparisonFailure: expected:<...,
grouping("customer"."gender") as "g0" from "customer" "customer",
"sales_fact_1997" "sales_fact_1997" where "sales_fact_1997"."customer_id" =
"customer"."customer_id" group by grouping sets (("customer"."gender"),())>
but was:<... from "customer" "customer", "sales_fact_1997" "sales_fact_1997"
where "sales_fact_1997"."customer_id" = "customer"."customer_id" group by
"customer"."gender">
     [java] 4)
testGroupingSetForMultipleColumnConstraint(mondrian.rolap.GroupingSetQueryTe
st)junit.framework.AssertionFailedError
     [java] Tests run: 1365,  Failures: 4,  Errors: 0
Running test with JDK=jdk1.6 database=oracle props={
mondrian.rolap.aggregates.Use=true mondrian.rolap.aggregates.Read=true
mondrian.olap.case.sensitive=false mondrian.test.ExpDependencies=10
mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.xmla.drillthroughTotalCount.enable=false
mondrian.expCache.enable=false
mondrian.rolap.SparseSegmentValueThreshold=25000}
     [java] 1)
testUnknownUsages(mondrian.test.SchemaTest)junit.framework.ComparisonFailure
: expected:<......> but was:<...06_sales_fact_1997' for fact table
'sales_fact_1997' has a column 'city' with unknown usage.
     [java] 2)
testUnknownUsages1(mondrian.test.SchemaTest)junit.framework.ComparisonFailur
e: expected:<...> but was:<...WARN - Recognizer.checkUnusedColumns:
Candidate aggregate table 'agg_lc_06_sales_fact_1997' for fact table
'sales_fact_1997' has a column 'city' with unknown usage.
     [java] 3)
testGroupingSetForSingleColumnConstraint(mondrian.rolap.GroupingSetQueryTest
)junit.framework.AssertionFailedError
     [java] 4)
testNotUsingGroupingSet(mondrian.rolap.GroupingSetQueryTest)junit.framework.
AssertionFailedError
     [java] 5)
testGroupingSetForMultipleMeasureAndSingleConstraint(mondrian.rolap.Grouping
SetQueryTest)junit.framework.AssertionFailedError
     [java] 6)
testGroupingSetForASummaryCanBeGroupedWith2DetailBatch(mondrian.rolap.Groupi
ngSetQueryTest)junit.framework.AssertionFailedError
     [java] 7)
testGroupingSetForMultipleColumnConstraint(mondrian.rolap.GroupingSetQueryTe
st)junit.framework.AssertionFailedError
     [java] Tests run: 1462,  Failures: 7,  Errors: 0
Running test with JDK=jdk1.4 database=mysql props={
mondrian.test.ExpDependencies=10 mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.native.crossjoin.enable=false
mondrian.xmla.drillthroughTotalCount.enable=false
mondrian.rolap.LargeDimensionThreshold=1000
mondrian.rolap.SparseSegmentValueThreshold=10}
     [java] 1)
testFlush(mondrian.rolap.CacheControlTest)junit.framework.ComparisonFailure:
Expected:
     [java] Tests run: 1365,  Failures: 1,  Errors: 0
Running test with JDK=jdk1.5 database=oracle props={
mondrian.rolap.aggregates.Use=true mondrian.rolap.aggregates.Read=true
mondrian.rolap.aggregates.ChooseByVolume=true
mondrian.rolap.star.disableCaching=true mondrian.olap.case.sensitive=false
mondrian.test.ExpDependencies=10 mondrian.rolap.evaluate.MaxEvalDepth=6
mondrian.rolap.SparseSegmentValueThreshold=25000}
     [java] 1)
testUnknownUsages(mondrian.test.SchemaTest)junit.framework.ComparisonFailure
: expected:<......> but was:<...06_sales_fact_1997' for fact table
'sales_fact_1997' has a column 'city' with unknown usage.
     [java] 2)
testUnknownUsages1(mondrian.test.SchemaTest)junit.framework.ComparisonFailur
e: expected:<...> but was:<...WARN - Recognizer.checkUnusedColumns:
Candidate aggregate table 'agg_lc_06_sales_fact_1997' for fact table
'sales_fact_1997' has a column 'city' with unknown usage.
     [java] 3)
testGroupingSetForSingleColumnConstraint(mondrian.rolap.GroupingSetQueryTest
)junit.framework.AssertionFailedError
     [java] 4)
testNotUsingGroupingSet(mondrian.rolap.GroupingSetQueryTest)junit.framework.
AssertionFailedError
     [java] 5)
testGroupingSetForMultipleMeasureAndSingleConstraint(mondrian.rolap.Grouping
SetQueryTest)junit.framework.AssertionFailedError
     [java] 6)
testGroupingSetForASummaryCanBeGroupedWith2DetailBatch(mondrian.rolap.Groupi
ngSetQueryTest)junit.framework.AssertionFailedError
     [java] 7)
testGroupingSetForMultipleColumnConstraint(mondrian.rolap.GroupingSetQueryTe
st)junit.framework.AssertionFailedError
     [java] Tests run: 1462,  Failures: 7,  Errors: 0
Running test with JDK=jdk1.6 database=derby props={
mondrian.native.crossjoin.enable=false mondrian.native.topcount.enable=false
mondrian.native.nonempty.enable=false
mondrian.xmla.drillthroughTotalCount.enable=false}
     [java] 1)
testNativeSetCaching(mondrian.rolap.VirtualCubeTest)junit.framework.Assertio
nFailedError: expected query [select "store"."store_country" from "store" as
"store", "sales_fact_1997" as "sales_fact_1997" where
"sales_fact_1997"."store_id" = "store"."store_id" group by
"store"."store_country" order by 1 ASC] did not occur
     [java] Tests run: 1365,  Failures: 1,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
BUILD FAILED
     [java] FAILURES!!!
     [java] Tests run: 1462,  Failures: 2,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1462,  Failures: 2,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1462,  Failures: 4,  Errors: 1
     [java] FAILURES!!!
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1462,  Failures: 7,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1365,  Failures: 1,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1462,  Failures: 7,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1462,  Failures: 4,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1365,  Failures: 7,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1365,  Failures: 4,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1462,  Failures: 7,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1365,  Failures: 1,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1462,  Failures: 7,  Errors: 0
     [java] FAILURES!!!
     [java] Tests run: 1365,  Failures: 1,  Errors: 0
There were failures.

::: check javadoc :::::::::::::::::::::::::::::::
/home/jhyde/open2/mondrian/testsrc/main/mondrian/test/UdfTest.java:631:
warning - Tag @link: can't find guessResultType in
mondrian.olap.fun.FunDefBase


_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian





More information about the Mondrian mailing list