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

Julian Hyde jhyde at pentaho.org
Mon Feb 4 21:40:26 EST 2008


Thanks for Ajit & co. and Will for fixes over the weekend. There's definite
progress on the mondrian test suite.

There are still a number of failures that occur in one or more
configurations, and I would like to fix all of these before mondrian-3.0
release candidate 1 (about 2-3 weeks away).

     [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] 1)
testRollupPolicyAllAsDefault(mondrian.test.AccessControlTest)mondrian.olap.M
ondrianException: Mondrian Error:Internal error: Error while executing query
[with member [Measures].[Foo] as '[Store]'
     [java] 2)
testSnowflakeClosure(mondrian.test.ParentChildHierarchyTest)mondrian.olap.Mo
ndrianException: Mondrian Error:Internal error: Error while executing query
[select {[Measures].[Count], [Measures].[Org Salary], [Measures].[Number of
Employees], [Measures].[Avg Salary]} ON COLUMNS,
     [java] 1)
testNoTotalForMeasureWithCrossJoinOfJoiningAndNonJoiningDims(mondrian.test.I
gnoreMeasureForNonJoiningDimensionInAggregationTest)junit.framework.Comparis
onFailure: Expected:
     [java] 1)
testRollupPolicySimultaneous(mondrian.test.AccessControlTest)mondrian.olap.M
ondrianException: Mondrian Error:Internal error: Error while executing query
[with member [Measures].[Foo] as '[Measures].[Unit Sales]'
     [java] 1)
testFemaleCustomerCountWithConstraints(mondrian.rolap.TestAggregationManager
)junit.framework.AssertionFailedError: expected:<694> but was:<1122>
     [java] 2)
testParentChildDrillThrough(mondrian.test.ParentChildHierarchyTest)junit.fra
mework.ComparisonFailure: expected:<...39,431.67> but was:<...239,893.59>
     [java] 5)
testAggregationOnCJofMembersGeneratesOptimalQuery(mondrian.rolap.agg.Aggrega
tionOnDistinctCountMeasuresTest)junit.framework.AssertionFailedError:
expected query [select "time_by_day"."the_year" as "c0", count(distinct
"sales_fact_1997"."customer_id") as "m0" 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" and "customer"."gender" in ('F', 'M') group by
"time_by_day"."the_year"] did not occur
     [java] 6)
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" 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
"time_by_day"."the_year", "time_by_day"."quarter", "promotion"."media_type"]
did not occur
     [java] Tests run: 1753,  Failures: 6,  Errors: 1
Running test with JDK=jdk1.6 retroweave=true database=mysql props={
mondrian.rolap.star.disableCaching=true mondrian.expCache.enable=false
mondrian.rolap.LargeDimensionThreshold=777
mondrian.rolap.SparseSegmentValueThreshold=10}
     [java] 1)
testMultiLevelMembersMixedNullNonNullParent(mondrian.rolap.agg.AggregationOn
DistinctCountMeasuresTest)junit.framework.AssertionFailedError: expected
query [select count(distinct `inventory_fact_1997`.`warehouse_cost`) as `m0`
from `warehouse` as `warehouse`, `inventory_fact_1997` as
`inventory_fact_1997` where `inventory_fact_1997`.`warehouse_id` =
`warehouse`.`warehouse_id` and ((`warehouse`.`warehouse_name` = 'Jones
International' and `warehouse`.`wa_address1` = '3377 Coachman Place' and
`warehouse`.`warehouse_fax` = '971-555-6213') or
(`warehouse`.`warehouse_name` = 'Freeman And Co' and
`warehouse`.`wa_address1` = '234 West Covina Pkwy' and
`warehouse`.`warehouse_fax` is null))] did not occur
     [java] 2)
testMultiLevelsMixedNullNonNullChild(mondrian.rolap.agg.AggregationOnDistinc
tCountMeasuresTest)junit.framework.AssertionFailedError: expected query
[select count(distinct `inventory_fact_1997`.`warehouse_cost`) as `m0` from
`warehouse` as `warehouse`, `inventory_fact_1997` as `inventory_fact_1997`
where `inventory_fact_1997`.`warehouse_id` = `warehouse`.`warehouse_id` and
((`warehouse`.`warehouse_fax` = '971-555-6213' and `warehouse`.`wa_address2`
is null and `warehouse`.`wa_address3` is null) or
(`warehouse`.`warehouse_fax` is null and `warehouse`.`wa_address2` is null
and `warehouse`.`wa_address3` is null))] did not occur
     [java] 3)
testAggregateDistinctCount4(mondrian.rolap.FastBatchingCellReaderTest)junit.
framework.AssertionFailedError: expected query [select count(distinct
`sales_fact_1997`.`customer_id`) as `m0` from `store` as `store`,
`sales_fact_1997` as `sales_fact_1997`, `time_by_day` as `time_by_day` where
`sales_fact_1997`.`store_id` = `store`.`store_id` and
`store`.`store_country` = 'USA' and `sales_fact_1997`.`time_id` =
`time_by_day`.`time_id` and ((`time_by_day`.`month_of_year` = 7 and
`time_by_day`.`quarter` = 'Q3' and `time_by_day`.`the_year` = 1997) or
(`time_by_day`.`quarter` = 'Q1' and `time_by_day`.`the_year` = 1997))] did
not occur
     [java] 1)
testRollupPolicySimultaneous(mondrian.test.AccessControlTest)mondrian.olap.M
ondrianException: Mondrian Error:Internal error: Error while executing query
[with member [Measures].[Foo] as '[Measures].[Unit Sales]'
     [java] 1)
testRankExpandNonNative(mondrian.test.clearview.SummaryTest)junit.framework.
ComparisonFailure: expected:<...Bologna].[American].[American Low Fat
Bologna], [Store Size in SQFT].[All Store Size in SQFTs].[21215]}
     [java] 2)
testCountExpandNonNative(mondrian.test.clearview.SummaryTest)junit.framework
.ComparisonFailure: expected:<...Bologna].[American].[American Low Fat
Bologna]}
     [java] 3)
testCountOverTimeExpandNonNative(mondrian.test.clearview.SummaryTest)junit.f
ramework.ComparisonFailure: expected:<...Bologna].[American].[American Low
Fat Bologna]}

See full log attached.

Julian
-------------- next part --------------
A non-text attachment was scrubbed...
Name: megatest.log.gz
Type: application/x-gzip
Size: 16312 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20080204/417205f4/attachment.gz 


More information about the Mondrian mailing list