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

Add support for and emulate CREATE OR REPLACE MATERIALIZED VIEW and other objects #15593

Closed
6 tasks done
lukaseder opened this issue Sep 14, 2023 · 0 comments
Closed
6 tasks done

Comments

@lukaseder
Copy link
Member

lukaseder commented Sep 14, 2023

Only Snowflake supports CREATE OR REPLACE MATERIALIZED VIEW it seems (see #9483), but it would be useful everywhere else as well. We have an emulation for OR REPLACE for PROCEDURE and FUNCTION, which is MySQL specific. Perhaps we can refactor this to be more useful, similar to the IF [ NOT ] EXISTS anonymous block emulations. The emulation would simply run a DROP .. IF EXISTS before. This would be done for other object types as well.

@lukaseder lukaseder added this to the Version 3.20.0 milestone Sep 14, 2023
@lukaseder lukaseder added this to To do in 3.13 DDL interpretation via automation Sep 14, 2023
lukaseder added a commit that referenced this issue Sep 15, 2023
This includes:

- [#15593] Add support for and emulate CREATE OR REPLACE MATERIALIZED VIEW and other objects
- Interpreter support
- InformationSchemaExport support
- InformationSchema support
3.13 DDL interpretation automation moved this from To do to Done Oct 24, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Development

No branches or pull requests

1 participant