Hi John, This fixed the problem, thank you very much!
Petr On Sat, Oct 25, 2014 at 10:04 AM, K. John Wu <[email protected]> wrote: > 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 >
_______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
