babelfish-for-postgresql / babelfish_extensions / 15832059836

76%

BABEL_5_X_DEV: 77%

push

github

Updated escape logic in quotename (#3857)

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
This PR is cherry-pick from 5_X_DEV to 4_X_DEV branch: https://github.com/babelfish-for-postgresql/babelfish_extensions/pull/3817

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.

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

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

49181 of 64944 relevant lines covered (75.73%)

323674.47 hits per line