You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Michael Shuler (JIRA)" <ji...@apache.org> on 2013/11/13 22:09:22 UTC
[jira] [Commented] (CASSANDRA-6327) select with "in" clause wrongly
returns empty result
[ https://issues.apache.org/jira/browse/CASSANDRA-6327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13821837#comment-13821837 ]
Michael Shuler commented on CASSANDRA-6327:
-------------------------------------------
0001-check-if-any-of-the-slices-intersects.patch fixes KeyspaceTest for me on current cassandra-2.0 branch (1d3a4dd). This is the only test I have run, at the moment :)
[junit] Testsuite: org.apache.cassandra.db.KeyspaceTest
[junit] Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 23.567 sec
> 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)