cockroachdb / cockroachdb/cockroach

sql: add support for `inet_ops` inverted index

Open
#122,375 0 comments 1 reaction 0 assignees View on GitHub
C-enhancement O-support P-3 T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

This issue tracks adding support for indexing the `inet_ops` [operator class](https://www.postgresql.org/docs/current/gist-builtin-opclasses.html). 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](https://www.cockroachlabs.com/docs/v23.2/functions-and-operators#bool-functions), for example), but is unable to inline them into an index scan.

Related to #35730

Jira issue: CRDB-37844

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.