babelfish-for-postgresql / babelfish_extensions / 20370445330

77%

push

github

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

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

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

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

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

52249 of 68033 relevant lines covered (76.8%)

390420.38 hits per line