cockroachdb / cockroachdb/docs
Feedback: SQL FAQs - missing info on unordered_unique_rowid()
- 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.