babelfish-for-postgresql / babelfish_extensions / 13950595126

push

github

Add support for ALTER VIEW and CREATE OR ALTER VIEW syntax on schema bound views in Babelfish (#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#545

Signed off by: Rahul Parande rparande@amazon.com
Issues Resolved: BABEL-2017

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

47513 of 63333 relevant lines covered (75.02%)

189272.47 hits per line