You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Benjamin Lerer (JIRA)" <ji...@apache.org> on 2015/01/21 12:26:35 UTC
[jira] [Updated] (CASSANDRA-6706) Duplicate rows returned when in
clause has repeated values
[ https://issues.apache.org/jira/browse/CASSANDRA-6706?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Benjamin Lerer updated CASSANDRA-6706:
--------------------------------------
Attachment: CASSANDRA-6706-trunk.txt
CASSANDRA-6706-2.1.txt
The patch for 2.1 make sure that Cassandra will log a warning the first time a user execute a query containing an IN restriction with duplicate values on the primary key.
The patch for trunk add unit tests to check the behavior and fix the {{CHANGES.txt}} files.
> Duplicate rows returned when in clause has repeated values
> ----------------------------------------------------------
>
> Key: CASSANDRA-6706
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6706
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: Found on
> [cqlsh 4.1.0 | Cassandra 2.0.3-SNAPSHOT | CQL spec 3.0.0 | Thrift protocol 19.38.0]
> Reporter: Gavin Casey
> Assignee: Benjamin Lerer
> Labels: cql
> Fix For: 3.0
>
> Attachments: CASSANDRA-6706-2.1.txt, CASSANDRA-6706-trunk.txt
>
>
> If a value is repeated within an IN clause then repeated rows are returned for the repeats:
> cqlsh> create table t1(c1 text primary key);
> cqlsh> insert into t1(c1) values ('A');
> cqlsh> select * from t1;
> c1
> ----
> A
> cqlsh> select * from t1 where c1 = 'A';
> c1
> ----
> A
> cqlsh> select * from t1 where c1 in( 'A');
> c1
> ----
> A
> cqlsh:dslog> select * from t1 where c1 in( 'A','A');
> c1
> ----
> A
> A
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)