[jira] [Created] (CASSANDRA-12003) Not filtering Data completely when where clause is applied to clustering column

["Bhuvan Rawal (JIRA)" <ji...@apache.org>]

Bhuvan Rawal created CASSANDRA-12003:
----------------------------------------

             Summary: Not filtering Data completely when where clause is applied to clustering column
                 Key: CASSANDRA-12003
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-12003
             Project: Cassandra
          Issue Type: Bug
          Components: Local Write-Read Paths
         Environment: Production
            Reporter: Bhuvan Rawal
             Fix For: 3.8


On issuing this query:;

select id,filter_name from navigation_bucket_filter where id=2429 and filter_name='Size_s';

 id   | filter_name
------+----------------------
 2429 | AdditionalProperty_s
 2429 |                Brand
------------more rows-------
 2429 |               Size_s
------------more rows-------
 2429 |         sdFullfilled
 2429 |           sellerCode

(16 rows)

Whereas only one result was expected (Row bearing filter_name - Size_s), we got that result but along with 15 other unexpected rows..

Total number of rows in the partition are 20 (Verified using select id,filter_name from navigation_bucket_filter where id=2429;) as well as json dump. We are wondering why Cassandra could not filter the results completely. I have checked that the data is intact by taking json dump and validating using sstabledump tool. 




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)