[Mondrian] Mondrian Build Failed
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.
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:
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
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
"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>
"'Thiyagu P'" <thiyagu at gmail.com>
mondrian at pentaho.org
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
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
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.
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?
> -----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
> 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 ->
> Mondrian mailing list
> <mailto:Mondrian at pentaho.org> Mondrian at pentaho.org
Mondrian mailing list
Mondrian at pentaho.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Mondrian