Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Tue, 14 Jun 2016 07:47:44 +0000 (UTC)
From: "Bhuvan Rawal (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12978647.1465890448000.446.1465890464237@Atlassian.JIRA>
In-Reply-To: <JIRA.12978647.1465890448000@Atlassian.JIRA>
References: <JIRA.12978647.1465890448000@Atlassian.JIRA> <JIRA.12978647.1465890448076@arcas>
Subject: [jira] [Created] (CASSANDRA-12003) Not filtering Data completely
 when where clause is applied to clustering column
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Tue, 14 Jun 2016 07:47:46 -0000

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)