[Mondrian] Mondrian 4 dialect issue

Tom Barber(Alabs) tom at analytical-labs.com
Wed Jun 5 09:09:02 EDT 2013


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


More information about the Mondrian mailing list