Re: [MonetDB-users] functions in group by

I concur with the observation. All but a few out of the 2000 sql test queries for Mondrian worked using its functionality to accommodate different sql dialects. What version of Mondrian are you using? Which tests in Mondrian's test suite fail in your case? Can you provide the complete test suite coverage report? regards, Martin Stefan de Konink wrote:

We had the Mondrian testsuite running with a dialect. Do you know what test fails?

Stefan

Op 21 sep 2009 om 09:51 heeft Franck Routier het volgende geschreven:\

...

Hi,

I am working with Mehmet on Monetdb / Mondrian tests.

So, to sum up:

1) functions in group by are not supported in ansi sql standard (I take your words on this :-)

2) on the contrary, column aliases in group by are not supported by some major rdbms, eg. Oracle and MS Sqlserver (while functions in group by are)

3) some rdbms support both (eg. Postgresql)

4) Mondrian, as a ROLAP tool, generate sql queries and make great use of aggregates. Those queries contain functions in group by (not standard, but works on Oracle, Sqlserver, Postgres, etc.)

So if I understand you, supporting functions in group by in Monetdb would not be a trivial task... Do you confirm we should not count on it (unless we propose a patch, I guess) ?

This might well be a showstopper for Mondrian / Monet. A solution might be to change the Mondrian query generator specifically for Monetdb (using a special dialect setting), but it might not be that trivial either (sql generation is widespreaded in mondrian code :-(.

Does this sum up the situation ?

Franck

--- --- --- --------------------------------------------------------------------- Come build with us! The BlackBerry® Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9-12, 2009. Register now! http://p.sf.net/sfu/devconf _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------ Come build with us! The BlackBerry® Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9-12, 2009. Register now! http://p.sf.net/sfu/devconf _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users