Re: [MonetDB-users] wrong results for group by queries

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