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

Zelaine Fong zfong at lucidera.com
Mon May 5 14:23:03 EDT 2008


The failure in 
AggregationOnDistinctCountMeasuresTest.testDistinctCountAggHappensInGSQueryForSubsetOfMembers 
is due to my changes.  I'll check in a fix shortly.

However, even if I revert my changes by syncing back to build 10936, I 
still get failures in the following 2 tests, running against Oracle.

AggregationOnDistinctCountMeasuresTest.testDistinctCountAggHappensInNonGSQueryForSubsetOfMembersWithMixedMeasures
AggregationOnDistinctCountMeasuresTest.testAggregatesAtTheSameLevelForNormalAndDistinctCountMeasure

I can't reproduce the failures in FastBatchingCellReaderTest, both with 
and without my changes, against Oracle.

-- Zelaine

Zelaine Fong wrote:
> Which database does the failures below occur in?  I just ran the test 
> against Derby and MySQL with the properties you specified, and the tests 
> pass for me.
> 
> I'll try the tests from your first email against Oracle to see if I can 
> reproduce those.
> 
> Note that even *before* I checked in my changes, I noticed that a number 
> of these tests that depend on the test generating a specific SQL 
> statement pattern were failing for me for both Derby and MySQL when run 
> against JDK 1.6.  Because of the order of data returned by the db and 
> the order in which data is stored in Java hash sets, those tests 
> appeared to be unreliable.  The order of elements in the WHERE clause 
> ended up being shuffled around, and therefore different from the 
> expected SQL.  I'm not sure if that's also the reason why these tests 
> are failing under certain configurations.
> 
> -- Zelaine
> 
> Julian Hyde wrote:
>> 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