Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sql: support NOT VISIBLE in CREATE TABLE for user-defined hidden columns #10057

Closed
jseldess opened this issue Mar 23, 2021 · 0 comments
Closed
Milestone

Comments

@jseldess
Copy link
Contributor

jseldess commented Mar 23, 2021

Jesse Seldess commented:

PR: cockroachdb/cockroach#58923

From release notes:

It is now possible to use the NOT VISIBLE qualifier for new column definitions in [CREATE TABLE](../v21.1/create-table.html]. This causes the column to become "hidden". Hidden columns are not considered when using * in SELECT clauses. Note that CockroachDB already supported hidden columns (e.g., rowid, which is added automatically when a table definition has no PRIMARY KEY constraint]. This change adds the opportunity for end-users to define their own hidden columns. It is intended for use in combination with other features related to geo-partitioning introduced in v21.1, which offer more control about how geo-partitioning keys get exposed to client ORMs and other automated tools that inspect the SQL schema. [#58923)[#58923) {% comment %}doc{% endcomment %}

Jira Issue: DOC-1045

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants