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
