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
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