babelfish-for-postgresql / babelfish_extensions / 20328298415

76%

BABEL_5_X_DEV: 77%

push

github

Fix concatenation of binaries by adding '+' operator for sys.bbf_binary (#4306)

Currently in Babelfish, the '+' operator for binary data types is incorrectly performing arithmetic addition instead of concatenation. This occurs because the operator resolution is picking BIGINT for both left and right arguments when binary values are provided, leading to implicit type conversion and arithmetic addition. The return type of the result is also consequently BIGINT instead of binary.

This commit resolves this issue by adding a separate operator for binary concatenation that specifically handles binary operands without converting them to BIGINT. The fix maintains the binary type for the result and handles various combinations of BINARY and VARBINARY types correctly..

Task: BABEL-5597

cherry-picked from #4080

Engine PR:babelfish-for-postgresql/postgresql_modified_for_babelfish#663

Signed-off-by: Rucha Kulkarni ruchask@amazon.com

39 of 43 new or added lines in 1 file covered. (90.7%)

50381 of 66143 relevant lines covered (76.17%)

394750.21 hits per line