[ https://issues.apache.org/jira/browse/CASSANDRA-6327?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Duncan Sands updated CASSANDRA-6327: ------------------------------------ Attachment: current_prices.tar Untar this file to populate the current_prices table. > 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 > Attachments: 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)