[jira] [Comment Edited] (CASSANDRA-20566) RowFilter#isMutableIntersection() does not properly evaluate numeric ranges with both lower and upper bounds

["Caleb Rackliffe (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-20566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17945526#comment-17945526 ] 

Caleb Rackliffe edited comment on CASSANDRA-20566 at 4/21/25 10:00 PM:
-----------------------------------------------------------------------

| [trunk|https://github.com/apache/cassandra/pull/4104] |  [^ci_summary.html] | 


was (Author: maedhroz):
| [trunk|https://github.com/apache/cassandra/pull/4104] | CI TODO | 

> RowFilter#isMutableIntersection() does not properly evaluate numeric ranges with both lower and upper bounds
> ------------------------------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-20566
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-20566
>             Project: Apache Cassandra
>          Issue Type: Improvement
>          Components: Consistency/Coordination, Feature/SAI
>            Reporter: Caleb Rackliffe
>            Assignee: Caleb Rackliffe
>            Priority: Normal
>             Fix For: 5.0.x, 5.x
>
>         Attachments: ci_summary.html, result_details.tar.gz
>
>          Time Spent: 1h
>  Remaining Estimate: 0h
>
> We treat a {{RowFilter}} as having what we call a “mutable intersection” if it involves more than one non-primary-key column. (i.e. Primary key elements are immutable.) A numeric range of the form {{a > 3 AND a < 10}} is being evaluated as two columns in {{RowFilter#isMutableIntersection()}}, and this is causing SAI queries that should be able to run as single node read queries (and take advantage of digests, etc.) to run as range queries. It should be able to correct this simply by making sure we look at the number of unique mutable columns involved.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org