cockroachdb / cockroachdb/docs

Feedback: SQL FAQs - missing info on unordered_unique_rowid()

Open
#19,606 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
HTML
Stars
212
Forks
476
Avg merge
40m
Merged PRs (30d)
3

Description

Page: https://cockroachlabs.com/docs/v25.2/sql-faqs.html

## What is the reason for your feedback?

[X] Missing the information I need

[ ] Too complicated

[ ] Out of date

[ ] Something is broken

[ ] Other

## Additional details

This page is incomplete because it does not mention `unordered_unique_rowid()`

For example, it omits `unordered_unique_rowid()` when it says:

> To auto-generate unique row identifiers, you can use the gen_random_uuid(), uuid_v4(), or unique_rowid() [functions](https://www.cockroachlabs.com/docs/v25.2/functions-and-operators#id-generation-functions).

Another example further down the page is the table that does not include `unordered_unique_rowid()` :

>

What are the differences between UUID, sequences, and unique_rowid()?


Property | UUID generated with uuid_v4() | INT generated with unique_rowid() | Sequences
-- | -- | -- | --

The `unordered_unique_rowid()` function is useful to document because it matches many use cases, especially when modifying the database schema to remove sequences, in the situation when the column needs to remain an integer, and when it is important to use an unordered value to reduce hot spots.

Jira issue: DOC-13671

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.