9301505688
74%
BABEL_5_X_DEV: 75%

Ran 30 May 2024 11:55AM CUT

Jobs 1

Files 114

Run time 1min

Badge

Embed ▾

Committed 30 May 2024 11:07AM CUT coverage: 73.194%. Remained the same

Build # 9301505688

Build Type

push

github

Committed by

web-flow

Commit Message

Fix differences in T-SQL COALESCE function while calling the function with variables and constants together (#2635)

This commit will fix the following issues with T-SQL COALESCE function :

When the arguments contain the mix of variables and constants as shown below, the below query should return 4 as it is the first non-null value. But BBF throws error as we try to evaluate the constant ('dfidhfgi') at the compile time in this case.

DECLARE @abc int = 4 ;
select COALESCE(@abc, 'dfidhfgi')

When the arguments are of varbinary and nvarchar type, BBF throws error as we have defined the CAST between varbinary and nvarchar as ASSIGNMENT, but in this case IMPLICIT casting is used.

select coalesce(CAST('x'AS VARBINARY), CAST('x' AS NVARCHAR(4000)), 'x')

Issues Resolved: BABEL-726
Engine PR : babelfish-for-postgresql/postgresql_modified_for_babelfish#380

Signed-off-by: Sai Rohan Basa bsrohan@amazon.com

Run Details

41715 of 56992 relevant lines covered (73.19%)

107968.02 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	9301505688.1	30 May 2024 11:55AM CUT	114	73.19	GitHub Action Run

Source Files on build 9301505688

Coverage	File	Lines	Relevant	Covered	Missed	Hits/Line
0.0	contrib/babelfishpg_tsql/src/tsqlHandler.c	29	5	0	5	0.0
0.0	contrib/babelfishpg_tsql/src/tsqlNodes.c	40	18	0	18	0.0
0.0	.../mb/conversion_procs/utf8_and_big5/utf8_and_big5.c	32	4	0	4	0.0
0.0	contrib/babelfishpg_tsql/src/tsql_for/forxml_old.c	283	95	0	95	0.0
0.0	...ontrib/babelfishpg_tsql/src/tsql_for/forjson_old.c	358	136	0	136	0.0
1.18	contrib/babelfishpg_tsql/src/pl_gram.y	8370	3221	38	3183	3731.0 + 4
11.5	contrib/babelfishpg_tsql/src/pl_scanner.c	835	226	26	200	118734.0 + 229
20.65	contrib/babelfishpg_tsql/src/pl_funcs.c	1833	1085	224	861	827556.0 + 196
32.84	...ontrib/babelfishpg_tds/src/backend/utils/adt/xml.c	737	201	66	135	9.0
36.36	...ib/babelfishpg_tds/src/backend/utils/adt/varchar.c	108	22	8	14	1314.0

73.19
contrib/

babelfish-for-postgresql / babelfish_extensions / 9301505688
74%
BABEL_5_X_DEV: 75%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 9301505688

babelfish-for-postgresql / babelfish_extensions / 9301505688 74% BABEL_5_X_DEV: 75%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 9301505688

babelfish-for-postgresql / babelfish_extensions / 9301505688
74%
BABEL_5_X_DEV: 75%

README BADGES
x