cockroachdb / cockroachdb/docs

Feedback: SQL FAQs - missing info on unordered_unique_rowid()

Offen
#19,606 0 Kommentare 0 Reaktionen 0 zugewiesene Personen Auf GitHub ansehen
Vorherrschende Sprache
HTML
Sterne
212
Forks
476
Ø Merge
40 Min.
Gemergte PRs (30 T.)
3

Beschreibung

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

Beitragsleitfaden

Für dieses Repository ist kein Beitragsleitfaden indexiert

Bewertung

Dieses Issue wurde noch nicht bewertet.

Neue Issues direkt in Ihr Postfach

Eine kurze Übersicht über anfängerfreundliche GitHub-Issues.