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.

Sign up for GitHub

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

Jump to bottom

sql: missing support for CREATE MATERIALIZED VIEW #41649

Closed
jordanlewis opened this issue Oct 16, 2019 · 4 comments · Fixed by #52530
Closed

sql: missing support for CREATE MATERIALIZED VIEW #41649

jordanlewis opened this issue Oct 16, 2019 · 4 comments · Fixed by #52530
Labels
A-sql-pgcompat Semantic compatibility with PostgreSQL X-anchored-telemetry The issue number is anchored by telemetry references.
Projects
[DEPRECATED] Old SQLExec board. Don't...

Comments

@jordanlewis
Copy link
Member

PostgreSQL supports materialized views with CREATE MATERIALIZED VIEW. CockroachDB is missing support for this feature. It is unclear if the semantics PostgreSQL provides would be good to add to CockroachDB, but this issue exists as a placeholder to point to when discussing this missing support.
@jordanlewis jordanlewis added A-sql-pgcompat Semantic compatibility with PostgreSQL X-anchored-telemetry The issue number is anchored by telemetry references. labels Oct 16, 2019
@jordanlewis jordanlewis mentioned this issue Oct 16, 2019
Merged
@asubiotto asubiotto moved this from Triage to [TENT] SQL Features in [DEPRECATED] Old SQLExec board. Don't move stuff here Apr 2, 2020
@dbist
Copy link
Contributor

dbist commented Jun 9, 2020

@dt based on your comment in slack, should we add the reskin CTAS as part of this issue or a separate issue?

@rohany rohany mentioned this issue Aug 8, 2020
Merged
rohany added a commit to rohany/cockroach that referenced this issue Aug 9, 2020
@rohany
sql: add support for materialized views
84e0e7b 
Fixes cockroachdb#41649.

This commit adds support for materialized views in CockroachDB. These
materialized views follow the Postgres style, where the `REFRESH
MATERIALIZED VIEW` command is needed to update the stored view data.
This commit does not include adding the various `ALTER MATERIALIZED
VIEW` and `DROP MATERIALIZED VIEW` extensions and will be added in a
follow up PR.

Release note (sql change): Add support for materialized views.
rohany added a commit to rohany/cockroach that referenced this issue Aug 10, 2020
@rohany
sql: add support for materialized views
ae886a5 
Fixes cockroachdb#41649.

This commit adds support for materialized views in CockroachDB. These
materialized views follow the Postgres style, where the `REFRESH
MATERIALIZED VIEW` command is needed to update the stored view data.
This commit does not include adding the various `ALTER MATERIALIZED
VIEW` and `DROP MATERIALIZED VIEW` extensions and will be added in a
follow up PR.

Release note (sql change): Add support for materialized views.
rohany added a commit to rohany/cockroach that referenced this issue Aug 12, 2020
@rohany
sql: add support for materialized views
49f5626 
Fixes cockroachdb#41649.

This commit adds support for materialized views in CockroachDB. These
materialized views follow the Postgres style, where the `REFRESH
MATERIALIZED VIEW` command is needed to update the stored view data.
This commit does not include adding the various `ALTER MATERIALIZED
VIEW` and `DROP MATERIALIZED VIEW` extensions and will be added in a
follow up PR.

Release note (sql change): Add support for materialized views.
craig bot pushed a commit that referenced this issue Aug 14, 2020
@rohany
Merge #52530
1049eaa 
52530: sql: add support for materialized views r=rohany a=rohany

Fixes #41649.

This commit adds support for materialized views in CockroachDB. These
materialized views follow the Postgres style, where the `REFRESH
MATERIALIZED VIEW` command is needed to update the stored view data.
This commit does not include adding the various `ALTER MATERIALIZED
VIEW` and `DROP MATERIALIZED VIEW` extensions and will be added in a
follow up PR.

Release note (sql change): Add support for materialized views.

Co-authored-by: Rohan Yadav <rohany@alumni.cmu.edu>
@craig craig bot closed this as completed in c362707 Aug 14, 2020
@timgraham
Copy link
Contributor

Hi @rohany, materialized views aren't showing up in a SHOW TABLES qurery. Is it a bug?

@rohany
Copy link
Contributor

rohany commented Aug 29, 2020

Yes that looks like a bug. Can you please open an issue?

@timgraham
Copy link
Contributor

Created #53610. Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
A-sql-pgcompat Semantic compatibility with PostgreSQL X-anchored-telemetry The issue number is anchored by telemetry references.
Projects
No open projects
[DEPRECATED] Old SQLExec board. Don't...
SQL Features Backlog
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

sql: add support for materialized views rohany/cockroach
4 participants
@jordanlewis @timgraham @dbist @rohany