search

babelfish-for-postgresql / babelfish_extensions

Babelfish for PostgreSQL provides the capability for PostgreSQL to work with applications written for Microsoft SQL Server. Babelfish understands the SQL Server wire-protocol and T-SQL, the Microsoft SQL Server query and procedural language, so you don’t have to switch database drivers or rewrite all of your application queries.
https://babelfishpg.org/
Apache License 2.0
277 stars 93 forks source link

Fixed view sys.sp_columns_100_view #3106

Open Deepesh125 opened 1 week ago

Deepesh125 commented 1 week ago

Description

Previously, the parameter value @fUsePattern=0 is broken for sp_columns_100, returning only a partial data set. Also, overall handling of identifier was incorrect when it comes to truncation of identifiers. This commit aims to fix these issue by appropriately using truncate function as well as fixes issue of @fUsePattern=0 which now should return proper data.

Task: BABEL-5314 Signed-off-by: Dipesh Dhameliya dddhamel@amazon.com

Check List

By submitting this pull request, I confirm that my contribution is under the terms of the Apache 2.0 and PostgreSQL licenses, and grant any person obtaining a copy of the contribution permission to relicense all or a portion of my contribution to the PostgreSQL License solely to contribute all or a portion of my contribution to the PostgreSQL open source project.

For more information on following Developer Certificate of Origin and signing off your commits, please check here.

coveralls commented 1 week ago

Pull Request Test Coverage Report for Build 11951368092

Details

Totals Coverage Status
Change from base Build 11951324660: 0.0%
Covered Lines: 45750
Relevant Lines: 61238
💛 - Coveralls