[Mondrian] Mondrian Build Failed

Tue May 22 11:37:07 EDT 2007

On mysql it fails the test: 

junit.framework.AssertionFailedError
        at 
mondrian.test.DialectTest.testRequiresFromQueryAlias(DialectTest.java:199)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

Mysql (5.0.27-community on windows) supports following query. It requires 
alias (Every derived table must have its own alias).

        select * from (select * from account) as account2

SqlQuery (#80) - line 1152 - I suppose we don't need "!isMySQL()" in 
method allowsFromQuery

Ajit

"Julian Hyde" <julianhyde at speakeasy.net> 
Sent by: mondrian-bounces at pentaho.org
05/22/2007 01:02 PM
Please respond to
Mondrian developer mailing list <mondrian at pentaho.org>

To
"'Thiyagu P'" <thiyagu at gmail.com>
cc
mondrian at pentaho.org
Subject
RE: [Mondrian] Mondrian Build Failed

Hmmm, I thought I was seeing a whole load of failures.

If DialectTest.testAllowsDdl() is the only problem, then I've fixed it. A 
long time ago Access would disallow DDL, but I guess that's because the 
.mdb file was read-only. I've fixed the Dialect to use 
DatabaseMetaData.isReadOnly().

Julian

From: Thiyagu P [mailto:thiyagu at gmail.com] 
Sent: Monday, May 21, 2007 10:16 PM
To: Julian Hyde
Cc: mondrian at pentaho.org
Subject: Re: [Mondrian] Mondrian Build Failed

Julian,

Debugged DialectTest.testAllowsDdl(),

Is the sql "create table [foo] ([i] integer)" expected to fail with 
Access? It executes fine in Access 2003.  Looks like this is the cause for 
the test failures.

- Thiyagu

On 5/22/07, Julian Hyde <julianhyde at speakeasy.net> wrote: 
This looks like an environmental issue. The tests are running OK for me
on Access. Thiyagu, can you take a look at it? 

Julian

> -----Original Message-----
> From: mondrian-bounces at pentaho.org
> [mailto:mondrian-bounces at pentaho.org ] On Behalf Of
> NoReply-Mondrian-CruiseControl
> Sent: Sunday, May 20, 2007 1:18 PM
> To: @; mondrian at pentaho.org
> Subject: [Mondrian] Mondrian Build Failed 
> Importance: High
>
> View results here ->
> http://cruisecontrol.hydromatic.net/buildresults/mondrian?log=
> log20070520130436 
> _______________________________________________
> Mondrian mailing list
> 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/20070522/31feb0f4/attachment.html 