Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-6050

'Internal application error' on SELECT .. WHERE col1=val AND col2 IN (1,2)

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Fix Version/s: 2.0.1
    • Component/s: None
    • Labels:
    • Environment:

      cqlsh, pdo_cassandra

    • Severity:
      Normal

      Description

      Query with error: SELECT * FROM user WHERE login='nsv' AND st IN ('1','2') ALLOW FILTERING;

      Query works:
      SELECT * FROM user WHERE login='nsv' AND st IN ('1') ALLOW FILTERING;
      – Single item inside IN

      Table definition:
      CREATE COLUMNFAMILY user (
      KEY uuid PRIMARY KEY,
      name text,
      avatar text,
      email text,
      phone text,
      login text,
      pw text,
      st text
      );

      From /var/log/cassandra/output.log:
      ERROR 11:58:52,454 Internal error processing execute_cql3_query
      java.lang.AssertionError
      at org.apache.cassandra.cql3.statements.SelectStatement.getIndexExpressions(SelectStatement.java:749)
      at org.apache.cassandra.cql3.statements.SelectStatement.getRangeCommand(SelectStatement.java:303)
      at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:155)
      at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:56)
      at org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:101)
      at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:117)
      at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:108)
      at org.apache.cassandra.thrift.CassandraServer.execute_cql3_query(CassandraServer.java:1920)
      at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql3_query.getResult(Cassandra.java:4372)
      at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql3_query.getResult(Cassandra.java:4356)
      at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
      at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
      at org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:194)
      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:724)

        Attachments

        1. 6050.txt
          2 kB
          Sylvain Lebresne

          Activity

            People

            • Assignee:
              slebresne Sylvain Lebresne
              Reporter:
              nsv Sergey Nagaytsev
              Authors:
              Sylvain Lebresne
              Reviewers:
              Aleksey Yeschenko
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: