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

Support for variadic parameters list for "in clause" in prepared cql query

    Details

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

      prepared cql queries

      Description

      This query

      select * from Town where key in (?)
      

      only allows one parameter for '?'.

      This means querying for 'Paris' and 'London' can't be executed in one step with this prepared statement.

      Current workarounds are:

      • either execute the prepared query 2 times with 'Paris' then 'London'
      • or prepare a new query select * from Town where key in (?, ?) and bind the 2 parameters

      Having a support for variadic parameters list with in clause could improve performance:

      • single hop to get the data
      • // fetching server side

        Attachments

        1. 4210.txt
          47 kB
          Sylvain Lebresne

          Issue Links

            Activity

              People

              • Assignee:
                slebresne Sylvain Lebresne
                Reporter:
                pchalamet Pierre Chalamet
                Reviewer:
                Aleksey Yeschenko
              • Votes:
                5 Vote for this issue
                Watchers:
                12 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: