babelfish-for-postgresql / babelfish_extensions / 9236837298

Build # 9236837298

Build Type

push

github

Committed by web-flow

Commit Message

Wrong column type in sys.sql_modules (#2617)

Currently, definition column in the view sys.sql_modules stores upto 4000 characters. SSMS scripting uses sys.sql_modules view to show the definition of the procedure, and the procedure definition is truncated to 4000 characters if the actual procedure definition is more than 4K.

To avoid this incorrect definition, We can directly use sys.nvarchar and there is no need to specify the tymod of 4000 in case of sys.nvarchar for the definition column i.e., sys.nvarchar(4000).

Fixed the definition column for the views which should use nvarchar(max): sql_modules, system_sql_modules, all_sql_modules.

Task: BABEL-4870

Signed-off-by: Shalini Lohia lshalini@amazon.com

Run Details

20637 of 57490 relevant lines covered (35.9%)

14230.69 hits per line

Source File

Press 'n' to go to next uncovered line, 'b' for previous

Source Not Available