[Mondrian] Mondrian Build Failed

Julian Hyde julianhyde at speakeasy.net
Tue May 22 19:02:28 EDT 2007


This is one instance where the DialectTest has noticed that a DBMS's
capabilities have changed: MySQL 4.0 and onwards supports subqueries in
the FROM clause. But the check doesn't disppear entirely, because we
still need to handle MySQL versions before 4.0. 
 
Fixed in change 9303.
 
Julian


  _____  

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of Ajit Vasudeo Joglekar
Sent: Tuesday, May 22, 2007 8:37 AM
To: Mondrian developer mailing list
Subject: RE: [Mondrian] Mondrian Build Failed



On mysql it fails the test: 

junit.framework.AssertionFailedError 
        at
mondrian.test.DialectTest.testRequiresFromQueryAlias(DialectTest.java:19
9) 
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39) 
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.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 < <mailto:julianhyde at speakeasy.net>
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:  <mailto:mondrian-bounces at pentaho.org>
mondrian-bounces at pentaho.org
> [mailto: <mailto:mondrian-bounces at pentaho.org>
mondrian-bounces at pentaho.org ] On Behalf Of
> NoReply-Mondrian-CruiseControl
> Sent: Sunday, May 20, 2007 1:18 PM
> To: @;  <mailto:mondrian at pentaho.org> mondrian at pentaho.org
> Subject: [Mondrian] Mondrian Build Failed 
> Importance: High
>
> View results here ->
>  <http://cruisecontrol.hydromatic.net/buildresults/mondrian?log=>
http://cruisecontrol.hydromatic.net/buildresults/mondrian?log=
> log20070520130436 
> _______________________________________________
> Mondrian mailing list
>  <mailto:Mondrian at pentaho.org> Mondrian at pentaho.org
>  <http://lists.pentaho.org/mailman/listinfo/mondrian>
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/bc26904b/attachment.html 


More information about the Mondrian mailing list