[CASSANDRA-7100] Regression in 2.0.x - Cql3 reader returns duplicate rows if the cluster column is reversed

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.0.8, 2.1 rc1
• Severity: Normal
• Assignee: Alex Liu
• Reporter: Rohit Rai

Authors

Alex Liu

Reviewers

Piotr Kolaczkowski

• Created: 27/Apr/14 18:15
• Updated: 16/Apr/19 09:31
• Resolved: 20/May/14 16:15

Description

To reproduce it,

cqlsh:test> select * from wordfreq;

title | occurances | word
------------------------
alex123 | 4 | liu3
alex1 | 23456 | liu2
alex10 | 10 | liu10
alex12 | 34 | liu3
alex | 123456 | liu1
alex | 1000 | liu

CREATE TABLE wordfreq ( title text, word text, occurances int, PRIMARY KEY (title,occurances)) WITH CLUSTERING ORDER by (occurances DESC);

The hadoop job returns 7 rows instead of 6 rows.

I will post a patch soon.

Issue Links

• is a clone of: CASSANDRA-5718 Cql3 reader returns duplicate rows if the cluster column is reversed