babelfish-for-postgresql / babelfish_extensions / 11444341507

76%

BABEL_5_X_DEV: 77%

push

github

Fixing the default and max typmod arg cases for various datatypes in procedure/function (#2911)

* fixing the default and max typmod arg cases for various datatypes in procedure

Currently, end user is able to specify nvarchar(max) for output param while defining the procedure. Procedure will be created without any error but it will throw an error upon executing the procedure. This PR will handle the default and max output params for procedure. We have handled and tested the following datatypes :

NVARCHAR [ ( n | max ) ]
VARCHAR [ ( n | max ) ]
VARBINARY [ ( n | max ) ]
NCHAR [ ( n ) ]
SMALLDATETIME
DECIMAL [ ( p [ , s ] ) ]
BINARY [ ( n ) ]
BPCHAR [ ( n ) ]

Signed-off-by: Tanya Gupta <tanyagp@amazon.com>

21 of 21 new or added lines in 2 files covered. (100.0%)

45235 of 60699 relevant lines covered (74.52%)

166559.92 hits per line