cockroachdb / cockroachdb/cockroach

sql: support multirange types

Open
#169,302 0 comments 0 reactions 0 assignees View on GitHub
A-sql-datatypes A-sql-pgcompat C-enhancement
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

Multirange types were [introduced in PostgreSQL 14](https://www.postgresql.org/docs/current/rangetypes.html#RANGETYPES-BUILTIN) and allow storing multiple non-contiguous, non-overlapping ranges in a single value. Each built-in range type has a corresponding multirange type (e.g. `int4multirange`, `tsmultirange`, `datemultirange`).

Reference: https://www.npgsql.org/efcore/mapping/range.html

Note that CockroachDB does not yet support range types either (#27791). Multirange support would naturally build on top of range type support.

This was surfaced by 12 npgsql test failures after bumping `server_version` from 13.0.0 to 18.0.0 (#169041) — npgsql now expects multirange types to be available.

Epic: CRDB-60812

Jira issue: CRDB-63371

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.