[Mondrian] Test suite on MySQL

[Justin Swanhart]

Hi,

Back on June 30th, Anton Nikitin reported a problem on this list about
a hierarchy where the database was returning one row, but Mondrian was
showing an empty set.

These problems might be related.

--Justin

On Wed, Aug 11, 2010 at 4:36 AM, Luc Boudreau <lucboudreau at gmail.com> wrote:
>
> 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
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>