babelfish-for-postgresql / babelfish_extensions / 29408001414

77%

BABEL_6_X_DEV: 78%

push

github

INSERT...EXEC on inline table-valued function should raise error (#4898) (#4907)

Babelfish does not raise error when EXEC is used on an inline table-valued function (TVF). SQL Server correctly rejects this with error : "The request for procedure 'fn_inline_tvf_test' failed because 'fn_inline_tvf_test' is a table valued function object."

In Babelfish, the statement silently succeeds with 0 rows inserted, which is a behavioral gap.

With this commit, we fix this by adding a check for table valued functions.

Task: BABEL-6881

Authored by: Kushaal Shroff <kushaal@amazon.com>
Co Authored by: Mohit Raj mrxmohit@amazon.com

3 of 3 new or added lines in 1 file covered. (100.0%)

55724 of 72063 relevant lines covered (77.33%)

387368.01 hits per line