Hi, speaking of optimizer bugs, I'm afraid I've got at least one more (some lines removed for readability): sql>select count(distinct x) from a; 3 sql>select count(x) from a; 6 sql>select count(x), count(distinct x) from a; 6|6 The expected answer is "6|3". If everybody agrees, I'll file a bug? Daniel Franck Routier wrote:
Hi,
Le jeudi 05 mai 2011 à 16:18 +0200, Stefan.Manegold@cwi.nl a écrit :
Hi,
please bear with us. We're also only humans with 24 hours to spend per day. ;-)
Sure Stefan, there was no intent to be rude or look demanding. I'm conscious this is a FOSS project, and a very interesting one. It's just that returning unreliable results is rather embarrassing for a database :-)
I suppose this is a bug; looks like it might be a too eager attempt to (in this case, i.e., after the join, incorrectly) exploit the uniqueness of the primary key of table c when determining the groups.
Could you --- Franck or Daniel --- please file a bug report using Daniel's detailed example?
I'll let Daniel do this as he picked it up first !
Thanks,
Franck
------------------------------------------------------------------------------ WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users