Re: Varchar indexed column and IN(...)

2012-09-24 Thread Sylvain Lebresne
On Sun, Sep 23, 2012 at 11:30 PM, aaron morton wrote: > If this is intended behavior, could somebody please point me to where this > is > documented? > > It is intended. It is not in fact. We should either refuse the query as "yet unsupported" or we should do the right thing, but returning nothin

Re: Varchar indexed column and IN(...)

2012-09-23 Thread aaron morton
> If this is intended behavior, could somebody please point me to where this is > documented? It is intended. The docs don't make it totally clear though: syntax is: { = | < | > | <= | >= } IN ( [,...]) http://www.datastax.com/docs/1.1/references/cql/SELECT the key_value means only the pr

Varchar indexed column and IN(...)

2012-09-22 Thread Sergei Petrunia
Hello, Does CQL's IN(...) predicate have the same meaning as SQL's IN(...)? I'm asking this, because I get results that I cannot explain: cqlsh:xpl1> select * from t1 where col2='bar1'; pk | col1 | col2 --+--+-- pk1b | foo1 | bar1 pk1 | foo1 | bar1 pk1a | foo1 | bar1 pk1c | f