[CASSANDRA-18576] Mixed single-column and multi-column clustering restrictions are not merged correctly

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Cannot Reproduce
• Component/s: CQL/Interpreter
• Platform: All
• Assignee: Piotr Kolaczkowski
• Reporter: Piotr Kolaczkowski

Authors

Piotr Kolaczkowski

• Created: 08/Jun/23 10:15
• Updated: 08/Jun/23 10:30
• Resolved: 08/Jun/23 10:28

Description

During working on CEP-29, I found that single-column and multi-column clustering restrictions are not merged correctly and cause query failures or incorrect results.

The algorithm used in RestrictionSet.mergeRestrictions is incorrect, as its results depend on the (undefined) order of restrictions in a hashset.
In more complex scenarios, when there are more restrictions to merge, the algorithm results can even differ between the test runs.