[ https://issues.apache.org/jira/browse/CASSANDRA-4210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis updated CASSANDRA-4210: -------------------------------------- Reviewer: iamaleksey > Support for variadic parameters list for "in clause" in prepared cql query > -------------------------------------------------------------------------- > > Key: CASSANDRA-4210 > URL: https://issues.apache.org/jira/browse/CASSANDRA-4210 > Project: Cassandra > Issue Type: Improvement > Components: Core > Affects Versions: 1.1.0 > Environment: prepared cql queries > Reporter: Pierre Chalamet > Assignee: Sylvain Lebresne > Priority: Minor > Fix For: 2.0.1 > > Attachments: 4210.txt > > > This query > {code} > select * from Town where key in (?) > {code} > 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 -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira