Cassandra
  1. Cassandra
  2. CASSANDRA-4210

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

    Details

    • Type: Improvement Improvement
    • Status: Resolved
    • Priority: Minor Minor
    • Resolution: Fixed
    • Fix Version/s: 2.0.1
    • Component/s: Core
    • 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
      1. 4210.txt
        47 kB
        Sylvain Lebresne

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development