[CASSANDRA-4210] Support for variadic parameters list for "in clause" in prepared cql query

• Type: Improvement
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.0.1

Environment

prepared cql queries

• Assignee: Sylvain Lebresne Assign to me
• Reporter: Pierre Chalamet

Authors

Sylvain Lebresne

Reviewers

Aleksey Yeschenko

• Created: 02/May/12 16:32
• Updated: 16/Apr/19 09:32
• Resolved: 18/Sep/13 15:56

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

Issue Links

• relates to: CASSANDRA-6393 Invalid metadata for IN ? queries