Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Mon, 25 Nov 2013 20:46:36 +0000 (UTC)
From: "Marcus Eriksson (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12678465.1384105359807.25900.1385412396050@arcas>
In-Reply-To: <JIRA.12678465.1384105359807@arcas>
References: <JIRA.12678465.1384105359807@arcas>
Subject: [jira] [Commented] (CASSANDRA-6327) select with "in" clause wrongly
 returns empty result
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/CASSANDRA-6327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13831890#comment-13831890 ] 

Marcus Eriksson commented on CASSANDRA-6327:
--------------------------------------------

there is logic in 2.0 to be able to skip sstables on the read path, a (major) compaction means there is only one sstable, and it wont be skipped since atleast one of slices will intersect it

> select with "in" clause wrongly returns empty result
> ----------------------------------------------------
>
>                 Key: CASSANDRA-6327
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6327
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>         Environment: Cassandra 2.0.2, x86-64 Ubuntu 13.10
>            Reporter: Duncan Sands
>            Assignee: Sylvain Lebresne
>             Fix For: 2.0.3
>
>         Attachments: 0001-check-if-any-of-the-slices-intersects.patch, 6327.txt, current_prices.tar
>
>
> This query returns no result:
> cqlsh:tick_data> select syd from current_prices where shard = 1 and syd in (1, 556129);
> (0 rows)
> However this query does return a result, showing that the previous query was wrong to return no result:
> cqlsh:tick_data> select syd from current_prices where shard = 1 and syd in (556129);
>  syd
> --------
>  556129
> (1 rows)
> This can be reproduced as follows:
> (a) Create a keyspace tick_data:
> create keyspace tick_data WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1};
> (b) Create a table current_prices:
> CREATE TABLE current_prices (
>   shard int,
>   syd int,
>   ask decimal,
>   bid decimal,
>   currency ascii,
>   when timeuuid,
>   PRIMARY KEY (shard, syd)
> );
> (c) Stop Cassandra and untar the attached tar file in /var/lib/cassandra/data/tick_data/.  It populates the current_prices table.
> (d) Restart Cassandra and perform the above selects.


--
This message was sent by Atlassian JIRA
(v6.1#6144)