babelfish-for-postgresql / babelfish_extensions / 11468098887

Build # 11468098887

Build Type

push

github

Committed by web-flow

Commit Message

Fix CONVERT function behavior for BINARY and VARBINARY types (#3007)

This change addresses inconsistencies in the CONVERT function's behavior when used with BINARY and VARBINARY types in Babelfish. Previously, Babelfish was not correctly handling style arguments and hexadecimal input for these conversions. With this change, the behavior now more closely aligns with SQL Server's implementation.

For CONVERT(BINARY(n), '0x...', 1), the function now correctly interprets the input string as hexadecimal values instead of ASCII characters, adhering to the specified style.

When NULL is provided as the style argument, the function now correctly returns NULL for both BINARY and VARBINARY types.

For both BINARY and VARBINARY conversions, the function now properly considers the style argument, ensuring consistent behavior across different styles.

Fixed an issue where style 2 was not being handled correctly, leading to unexpected results.

Issues Resolved
Task: BABEL-2736
Signed-off-by: Rahul Parande <rparande@amazon.com>

Run Details

45219 of 60686 relevant lines covered (74.51%)

163113.99 hits per line

Source File

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

Source Not Available