search

cockroachdb / docs

CockroachDB user documentation
https://cockroachlabs.com/docs
Creative Commons Attribution 4.0 International
187 stars 455 forks source link

sql: add unique constraints to table descriptor for UNIQUE WITHOUT INDEX #9576

Open jseldess opened 3 years ago

jseldess commented 3 years ago

Jesse Seldess (jseldess) commented:

PR: https://github.com/cockroachdb/cockroach/pull/57666

From release notes:

Added a session setting experimental_enable_unique_without_index_constraints and cluster default sql.defaults.experimental_enable_unique_without_index_constraints.enabled to enable the use of UNIQUE WITHOUT INDEX syntax. The default value of both settings is false since this feature is not yet fully supported. Use of UNIQUE WITHOUT INDEX also depends on all nodes being upgraded to the cluster version UniqueWithoutIndexConstraints. [#57666][#57666] {% comment %}doc{% endcomment %}

Jira Issue: DOC-941

jseldess commented 3 years ago

@rytaft shared that this is hidden from users and only for internal testing, for now. Closing.

jseldess commented 3 years ago

Actually, @ianjevans, after discussing this more with @rytaft, we think you should add this session variable here: https://www.cockroachlabs.com/docs/v20.2/experimental-features.html. User will see it in the response to SHOW SESSION ALL anyway. But for the description, let's just say something like "it's used for internal testing purposes only".