Dear Bao Toan Nguyen, I created a small data partition with the numbers you've mentioned in your questions and tried to query then with
ibis -d directory -v -q "here M = 144115188075857871ULL OR M = 144115188075857872ULL" The results seem to be correct. The test case is recorded as really-small case 13. You can take a look at the tests/Makefile.am to find this test case. If you are on a Unix-like machine, you should be able to run the test case with make really-small in the directory tests or simply type 'make check'. Feel free to let me know if you have any additional questions. John On 1/16/12 12:01 AM, bao toan nguyen wrote: > Dear ,K. John Wu ! > > i have replace expression " *where MaTB = 144115188075857871ULL OR > MaTB = 144115188075857872ULL*", but num result =-1 ! > i use *"where MaTB = 144115188075857871 OR MaTB = > 144115188075857872*", return result TRUE ! > *but* i use *"where MaTB between 144115188075857871 and > 144115188075857872*" , return result false. i really don't known how > to use to true. > > thanks very much K. John Wu has reply mail for me. > best regards ! > > 2012/1/16 K. John Wu <[email protected] <mailto:[email protected]>> > > Dear Bao Toan Nguyen, > > The basic problem is that the integer constants you are using are too > long to fit in a double precision floating-point number which is used > to store most of the constants inside FastBit. You can try the > following (to replace your expression) > > where MaTB = 144115188075857871ULL OR MaTB = 144115188075857872ULL > > The restriction is that you have to indicate these numbers are > "unsigned long long" with the ULL suffix and you can only use these > numbers in equality expressions shown above. > > Hope this helps. > > John > > PS: Please send your email to the mailing list, it might help > others too. > > > On 1/15/12 7:06 PM, bao toan nguyen wrote: > > Hi ,K. John Wu ! > > > > I use function "fastbit_build_query" in field ULong(name feild : > > 'MaTB") with swhere=" MaTB between *144115188075857871 * and > > *144115188075857872* ", but in result of query have value " > > *144115188075857888* " ??? > > I don't know why have this value ??? > > (i build index for "MaTB" with mode:=" <binning none/><encoding > range/>") > > > > thanks very much team FastBit was supported . > > best regards ! > > > > 2012/1/5 K. John Wu <[email protected] <mailto:[email protected]> > <mailto:[email protected] <mailto:[email protected]>>> > > > > Hi, Bao Toan Nguyen, > > > > Thanks for your interest in FastBit software. > > > > Based on what you have said, it is likely that your queries > can be > > answered with indexes built by FastBit, however, the data > records you > > want to retrieve are actually scatter around in the data files. > > Effectively, FastBit has to read the whole data file and > then pick out > > the entries you want. A strategy to improve the retrieval > speed is to > > reorganize the data records so that you don't have read the > whole data > > file. > > > > Hope this helps. > > > > John > > > > > > > > On 1/4/12 7:04 PM, bao toan nguyen wrote: > > > hi ! K. John Wu > > > > > > I use FastBit 2.4, when use Query is very very fast ,but i get > > records > > > of this Query very very slowly(i use function > > > fastbit_get_qualified_xxxx ). ??? > > > > > > what's function use to get records of Query to fast ? > > > > > > best regards ! > > > > > > > > > > -- > > Nguyen Bao Toan. > > > > > -- > Nguyen Bao Toan. _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
