Gavin Casey created CASSANDRA-6706:
--------------------------------------
Summary: 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
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.1.5#6160)
