babelfish-for-postgresql / babelfish_extensions / 8644807843

74%

BABEL_5_X_DEV: 75%

push

github

Fix handling for TVP to allow mixed declaration of named and unnamed parameters (#2477)

1. Issue

    Babelfish is throwing an error "not all Parameters have names" when SP_EXECSQL contains TVP. This is occurring due to incorrect assumption about whether all parameters have names or not. But in theory there could be names for few parameters and no names for other.

2. Changes made to fix the issue

    Modified logic in tdsrpc.c file to correctly set the flag so that we could assign a name for unnamed parameters and use the existing name for named parameters which allows us for mixed declaration use for both named and unnamed parameters.

    Added Test Cases for this issue

Cherry-picked: #2478
Task: BABEL- 4707
Authored-by: Anikait Agrawal agraani@amazon.com
Signed-off-by: Anikait Agrawal agraani@amazon.com

4 of 5 new or added lines in 2 files covered. (80.0%)

41208 of 56493 relevant lines covered (72.94%)

64542.45 hits per line