[Mondrian] NonEmptyTest.testConstrainedMeasureGetsOptimized

[Kurtis.Walker at thomsonreuters.com]

Julian,

 

Our environment is Oracle and the test is passing.  Is there anything
else different about the environment where it fails?  Also, we thought
that the Hudson build ran against Oracle.  The Hudson build is green
right now, so are we incorrect that it runs against Oracle?

 

Kurt

 

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of Julian Hyde
Sent: Tuesday, January 05, 2010 12:41 PM
To: 'Matt Campbell'
Cc: 'Mondrian developer mailing list'
Subject: [Mondrian] NonEmptyTest.testConstrainedMeasureGetsOptimized

 

Matt,

 

NonEmptyTest.testConstrainedMeasureGetsOptimized is failing on Oracle:

[java] There was 1 failure:

[java] 1)
testConstrainedMeasureGetsOptimized(mondrian.rolap.NonEmptyTest)junit.fr
amework.AssertionFailedError: expected query [select
"customer"."country" as "c0", "customer"."state_province" as "c1",
"customer"."city" as "c2", "customer"."customer_id" as "c3", "fname" ||
' ' || "lname" as "c4", "fname" || ' ' || "lname" as "c5",
"customer"."gender" as "c6", "customer"."marital_status" as "c7",
"customer"."education" as "c8", "customer"."yearly_income" as "c9" from
"customer" "customer", "sales_fact_1997" "sales_fact_1997" where
"sales_fact_1997"."customer_id" = "customer"."customer_id" and
("customer"."gender" in ('M', 'F')) group by "customer"."country",
"customer"."state_province", "customer"."city",
"customer"."customer_id", "fname" || ' ' || "lname",
"customer"."gender", "customer"."marital_status",
"customer"."education", "customer"."yearly_income" order by
"customer"."country" ASC, "customer"."state_province" ASC,
"customer"."city" ASC, "fname" || ' ' || "lname" ASC] did not occur

[java] at
mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:427)

[java] at
mondrian.rolap.BatchTestCase.assertQuerySql(BatchTestCase.java:294)

[java] at
mondrian.rolap.NonEmptyTest.testConstrainedMeasureGetsOptimized(NonEmpty
Test.java:3795)

[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

[java] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)

[java] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)

[java] at
mondrian.test.MondrianTestRunner$2.run(MondrianTestRunner.java:139)

[java] at java.lang.Thread.run(Thread.java:619)

 

Julian

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20100105/6c8cb32a/attachment.html