You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "DOAN DuyHai (JIRA)" <ji...@apache.org> on 2016/03/22 16:46:25 UTC
[jira] [Created] (CASSANDRA-11401) [Regression] Incorrect results
for clustering tuples query
DOAN DuyHai created CASSANDRA-11401:
---------------------------------------
Summary: [Regression] Incorrect results for clustering tuples query
Key: CASSANDRA-11401
URL: https://issues.apache.org/jira/browse/CASSANDRA-11401
Project: Cassandra
Issue Type: Bug
Components: CQL
Environment: *Cassandra 3.4*
Reporter: DOAN DuyHai
Priority: Critical
There is a regression since *Cassandra 3.4* with query using clustering tuple values:
{noformat}
cqlsh:test> CREATE TABLE IF NOT EXISTS entity_with_clusterings(
id bigint,
uuid uuid,
date timestamp,
value text,
PRIMARY KEY(id, uuid, date))
WITH CLUSTERING ORDER BY(uuid ASC, date DESC);
cqlsh:test> INSERT INTO entity_with_clusterings(id, uuid, date, value) VALUES(3233835834146573312, 00000000-0000-0000-0000-000000000000, '2015-10-01 00:00:00+0000', 'val1');
cqlsh:test> INSERT INTO entity_with_clusterings(id, uuid, date, value) VALUES(3233835834146573312, 00000000-0000-0000-0000-000000000000, '2015-10-02 00:00:00+0000', 'val2');
cqlsh:test> INSERT INTO entity_with_clusterings(id, uuid, date, value) VALUES(3233835834146573312, 00000000-0000-0000-0000-000000000000, '2015-10-03 00:00:00+0000', 'val3');
cqlsh:test> INSERT INTO entity_with_clusterings(id, uuid, date, value) VALUES(3233835834146573312, 00000000-0000-0000-0000-000000000001, '2015-10-04 00:00:00+0000', 'val4');
cqlsh:test> INSERT INTO entity_with_clusterings(id, uuid, date, value) VALUES(3233835834146573312, 00000000-0000-0000-0000-000000000001, '2015-10-05 00:00:00+0000', 'val5');
cqlsh:test> SELECT * FROM entity_with_clusterings;
id | uuid | date | value
---------------------+--------------------------------------+--------------------------+-------
3233835834146573312 | 00000000-0000-0000-0000-000000000000 | 2015-10-03 00:00:00+0000 | val3
3233835834146573312 | 00000000-0000-0000-0000-000000000000 | 2015-10-02 00:00:00+0000 | val2
3233835834146573312 | 00000000-0000-0000-0000-000000000000 | 2015-10-01 00:00:00+0000 | val1
3233835834146573312 | 00000000-0000-0000-0000-000000000001 | 2015-10-05 00:00:00+0000 | val5
3233835834146573312 | 00000000-0000-0000-0000-000000000001 | 2015-10-04 00:00:00+0000 | val4
(5 rows)
cqlsh:test > SELECT uuid,date,value
FROM entity_with_clusterings
WHERE id=3233835834146573312
AND (uuid,date)>=(00000000-0000-0000-0000-000000000000,'2015-10-02 00:00:00+0000')
AND (uuid,date)<(00000000-0000-0000-0000-000000000001, '2015-10-04 00:00:00+0000');
uuid | date | value
--------------------------------------+---------------------------------+-------
00000000-0000-0000-0000-000000000000 | 2015-10-03 00:00:00.000000+0000 | val3
00000000-0000-0000-0000-000000000000 | 2015-10-02 00:00:00.000000+0000 | val2
{noformat}
The same query with *Cassandra 3.3* returns correct answer:
{noformat}
cqlsh:test> SELECT uuid,date,value
FROM entity_with_clusterings
WHERE id=3233835834146573312
AND (uuid,date)>=(00000000-0000-0000-0000-000000000000,'2015-10-02 00:00:00+0000')
AND (uuid,date)<(00000000-0000-0000-0000-000000000001, '2015-10-04 00:00:00+0000');
uuid | date | value
--------------------------------------+--------------------------+-------
00000000-0000-0000-0000-000000000000 | 2015-10-02 00:00:00+0000 | val2
00000000-0000-0000-0000-000000000000 | 2015-10-01 00:00:00+0000 | val1
00000000-0000-0000-0000-000000000001 | 2015-10-05 00:00:00+0000 | val5
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)