Hi, Petr, Thanks for the carefully prepared report. The problem you've reported is due to a corner in in some sorting functions. A fix has been checked into the SVN repository. Please retrieve the source code from the SVN repository and give it a try.
John PS: Here is the command to retrieve the source code form SVN svn checkout https://codeforge.lbl.gov/anonscm/fastbit On 10/21/14 7:59 AM, Petr Velan wrote: > Hi John, > > we came across strange bug during aggregation. Tested revision is 752, > data sample is attached. Steps to reproduce: > > $ ibis -d 261/ -q "SELECT e0id11, e0id8, sum(e0id1) WHERE > ((EXISTS(e0id8) and ((e0id8 > 2482700288) and (e0id8 < 2482765823))))" > -o result > > $ grep 2482700573 result > 80, 2482700573, 659 > 80, 2482700573, 34311 > > This is wrong, since both lines should be summed up. > However, following works: > > $ ibis -d 261/ -q "SELECT e0id8, sum(e0id1) WHERE ((EXISTS(e0id8) and > ((e0id8 > 2482700288) and (e0id8 < 2482765823))))" -o result > > $ grep 2482700573 result > 2482700573, 34970 > > And even the following works (the lower range in filter is different) > $ ibis -d 261/ -q "SELECT e0id11, e0id8, sum(e0id1) WHERE > ((EXISTS(e0id8) and ((e0id8 > 248270028) and (e0id8 < 2482765823))))" > -o result > > $ grep 2482700573 result > 80, 2482700573, 34970 > > > I hope this helps, let me know if you need more info. > > Petr > > > > _______________________________________________ > FastBit-users mailing list > [email protected] > https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users > _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
