Hi, Rock, Looks like you might have hit some sort of limit - even though as a program I have not imposed any limit, however, there are probably something coming from either command-line or from lex/yacc (flex/bison) implementation.
One alternative I can suggest is for you to directly pass the list to a constructor of ibis::qDiscreteRange -- the expression "colA in (1,2,3,4..)" is internally presented by an ibis::qDiscreteRange. Bypassing the parser will also reduce the query processing time.. John On 3/28/12 12:08 PM, Rock Wang wrote: > Hi John, > > Is there a limit on the length of where clause and the number of > entries in statement, like where colA in (1,2,3,4,5). > Currently, if we passes in 400 numbers in the "IN" statement, fastbit > returns 0 rows, where it returns hits if the number is 100. > > Do you know where could go wrong, the 100 entries is subset of the 400 > entries. > > Thanks, > Rock _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
