babelfish-for-postgresql / babelfish_extensions / 14492418144
75%
BABEL_5_X_DEV: 77%

LAST BUILD BRANCH: fix_script_injection
DEFAULT BRANCH: BABEL_5_X_DEV
Ran
Jobs 1
Files 116
Run time 1min
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst
coverage: 74.8% (+0.007%) from 74.793%
14492418144

push

github

web-flow 
Adding support for sys.+ and sys.- for sys.bbf_varbinary data type (#3699)

1. Issue:

Before creating cast from varbinary to datetime, we found one issue that sys.+(sys.bbf_varbinary, sys.bbf_varbinary) and
sys.-(sys.bbf_vabinary,sys.varbinary) operators where pointing to sys.+(bigint, bigint) and sys.-(bigint, bigint)
respectively.

But after creating of cast from varbinary to datetime, sys.+(sys.bbf_varbinary, sys.bbf_varbinary) and
sys.-(sys.bbf_vabinary,sys.varbinary) operators started pointing to sys.+(sys.datetime, sys.datetime) and
sys.-(sys.datetime, sys.datetime) respectively.

Consider following example -

-- previous version in BBF
1> declare @random varbinary(5) = 0x4142434445
2> declare @result varbinary(max) = 0x
3> select @result + @random
4> go

--------------------
        280284578885

(1 rows affected)

-- after creation of cast in BBF
1> declare @random varbinary(5) = 0x4142434445
2> declare @result varbinary(max) = 0x
3> select @result + @random
4> go
Msg 517, Level 16, State 1, Server persist-rohitbgt-validation-17-latest-i, Line 3
data out of range for datetime

2. Changes made to fix the issues

The fix addresses the implementation of binary concatenation in Babelfish by adding support for operators like
sys.+(sys.bbf_varbinary, sys.bbf_varbinary). We utilize the existing 'bytecat' function, which provides equivalent
behavior to T-SQL's varbinary concatenation.

Task: BABEL-5728
Signed-off-by: yashneet vinayak <yashneet@amazon.com>

47689 of 63755 relevant lines covered (74.8%)

252803.87 hits per line

Jobs
ID Job ID Ran Files Coverage
1 14492418144.1 116
74.8
 GitHub Action Run
Source Files on build 14492418144