babelfish-for-postgresql / babelfish_extensions / 11511482199

Build # 11511482199

Build Type

push

github

Committed by web-flow

Commit Message

Fixed CONVERT function behavior for BINARY and VARBINARY types (#3052)

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

Run Details

42807 of 58381 relevant lines covered (73.32%)

142684.67 hits per line

Source File

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

Source Not Available