Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

sql: add support for inet_ops inverted index #122375

Open
DrewKimball opened this issue Apr 15, 2024 · 0 comments
Open

sql: add support for inet_ops inverted index #122375

DrewKimball opened this issue Apr 15, 2024 · 0 comments
Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) O-support Would prevent or help troubleshoot a customer escalation - bugs, missing observability/tooling, docs P-3 Issues/test failures with no fix SLA T-sql-queries SQL Queries Team

Comments

@DrewKimball
Copy link
Collaborator

DrewKimball commented Apr 15, 2024 •
edited by cockroach-jira-scripts
Loading

This issue tracks adding support for indexing the inet_ops operator class. This is useful for operators like >> (containment), for which there isn't currently a way to avoid a full-table-scan. Note that CRDB already supports the operations themselves (see inet_contains_or_equals here, for example), but is unable to inline them into an index scan.

Related to #35730

Jira issue: CRDB-37844
@DrewKimball DrewKimball added C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) O-support Would prevent or help troubleshoot a customer escalation - bugs, missing observability/tooling, docs T-sql-queries SQL Queries Team labels Apr 15, 2024
@github-project-automation github-project-automation bot moved this to Triage in SQL Queries Apr 15, 2024
@yuzefovich yuzefovich added the P-3 Issues/test failures with no fix SLA label May 7, 2024
@yuzefovich yuzefovich moved this from Triage to Backlog in SQL Queries May 7, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) O-support Would prevent or help troubleshoot a customer escalation - bugs, missing observability/tooling, docs P-3 Issues/test failures with no fix SLA T-sql-queries SQL Queries Team
Projects
SQL Queries
Status: Backlog
Milestone
No milestone
Development

No branches or pull requests
2 participants
@yuzefovich @DrewKimball