Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Sun, 10 Nov 2013 17:43:17 +0000 (UTC)
From: "Duncan Sands (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12678465.1384105359807.48705.1384105396979@arcas>
In-Reply-To: <JIRA.12678465.1384105359807@arcas>
References: <JIRA.12678465.1384105359807@arcas>
Subject: [jira] [Created] (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

Duncan Sands created CASSANDRA-6327:
---------------------------------------

             Summary: 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


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)