search

yugabyte / yugabyte-db

YugabyteDB - the cloud native distributed SQL database for mission-critical applications.
https://www.yugabyte.com
Other
8.86k stars 1.05k forks source link

[YSQL] Stored generated column is not supported #10695

Open tedyu opened 2 years ago

tedyu commented 2 years ago

Jira Link: DB-1115

Description

yugabyte=# CREATE TABLE gtest0 (a int PRIMARY KEY, b int GENERATED ALWAYS AS (55) STORED);
ERROR:  syntax error at or near "("
LINE 1: ...st0 (a int PRIMARY KEY, b int GENERATED ALWAYS AS (55) STORE...
                                                             ^
saurik commented 2 years ago

Apparently this was a PostgreSQL 12 feature (and Yugabyte is based on PostgreSQL 11.2).

TroyKomodo commented 7 months ago

Would be nice if this ticket made it into a milestone.