16039145218
77%

Ran 03 Jul 2025 01:39AM UTC

Jobs 1

Files 120

Run time 1min

Badge

Embed ▾

Committed 03 Jul 2025 01:04AM UTC coverage: 75.867% (-0.003%) from 75.87%

Build # 16039145218

Build Type

push

github

Committed by

web-flow

Commit Message

Fixed DATENAME to use datetimeoffset cast instead of sys.babelfish_conv_string_to_datetimeoffset (#3907)

While sys.babelfish_conv_string_to_datetimeoffset is a helpful way to
validate datetimeoffset values before returning the offset string in
DATENAME(TZOFFSET,...) it is crrently not present in 4_X. (BABEL-4896).

Switching to a normal pg cast to datetimeoffset works as well, but does
not validate out of boundary offset hour values above +/-14:00 since PG
accepts upto hour 15.

The incorrect output in the out-of-boundary test case in
`datename+tzoffset-v-verify.sql` can be updated to the expected error
(SQL Server), once the root cause jira BABEL-5827 is fixed.

Task: BABEL-5846
Signed-off-by: Manisha Deshpande <mmdeshp@amazon.com>

Run Details

49470 of 65206 relevant lines covered (75.87%)

316250.56 hits per line

Uncovered Existing Lines

Lines	Coverage	∆	File
2	76.23	-0.62%	contrib/babelfishpg_tds/src/backend/tds/tdscomm.c

Jobs

ID	Job ID	Ran	Files	Coverage
1	16039145218.1	03 Jul 2025 01:39AM UTC	120	75.87	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 16039145218
77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 16039145218

babelfish-for-postgresql / babelfish_extensions / 16039145218 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 16039145218

babelfish-for-postgresql / babelfish_extensions / 16039145218
77%

README BADGES
x