pingcap / pingcap/tidb

Invisible Columns

Open
#59,233 0 comments 0 reactions 0 assignees View on GitHub
compatibility-mysql80 compatibility-mysql84
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

Support things like this:
```sql
CREATE TABLE t1(
id int PRIMARY KEY,
c1 int INVISIBLE
);
```

This is useful for:
- A part of Generated Invisible Primary Keys (GIPK) ( https://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html )
- Indexes on generated columns that are hidden. To have functional indexes with breaking `INSERT` and `SELECT` where the column list isn't supplied.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.