[Mondrian] Test suite on MySQL

[Julian Hyde]

OK, please log a bug and assign to me.
 
Julian


  _____  

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Luc Boudreau
Sent: Wednesday, August 11, 2010 4:37 AM
To: Mondrian developer mailing list
Subject: Re: [Mondrian] Test suite on MySQL



This issue dates back many weeks. I tried stepping through the code quickly
but gave up and decided to test against Oracle. Only yesterday did I decide
to revisit the issue. 
__________________ 
Luc Boudreau

On 2010-08-11, at 2:28 AM, "Julian Hyde" <jhyde at pentaho.com> wrote:



I may have broken something. Did this error occur before my recent change?
 
Julian


  _____  

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Luc Boudreau
Sent: Tuesday, August 10, 2010 9:12 AM
To: Mondrian developer mailing list
Subject: [Mondrian] Test suite on MySQL


Hello,

I'm having troubles running the test suite against MySQL and I'm out of
ideas on what to try next to fix it. I can run it fine on Oracle or Access.
MySQL has a strange exception popping up.



mondrian.olap.MondrianException: Mondrian Error:Member '[Store].[USA].[CA]'
not found
    at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:838)
    at mondrian.olap.Util.lookupCompound(Util.java:586)



Looking at the sql logs, I can confirm that the actual row was retrieved.



2010-08-10 11:50:27,648 DEBUG [mondrian.sql] 7:
SqlMemberSource.getMemberChildren: executing sql [select
`store`.`store_country` as `c0` from `store` as `store` where
UPPER(`store`.`store_country`) = UPPER('USA') group by
`store`.`store_country` order by ISNULL(`store`.`store_country`),
`store`.`store_country` ASC]

2010-08-10 11:50:27,663 DEBUG [mondrian.sql] 7: , exec 15 ms

2010-08-10 11:50:27,663 DEBUG [mondrian.sql] 7: , exec+fetch 15 ms, 1 rows



If I copy / paste that query in a MySQL terminal window, I get the results
as well. 

Someone encountered this before? Insights? Suspicions? Ideas?




_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian


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