Hi, Petr, I have tried to run your queries on the data you shared with us some time ago in 259.tgz. In this case, I change e007id2 to e007id1. In this case, I am getting the same results from the two queries. Would you mind share a sample data set with us?
Thanks. John On 5/7/15 4:53 AM, Petr Velan wrote: > Hi John, > > I've run into a problem with where filter on the latest libfastbit > version. The following queries should return the same result. However, > the first one fails and the second one returns an empty table, which > is the expected behavior. > > thula -d . -s " e0id1" -w "(EXISTS(e007id2) and (e007id2 LIKE > 'www.google.com <http://www.google.com>')) and (EXISTS(e007id2) and > (e007id2 LIKE 'www.google.com <http://www.google.com>'))" > doQuery((EXISTS(e007id2) and (e007id2 LIKE 'www.google.com > <http://www.google.com>')) and (EXISTS(e007id2) and (e007id2 LIKE > 'www.google.com <http://www.google.com>'))) failed to produce any result > > thula -d . -s " e0id1" -w "(EXISTS(e007id2) and (e007id2 LIKE > 'www.google.com <http://www.google.com>'))" > doQuery((EXISTS(e007id2) and (e007id2 LIKE 'www.google.com > <http://www.google.com>'))) evaluated on T-259 produced 0 hit out of 4 > records > -- begin printing the result table -- > Table UVlcU (filter::sift2) contains 0 row and no column > -- end printing -- > > This issue can be reproduced with the data set provided for the > previous issue "Failed aggregation query" (sent on 27.4.2015). > > I've managed to produce this issue even by reordering some terms > around an "and" in the filter. Could you take a look at this? > > Thank you very much in advance, > 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
