cockroachdb / cockroachdb/cockroach

sql: SHOW CREATE VIEW on materialized view should not show implicit rowid column

Open
#99,029 0 comments 0 reactions 0 assignees View on GitHub
C-bug E-quick-win
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

`SHOW CREATE VIEW` on a materialized view outputs a `CREATE MATERIALIZED VIEW` statement that includes the implicit `rowid` column, which causes an error when running the statement.

```defaultdb> CREATE MATERIALIZED VIEW v (i, j) AS (SELECT 1, 2);
CREATE VIEW

defaultdb> SELECT create_statement from [SHOW CREATE VIEW v];
create_statement
---------------------------------------
CREATE MATERIALIZED VIEW public.v (
i,
j,
rowid
) AS (SELECT 1, 2)
(1 row)

defaultdb> CREATE MATERIALIZED VIEW public.v (
i,
j,
rowid
) AS (SELECT 1, 2)
ERROR: CREATE VIEW specifies 3 column names, but data source has 2 columns
SQLSTATE: 42601
```

Jira issue: CRDB-25670

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.