11478967557
74%
BABEL_5_X_DEV: 77%

Ran 23 Oct 2024 12:16PM UTC

Jobs 1

Files 114

Run time 1min

Badge

Embed ▾

Committed 23 Oct 2024 11:31AM UTC coverage: 73.697% (-0.02%) from 73.719%

Build # 11478967557

Build Type

push

github

Committed by

web-flow

Commit Message

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

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>
Co-authored-by: Rahul Parande <rparande@amazon.com>

Run Details

43036 of 58396 relevant lines covered (73.7%)

142771.36 hits per line

Uncovered Existing Lines

Lines	Coverage	∆	File
17	79.59	-1.76%	contrib/babelfishpg_common/src/varbinary.c

Jobs

ID	Job ID	Ran	Files	Coverage
1	11478967557.1	23 Oct 2024 12:16PM UTC	114	73.7	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 11478967557
74%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 11478967557

babelfish-for-postgresql / babelfish_extensions / 11478967557 74% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 11478967557

babelfish-for-postgresql / babelfish_extensions / 11478967557
74%
BABEL_5_X_DEV: 77%

README BADGES
x