Benjamin Lerer created CASSANDRA-19878:
------------------------------------------
Summary: 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
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}
--
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
