[Mondrian] Mondrian 4 dialect issue
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?
> Mondrian mailing list
> Mondrian at pentaho.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Mondrian