[ https://issues.apache.org/jira/browse/CASSANDRA-4210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14212243#comment-14212243 ]
Alexandre Gaudencio commented on CASSANDRA-4210: ------------------------------------------------ Thanks. I'm quite convinced that this is related to the nodejs driver so I'll just report this on github. > 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 was sent by Atlassian JIRA (v6.3.4#6332)