Hi, It is not a bug. Equality on floats/doubles won't work because they are IEEE float values and the displayed value may not be the same (read is not usually the same) as the internally stored value. This is a problem common to all databases that use IEEE values to store floating point numbers. Many databases offer a fixed point data type to work around this (in MySQL it is the DECIMAL type) but FastBit doesn't have such a data type.
--Justin On Wed, Feb 24, 2016 at 1:23 PM, Sean Davey <[email protected]> wrote: > hi all, > > I’m trying to find multiple min or max values in my index. I do a query > like “select min(value1)” which works fine and returns a value such as > 0.35135729403, which is correct. However, when I try to find all the lines > with that value with a query like “select chr,start,stop,value1 where > value1=0.35135729403”, I get zero hits. In the output of the second query I > see the line "From csv Where value1 == 0.351357 --> 0” so it appears that > the value I’m searching for has been truncated. > > Please let me know if this is a bug and if so, if it can be fixed. > > thanks, > Sean Davey > Bio5 Institute, University of Arizona, Tucson > [email protected] > > _______________________________________________ > 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
