[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.

Luc


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