babelfish-for-postgresql / babelfish_extensions / 16285796618

76%

BABEL_5_X_DEV: 77%

Build Type

push

github

Committed by web-flow

Commit Message

Support for weak binding views to allow dropping of underlying objects BABEL_4_X_DEV (#3965)

* 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. (#3806)

Description
Currently, Babelfish only supports strong binding for views, which prevents dropping or altering referenced objects when views depend on them. This behavior differs from SQL Server, which by default allows dropping underlying tables or views unless WITH SCHEMABINDING is explicitly specified.
With this change, Babelfish now supports configurable view binding modes:

Strong binding (default): Prevents dropping referenced objects if views depend on them
Weak binding: Allows dropping of referenced objects
This feature aligns Babelfish more closely with SQL Server's behavior, providing greater flexibility
Key aspects include:

A new GUC parameter babelfishpg_tsql.weak_view_binding to control the default binding behavior (default is false)
Support for explicit WITH SCHEMABINDING to create strongly bound views regardless of the GUC setting
Ability to create weakly bound views by default when the GUC is enabled
Proper handling of ALTER VIEW operations in both binding modes
In SQL Server, views are weakly bound by default, allowing underlying objects to be dropped or altered. With our implementation, users can now choose between SQL Server's default behavior (weak binding) or the previously enforced behavior (strong binding).

Important Limitation :
This implementation currently only addresses DROP operations on tables, views, functions, procedures as well as ALTER operations on views when these objects are bound by dependent views. ALTER TABLE/ ALTER FUNCTION operations (such as dropping columns or changing data types) are still restricted when dependent views exist, regardless of binding mode. This differs... (continued)

Run Details

365 of 394 new or added lines in 7 files covered. (92.64%)

3 existing lines in 2 files now uncovered.

49679 of 65461 relevant lines covered (75.89%)

325608.06 hits per line