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

Julian Hyde jhyde at pentaho.com
Sun May 4 15:55:32 EDT 2008


Likewise, if you set mondrian.test.ExpDependencies=10
mondrian.rolap.evaluate.MaxEvalDepth=6 mondrian.test.random.seed=-1
mondrian.expCache.enable=false, there are 2 failures present in 10937 that
are absent in 10936. Can you look into these also.

     [java] 2)
testDistinctCountAggHappensInGSQueryForSubsetOfMembers(mondrian.rolap.agg.Ag
gregationOnDistinctCountMeasuresTest)junit.framework.AssertionFailedError:
expected query [select "store"."store_state" as "c0",
"time_by_day"."the_year" as "c1", count(distinct
"sales_fact_1997"."customer_id") as "m0", grouping("store"."store_state") as
"g0" from "store" "store", "sales_fact_1997" "sales_fact_1997",
"time_by_day" "time_by_day" where "sales_fact_1997"."store_id" =
"store"."store_id" and "store"."store_state" in ('CA', 'OR') and
"sales_fact_1997"."time_id" = "time_by_day"."time_id" and
"time_by_day"."the_year" = 1997 group by grouping sets
(("store"."store_state","time_by_day"."the_year"),("time_by_day"."the_year")
)] did not occur
     [java] 	at
mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:380)
     [java] 	at
mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:263)
     [java] 	at
mondrian.rolap.agg.AggregationOnDistinctCountMeasuresTest.testDistinctCountA
ggHappensInGSQueryForSubsetOfMembers(AggregationOnDistinctCountMeasuresTest.
java:799)
     [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:130)
     [java] 	at java.lang.Thread.run(Thread.java:595)
     [java] 3)
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] 	at
mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:380)
     [java] 	at
mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:263)
     [java] 	at
mondrian.rolap.FastBatchingCellReaderTest.testAggregateDistinctCount3(FastBa
tchingCellReaderTest.java:1322)
     [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:130)
     [java] 	at java.lang.Thread.run(Thread.java:595)

Julian
 

> -----Original Message-----
> From: Julian Hyde [mailto:jhyde at pentaho.com] 
> Sent: Sunday, May 04, 2008 11:03 AM
> To: 'Zelaine Fong'
> Cc: 'mondrian at pentaho.org'
> Subject: FW: Cron <jhyde at marmalade> nice bash --login 
> /home/jhyde/open2/mondrian/bin/megatest --nightly
> 
> Zelaine,
> 
> These two errors started occurring against oracle/JDK 1.5 
> (and other configurations - but interestingly not oracle/JDK 
> 1.6) with your change 10937. Can you take a look at them please.
> 
> Running test with JDK=jdk1.5 retroweave= database=oracle props={}
>      [java] 1) 
> testDistinctCountAggHappensInGSQueryForSubsetOfMembers(mondria
> n.rolap.agg.AggregationOnDistinctCountMeasuresTest)junit.frame
> work.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_da
> y"."the_year"))] did not occur
>      [java] 2) 
> testAggregateDistinctCount3(mondrian.rolap.FastBatchingCellRea
> derTest)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
> 
> Julian
> 





More information about the Mondrian mailing list