Hi Justin, thanks for the reply. I see what you’re saying but I thought it might work in this case because I’m searching for a value I know is in the data. The text I get back from "select min(value1)” is 0.35135729403. That’s the exact same text that is in the original file that was indexed. So shouldn’t the internal representation of that string be the same for indexing and for querying? If I’m querying for a value with the exact same text that was used when the data was indexed, shouldn’t it be found?
btw, the value1 column is a double, not a float. I don’t know if that matters, but I thought of that when I noticed that the output from ibis includes the line "From csv Where value1 == 0.351357 --> 0” which for some reason doesn’t display all of 0.35135729403. cheers, Sean Davey Bio5 Institute, University of Arizona, Tucson [email protected] > On Feb 25, 2016, at 4:46 PM, Justin Swanhart <[email protected]> wrote: > > 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] > <mailto:[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] <mailto:[email protected]> > _______________________________________________ > FastBit-users mailing list > [email protected] <mailto:[email protected]> > https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users > <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
