[Mondrian] Re: FW: Cron <jhyde@marmalade> nice sh --login /home/jhyde/open2/mondrian/testAll --nightly

[Rushan Chen]

These runs use special property settings that caused the failures you 
saw, specifically these two settings:

mondrian.test.ExpDependencies=10
mondrian.native.crossjoin.enable=false

The first setting causes extra sqls to be issued and that could cause 
false negatives in the tests.The second setting turns off native NECJ, 
which changes query pattern. Both problems should have happened without 
the recent change from me.

Fixed those tests in 9581.

Julian Hyde wrote:
> Rushan,
>
> Here are a couple of test failures that might be caused by your recent
> change. Let me know if you think they're unrelated.
>
> 1. 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)
> testCrossjoin(mondrian.rolap.NonEmptyTest)mondrian.olap.ResourceLimitExceede
> dException: Mondrian Error:Number of members to be read exceeded limit (45)
>
> 2. 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 "product_class"."product_family",
> "store"."store_country" from "product" as "product", "product_class" as
> "product_class", "sales_fact_1997" as "sales_fact_1997", "store" as "store"
> where "product"."product_class_id" = "product_class"."product_class_id" and
> "sales_fact_1997"."product_id" = "product"."product_id" and
> "sales_fact_1997"."store_id" = "store"."store_id" group by
> "product_class"."product_family", "store"."store_country" order by 1 ASC, 2
> ASC] did not occur
>      [java] Tests run: 1347,  Failures: 1,  Errors: 0
>
> Full test log is attached.
>
> Julian