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

[YSQL] Stored generated column is not supported #10695

Open
tedyu opened this issue Nov 24, 2021 · 2 comments
Open

[YSQL] Stored generated column is not supported #10695

tedyu opened this issue Nov 24, 2021 · 2 comments
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature pgcm priority/medium Medium priority issue

Comments

@tedyu
Copy link
Contributor

tedyu commented Nov 24, 2021

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...
                                                             ^
@tedyu tedyu added the area/ysql Yugabyte SQL (YSQL) label Nov 24, 2021
@saurik
Copy link

saurik commented Jan 30, 2022

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

@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Jun 8, 2022
@yugabyte-ci yugabyte-ci added kind/enhancement This is an enhancement of an existing feature and removed kind/bug This issue is a bug labels Aug 25, 2022
@TroyKomodo
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature pgcm priority/medium Medium priority issue
Projects
Status: No status
Development

No branches or pull requests

5 participants