maedhroz commented on code in PR #3645:
URL: https://github.com/apache/cassandra/pull/3645#discussion_r1825184135
##########
test/unit/org/apache/cassandra/index/sai/cql/AllowFilteringTest.java:
##########
@@ -296,6 +296,24 @@ public void
testAllowFilteringOnClusteringAndRegularColumns() throws Throwable
test("SELECT * FROM %s WHERE v1=0 AND v2=0 AND k1=0 AND k2=0 AND (c1,
c2, c3, c4) = (0, 0, 0, 0) AND v3=0", true);
}
+ @Test
+ public void testAllowFilteringWithINClause () throws Throwable
+ {
+ createTable("CREATE TABLE %S (K1 TEXT, K2 TEXT, K3 TEXT, PRIMARY
KEY(K1))");
+ createIndex(format("CREATE CUSTOM INDEX ON %%s(K2) USING '%s'",
StorageAttachedIndex.class.getName()));
+
+ execute("INSERT INTO %s (K1,K2,K3) VALUES ('s1','s11','s111')");
+ execute("INSERT INTO %s (K1,K2,K3) VALUES ('s2','s11','s11')");
+ execute("INSERT INTO %s (K1,K2,K3) VALUES ('s3','s22','s111')");
+ execute("INSERT INTO %s (K1,K2,K3) VALUES ('s4','s22','s111')");
+ execute("INSERT INTO %s (K1,K2,K3) VALUES ('s5','s31','s111')");
+
+ testCount("SELECT * FROM %s WHERE K2='s11' AND K3 IN ('s11','s111')",
true, 2);
+ testCount("SELECT * FROM %s WHERE K2='s22' AND K3 IN ('s111','s111')",
true, 2);
Review Comment:
nit: For the two queries above, it might be simpler just to inline the
`ALLOW FILTERING` and get rid of the `testCount()` method.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
