babelfish-for-postgresql / babelfish_extensions / 13950663165

76%

BABEL_6_X_DEV: 78%

push

github

Add support for ALTER VIEW and CREATE OR ALTER VIEW syntax on schema bound views in Babelfish

Cherry-Pick commit from PR from #3570

Currently, Babelfish does not support ALTER VIEW and CREATE OR ALTER VIEW syntax statement in the TSQL dialect. With this change, Babelfish will support ALTER VIEW operations, allowing users to modify existing views.

We assume views to not have any dependencies for alter to succeed.
For dependent procedures, alter view will continue to work and will not be affected.
Permissions on views won't be affected
The change was made to enhance Babelfish's compatibility with SQL Server by supporting the ALTER VIEW statement. This allows users to modify views in a manner consistent with SQL Server.

[NOTE]: ALTER VIEW for views having dependencies will be supported once Babelfish supports weak schema bound views.

Engine PR - babelfish-for-postgresql/postgresql_modified_for_babelfish#547
Signed off by: Rahul Parande <rparande@amazon.com>
Issues Resolved: JIRA - BABEL-2017

77 of 81 new or added lines in 3 files covered. (95.06%)

47452 of 63293 relevant lines covered (74.97%)

193076.66 hits per line