babelfish-for-postgresql / babelfish_extensions / 29352662064

78%

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

56027 of 72159 relevant lines covered (77.64%)

614106.1 hits per line