[Mondrian] Mondrian 4 dialect issue

[Tom Barber(Alabs)]

I knew that was coming.. I'll put the kettle on.... ;)

On 05/06/13 15:46, Luc Boudreau wrote:
> Can you reproduce this on FoodMart? I'd like to create an item in Jira 
> so we address this ASAP.
>
>
> On Wed, Jun 5, 2013 at 10:03 AM, Tom Barber(Alabs) 
> <tom at analytical-labs.com <mailto:tom at analytical-labs.com>> wrote:
>
>     Hi Luc, the SQL itself I'd stripped out,
>
>     All I'm doing it putting a Level.Member  on Rows and a Measure on
>     the columns.
>
>     And I get:
>     Caused by: mondrian.olap.MondrianException: Mondrian Error:Failed
>     to load segment form SQL
>             at
>     mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:643)
>             at
>     mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:195)
>             ... 8 more
>     Caused by: mondrian.olap.MondrianException: Mondrian
>     Error:Internal error: Error while loading segment; sql=[select
>     `LKP_PATH`.`PATH_ID` as `c0`,
>     count(`FCT_RESUMEUPLOAD`.`FACT_RESUMEUPLOAD_KEY`) as `m0` from
>     `LKP_PATH` as `LKP_PATH_1`, `FCT_RESUMEUPLOAD` as
>     `FCT_RESUMEUPLOAD` where `FCT_RESUMEUPLOAD`.`PATH_KEY` =
>     `LKP_PATH`.`PATH_KEY` and `LKP_PATH`.`PATH_ID` = 'hello' group by
>     `LKP_PATH`.`PATH_ID`]
>
>     Thats the real SQL generated. I'm using the latest Mondrian 4 +
>     Saiku build from our CI, its tagged 4.0.0-SNAPSHOT so I don't know
>     what exact Mondrian 4 build it used but it was built 11 hours ago.
>
>     mysql  Ver 14.14 Distrib 5.5.31, for Linux (x86_64) using readline 5.1
>
>     I was actually trying to debug another issue for a client, but I
>     can't even run this query.
>
>     Cheers
>
>     Tom
>
>
>
>     On 05/06/13 14:46, Luc Boudreau wrote:
>>     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 <mailto: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 <mailto:Mondrian at pentaho.org>
>>         http://lists.pentaho.org/mailman/listinfo/mondrian
>>
>>
>>
>>
>>     _______________________________________________
>>     Mondrian mailing list
>>     Mondrian at pentaho.org  <mailto:Mondrian at pentaho.org>
>>     http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
>     _______________________________________________
>     Mondrian mailing list
>     Mondrian at pentaho.org <mailto:Mondrian at pentaho.org>
>     http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
>
>
> _______________________________________________
> 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/d75d073b/attachment.html