babelfish-for-postgresql / babelfish_extensions / 15764117180

77%

Build Type

push

github

Committed by web-flow

Commit Message

Updated escape logic in quotename (#3817)

Issue Description:

In Babelfish, the QUOTENAME function currently produces incorrect results for many queries due to flaws in its escape character handling logic. The function fails to properly escape characters that match the right delimiter.
Also handle Unicode character handling in delimeter.
Changes logic to accept fetch first character from delimeter string and use it as delimeter
Solution:

The escape logic has been updated to properly handle special characters. Now, when QUOTENAME encounters any character within the input string that matches the right delimiter, it correctly escapes that character.
Updated logic to check byte size instead of len check.


Signed-off-by: Herambh Shah <herambhs@amazon.com>
Issues Resolved: BABEL - 2311

Run Details

14 of 14 new or added lines in 1 file covered. (100.0%)

2 existing lines in 1 file now uncovered.

48973 of 64730 relevant lines covered (75.66%)

316866.69 hits per line