[jira] [Comment Edited] (CASSANDRA-4210) Support for variadic parameters list for "in clause" in prepared cql query

["Alexandre Gaudencio (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-4210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14212243#comment-14212243 ] 

Alexandre Gaudencio edited comment on CASSANDRA-4210 at 11/14/14 1:32 PM:
--------------------------------------------------------------------------

Thanks. I'm quite convinced that this is related to the nodejs driver so I'll just report this on github.

[edit] Sorry for the edit but there's no place on the github repo to open issues for the nodejs driver. Do you know what the best place is to reach the team in charge of this driver ?


was (Author: shahor):
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)