Hi, Michael,
FastBit ibis1.2.2 should have support for the operator IN and the test
suite 'check-text' should already have test cases involving two or
more strings as well. Our practice is that the tar ball releases have
to pass all the built-in test suites. I am inclined to guess that
there is something unusual going on.
As the first step to debug the problem, I would suggest you to update
your copy of FastBit to ibis1.3.2.
If you continue to have trouble with the new version, you can ship me
the binary version of your particular text column and the test
queries. I'd be happy to take a look what is going on.
John
On 9/12/12 9:51 AM, Chong, Michael wrote:
> Hi John,
>
> This works ok for me like this:
>
> ibis > SELECT symbol FROM nbbo WHERE symbol in ('A')
> "A"
>
> doQuery:: evaluate(SELECT symbol FROM nbbo WHERE symbol in ('A')) produced
> 50006 hits
> ibis >
>
>
> But when I try with an in statement of more than one symbol:
>
> Select symbol where symbol in ('A', 'AA')
>
> Then I get no filtration and the data returned is simply all the rows in the
> table. Like this:
>
>
> <Stuff deleted>
>
> "LXU"
> "LYB"
> "LYG"
> "LYGPRA"
> "LYTS"
> "LYV"
> "LZB"
> "LZEN"
>
> doQuery:: evaluate(SELECT symbol FROM nbbo WHERE symbol in ('A', 'AA'))
> produced 48230909 hits
> ibis >
>
> I wrote the director using Fastbit version 1.2.2. Would this make a
> difference. Or am I doing something wrong.
>
> If I use an = like this:
>
> ibis > select symbol where symbol = A
> "A"
>
> doQuery:: evaluate(SELECT symbol FROM nbbo WHERE symbol = A) produced 50006
> hits
>
> Then it also works fine ...
>
> Best, Mike.
>
> DISCLAIMER: This e-mail message and any attachments are intended solely for
> the use of the individual or entity to which it is addressed and may contain
> information that is confidential or legally privileged. If you are not the
> intended recipient, you are hereby notified that any dissemination,
> distribution, copying or other use of this message or its attachments is
> strictly prohibited. If you have received this message in error, please
> notify the sender immediately and permanently delete this message and any
> attachments.
> _______________________________________________
> 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
