[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