[
https://issues.apache.org/jira/browse/CASSANDRA-19878?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Benjamin Lerer updated CASSANDRA-19878:
---------------------------------------
Test and Documentation Plan: The patch add a unit test to cover the problem
Status: Patch Available (was: Open)
> Filtering on clustering columns in reversed order with BETWEEN return invalid
> results
> -------------------------------------------------------------------------------------
>
> Key: CASSANDRA-19878
> URL: https://issues.apache.org/jira/browse/CASSANDRA-19878
> Project: Cassandra
> Issue Type: Bug
> Components: CQL/Interpreter
> Reporter: Benjamin Lerer
> Assignee: Benjamin Lerer
> Priority: Normal
> Fix For: 5.x
>
>
> As noted by [~maedhroz], filtering on clustering columns in reverser order do
> not work properly.
> The problem can be reproduced using the following test:
> {code}
> @Test
> public void testReverseAndBetweenMemtableFiltering()
> {
> createTable("CREATE TABLE %s(p int, c int, c2 int, abbreviation ascii,
> PRIMARY KEY (p, c, c2)) WITH CLUSTERING ORDER BY (c DESC, c2 DESC)");
> execute("INSERT INTO %s(p, c, c2, abbreviation) VALUES (0, 1, 1, 'CA')");
> execute("INSERT INTO %s(p, c, c2, abbreviation) VALUES (0, 2, 2, 'MA')");
> execute("INSERT INTO %s(p, c, c2, abbreviation) VALUES (0, 3, 3, 'MA')");
> execute("INSERT INTO %s(p, c, c2, abbreviation) VALUES (0, 4, 4, 'TX')");
> ResultSet betweenRowsNet = executeNet("SELECT * FROM %s WHERE c2 BETWEEN
> 2 AND 3 ALLOW FILTERING");
> assertRowsNet(betweenRowsNet, row (0, 3, 3, "MA"), row (0, 2, 2, "MA"));
> // NO RESULTS?
> }
> {code}
> The issue is due to the fact that the comparison performed in
> {{BETWEEN.isSatisfied}} ignore the {{ReversedType}}.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
