amazon-aurora / babelfish_extensions / 16226894595

76%

main: 77%

Build Type

push

github

Committed by Rahul Parande

Commit Message

Support for weak binding views to allow dropping of underlying objects.This commit introduces support for both strong and weak view binding in Babelfish, aligning more closely with SQL Server's default behavior while maintaining flexibility.

Key changes:
- Introduce GUC parameter 'babelfishpg_tsql.weak_view_binding' to control default binding behavior (default: false)
- Support explicit WITH SCHEMABINDING clause for strong binding
- Implement weak binding to allow dropping of referenced objects
- Handle ALTER VIEW operations in both binding modes
- Add logic to repair broken views when underlying objects are recreated

Limitations:
- Only addresses DROP operations on tables, views, functions, and procedures
- ALTER TABLE/ALTER FUNCTION operations still restricted when dependent views exist
- View repair follows PostgreSQL's CREATE OR REPLACE VIEW restrictions

Signed-off-by: Rahul Parande <rparande@amazon.com>

Run Details

359 of 388 new or added lines in 7 files covered. (92.53%)

2228 existing lines in 7 files now uncovered.

49907 of 65648 relevant lines covered (76.02%)

317287.26 hits per line