[CASSANDRA-8613] Regression in mixed single and multi-column relation support

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.0.15, 2.1.5
• Component/s: Legacy/CQL
• Severity: Normal
• Since Version: 2.0.9
• Assignee: Benjamin Lerer
• Reporter: Tom Hobbs

Authors

Benjamin Lerer

Reviewers

Tom Hobbs

• Tester: Shawn Kumar
• Created: 13/Jan/15 16:49
• Updated: 16/Apr/19 09:31
• Resolved: 05/Mar/15 18:37

Description

In 2.0.6 through 2.0.8, a query like the following was supported:

SELECT * FROM mytable WHERE clustering_0 = ? AND (clustering_1, clustering_2) > (?, ?)

However, after CASSANDRA-6875, you'll get the following error:

Clustering columns may not be skipped in multi-column relations. They should appear in the PRIMARY KEY order. Got (c, d) > (0, 0)