[CASSANDRA-5718] Cql3 reader returns duplicate rows if the cluster column is reversed

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 1.2.9
• Severity: Normal
• Assignee: Alex Liu
• Reporter: Alex Liu

Authors

Alex Liu

Reviewers

Jonathan Ellis

• Created: 02/Jul/13 16:57
• Updated: 16/Apr/19 09:32
• Resolved: 05/Aug/13 22:00

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 cloned by: CASSANDRA-7100 Regression in 2.0.x - Cql3 reader returns duplicate rows if the cluster column is reversed