[Mondrian] Mondrian 4 dialect issue

Luc Boudreau lucboudreau at gmail.com
Wed Jun 5 09:46:53 EDT 2013

Where is that SQL generated? Is this a tuple query? This looks like a bug;
not a dialect issue.


On Wed, Jun 5, 2013 at 9:09 AM, Tom Barber(Alabs)
<tom at analytical-labs.com>wrote:

> Hello Mondrian fans,
> I'm trying to get a schema running under Mondrian 4 and Mysql and when a
> query is run its generating SQL like this:
> select `LKP_PATH`.`PATH_ID` as `c0` from `LKP_PATH` as `LKP_PATH_1`;
> which MySQL is getting upset over because the table name at the start of
> the select isn't the aliased table name but the original:
>   select `LKP_PATH_1`.`PATH_ID` as `c0` from `LKP_PATH` as `LKP_PATH_1`;
> The above is a valid query.
> Any property I can set to get this working?
> Thanks
> Tom
> _______________________________________________
> 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/20130605/3a16bdf0/attachment.html 

More information about the Mondrian mailing list