[Mondrian] AggregationOnDistinctCountMeasuresTest.testMultiLevelMembersMixedNullNonNullParent etc. on MySQL

[Julian Hyde]

Rushan,
 
I'm getting failures from testMultiLevelMembersMixedNullNonNullParent and
testMultiLevelsMixedNullNonNullChild in
AggregationOnDistinctCountMeasuresTest when run against MySQL. I checked the
history, and I don't think these tests have ever worked against MySQL since
you added them in change 10426. Can you take a look, please?
 
Julian

test-only:
[echo] Connecting to
jdbc:mysql://localhost/foodmart?user=foodmart&password=foodmart
[echo] Connect String:
Provider=mondrian;Jdbc=jdbc:mysql://localhost/foodmart?user=foodmart&passwor
d=foodmart;JdbcUser=foodmart;JdbcPassword=foodmart;Catalog=/home/jhyde/open2
/mondrian/demo/FoodMart.xml;JdbcDrivers=com.mysql.jdbc.Driver;RoleXX='Califo
rnia manager';
[java] log4j:WARN No appenders could be found for logger
(mondrian.olap.MondrianProperties).
[java] log4j:WARN Please initialize the log4j system properly.
[java] testName: 
[java] testClass: mondrian.rolap.agg.AggregationOnDistinctCountMeasuresTest
[java] java.version: 1.6.0_05
[java] [0 - 36] : mondrian.rolap.agg.AggregationOnDistinctCountMeasuresTest
[java] 
[java] Iterations=1
[java] All 1 thread(s) started.
[java] 
[java] [0] .................F.F..................
[java] There were 2 failures:
[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] at
mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:380)
[java] at
mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:276)
[java] at
mondrian.rolap.agg.AggregationOnDistinctCountMeasuresTest.testMultiLevelMemb
ersMixedNullNonNullParent(AggregationOnDistinctCountMeasuresTest.java:599)
[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:619)
[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] at
mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:380)
[java] at
mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:276)
[java] at
mondrian.rolap.agg.AggregationOnDistinctCountMeasuresTest.testMultiLevelsMix
edNullNonNullChild(AggregationOnDistinctCountMeasuresTest.java:662)
[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:619)
[java] 
[java] FAILURES!!!
[java] Tests run: 36, Failures: 2, Errors: 0

-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 6178 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20080510/1a289bf3/attachment.bin