20805637742
76%
BABEL_5_X_DEV: 77%

Ran 08 Jan 2026 05:00AM UTC

Jobs 1

Files 120

Run time 1min

Badge

Embed ▾

Committed 08 Jan 2026 04:35AM UTC coverage: 76.219% (-0.003%) from 76.222%

Build # 20805637742

Build Type

push

github

Committed by

web-flow

Commit Message

Restrict argument of datatype timestamp in DATEADD() function. (#4376) (#4386)

Currently in Babelfish, we can implement DATEADD() function on UDT from timestamp. But in TSQL we do not support creation of UDT on timestamp datatype

-- TSQL
1> CREATE TYPE UDT_TIMESTAMP FROM TIMESTAMP NOT NULL
2> GO
Msg 222, Level 16, State 1, Server EC2AMAZ-AEV9H40, Line 1
The base type "timestamp" is not a valid base type for the alias data type.

With this change we raise an exception while calling DATEADD() on UDT from timestamp datatype in Babelfish

-- Babelfish
1> SELECT ID, UdtTimestamp, DATEADD (MONTH, 45, UdtTimestamp) AS UDTTIMESTAMP FROM UdtTable
2> GO
Msg 33557097, Level 16, State 1, Server BABELFISH, Line 1
Conversion failed when converting date and/or time from timestamp.

Task: BABEL-5844

Signed-off-by: Jaspal Singh <ijaspals@amazon.com>

Run Details

50522 of 66285 relevant lines covered (76.22%)

401453.67 hits per line

Uncovered Existing Lines

Lines	Coverage	∆	File
2	72.43	-0.4%	contrib/babelfishpg_tds/src/backend/tds/tdsutils.c

Jobs

ID	Job ID	Ran	Files	Coverage
1	20805637742.1	08 Jan 2026 05:00AM UTC	120	76.22	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 20805637742
76%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 20805637742

babelfish-for-postgresql / babelfish_extensions / 20805637742 76% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 20805637742

babelfish-for-postgresql / babelfish_extensions / 20805637742
76%
BABEL_5_X_DEV: 77%

README BADGES
x