What version of mondrian? I thought this one was fixed a while ago.
-----Original Message-----
From: ing [mailto:amichalu@poczta.onet.pl]
Sent: Thursday, November 07, 2002 3:39 AM
To: mondrian-devel@lists.sourceforge.net
Subject: [Mondrian-devel] Problems with mysql

During deploying WAR application to Tomcat I found following error :
 
mondrian.resource.Error: Internal error: while counting members of level '[Store].[Store Country]'; sql=[select count(*) as `c0` from (select distinct `store_country` as `c0` from `store` as `Store`) as `foo`]
 
As far as I know MySql server does not support sub-queries.
 
I did not test this with other db server.
 
My soft versions :
 
MySql 3.23.52-nt
Tomcat 4.1.12
 
Adam Michalunio
amichalu@poczta.onet.pl