cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gavin Casey (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-6706) Duplicate rows returned when in clause has repeated values
Date Fri, 14 Feb 2014 08:53:19 GMT
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)

Mime
View raw message