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

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

Log workAgile BoardRank to TopRank to BottomAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Normal
    • Resolution: Fixed
    • 2.0.1
    • None
    • cqlsh, pdo_cassandra

    • 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

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            slebresne Sylvain Lebresne Assign to me
            nsv Sergey Nagaytsev
            Sylvain Lebresne
            Aleksey Yeschenko
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment