amazon-aurora / babelfish_extensions / 29359513474

77%

main: 77%

push

github

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

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%)

55797 of 72139 relevant lines covered (77.35%)

607357.71 hits per line