[ 
https://issues.apache.org/jira/browse/CASSANDRA-5376?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jonathan Ellis updated CASSANDRA-5376:
--------------------------------------

    Reviewer: iamaleksey
    Priority: Minor  (was: Major)
    
> CQL3: IN clause on last key not working when schema includes set,list or map
> ----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-5376
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-5376
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>    Affects Versions: 1.2.3
>            Reporter: Christiaan Willemsen
>            Assignee: Sylvain Lebresne
>            Priority: Minor
>             Fix For: 1.2.4
>
>         Attachments: 5376.txt
>
>
> This is an exception on the fix of 
> https://issues.apache.org/jira/browse/CASSANDRA-5230
> Looks like any schema using map,list or set won't work with IN clauses on the 
> last key (in this example c)
> Schema:
> {code}
> CREATE TABLE foo2 (
>   key text,
>   c bigint,
>   v text,
>   x set<text>,
>   PRIMARY KEY (key, c)
> );
> {code}
> Query:
> {code}select * from foo2 where key = 'foo' and c in (1,3,4) ;{code}
> This will lead to an assertion error on the nodes:
> {code}java.lang.AssertionError
>         at 
> org.apache.cassandra.cql3.statements.SelectStatement.buildBound(SelectStatement.java:540)
>         at 
> org.apache.cassandra.cql3.statements.SelectStatement.getRequestedBound(SelectStatement.java:568)
>         at 
> org.apache.cassandra.cql3.statements.SelectStatement.makeFilter(SelectStatement.java:308)
>         at 
> org.apache.cassandra.cql3.statements.SelectStatement.getSliceCommands(SelectStatement.java:219)
>         at 
> org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:132)
>         at 
> org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:62)
>         at 
> org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:132)
>         at 
> org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:143)
>         at 
> org.apache.cassandra.thrift.CassandraServer.execute_cql3_query(CassandraServer.java:1726)
>         at 
> org.apache.cassandra.thrift.Cassandra$Processor$execute_cql3_query.getResult(Cassandra.java:4074)
>         at 
> org.apache.cassandra.thrift.Cassandra$Processor$execute_cql3_query.getResult(Cassandra.java:4062)
>         at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32)
>         at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34)
>         at 
> org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:199)
>         at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>         at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>         at java.lang.Thread.run(Thread.java:722)
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to