Skip to content

opt: remove uniqueness checks for gen_random_uuid() #10118

@jseldess

Description

@jseldess

Jesse Seldess commented:

PR: cockroachdb/cockroach#61132

From release notes:

Added the sql.optimizer.uniqueness_checks_for_gen_random_uuid.enabled cluster setting, which controls creation of uniqueness checks for [UUID](../v21.1/uuid.html] columns set to gen_random_uuid(]. When enabled, uniqueness checks will be added for the UUID column if it has a unique constraint that cannot be enforced by an index. When disabled, no uniqueness checks are planned for these columns, and uniqueness is assumed due to the near-zero collision probability of gen_random_uuid(). [#61132)[#61132) {% comment %}doc{% endcomment %}

Jira Issue: DOC-1055

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions