Hi John, the point is exactly in using e007id2, which is missing in the data set. We are working with the use case where EXISTS clause comes to play. When the column is missing in the data set (just like when e007id2 in this case), we need consistent behavior, preferably a result with zero rows.
Best regards, Petr On Sat, May 9, 2015 at 3:30 AM, K. John Wu <[email protected]> wrote: > 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 >
_______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
