search

lukefitzwolfgang / icatproject

Automatically exported from code.google.com/p/icatproject
0 stars 0 forks source link

The DISTINCT keyword messes up aggregate queries #141

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Previously the authz rules were causing multiples copies of an entity to be 
returned. To circumvent this the DISTINCT keyword was added to queries. This is 
harmless most of the time but not with the SUM aggregate function. The solution 
is probably to avoid the "DISTINCT" hack.

Original issue reported on code.google.com by dr.s.m.f...@gmail.com on 31 Jul 2014 at 2:42

GoogleCodeExporter commented 9 years ago 
This is now fixed - it required quite a bit of messy code.

Original comment by dr.s.m.f...@gmail.com on 6 Oct 2014 at 4:24

GoogleCodeExporter commented 9 years ago 
All these are now released

Original comment by dr.s.m.f...@gmail.com on 9 Dec 2014 at 1:54