20780224196
77%

Ran 07 Jan 2026 12:04PM UTC

Jobs 1

Files 121

Run time 1min

Badge

Embed ▾

Committed 07 Jan 2026 11:38AM UTC coverage: 76.878% (-0.001%) from 76.879%

Build # 20780224196

Build Type

push

github

Committed by

web-flow

Commit Message

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

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

52555 of 68362 relevant lines covered (76.88%)

387458.94 hits per line

Uncovered Existing Lines

Lines	Coverage	∆	File
1	79.23	-0.2%	contrib/babelfishpg_tds/src/backend/tds/tdsutils.c

Jobs

ID	Job ID	Ran	Files	Coverage
1	20780224196.1	07 Jan 2026 12:04PM UTC	121	76.88	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 20780224196
77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 20780224196

babelfish-for-postgresql / babelfish_extensions / 20780224196 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 20780224196

babelfish-for-postgresql / babelfish_extensions / 20780224196
77%

README BADGES
x