16045190833
76%
BABEL_5_X_DEV: 77%

Ran 03 Jul 2025 08:49AM UTC

Jobs 1

Files 120

Run time 1min

Badge

Embed ▾

Committed 03 Jul 2025 01:04AM UTC coverage: 75.87%. Remained the same

Build # 16045190833

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

49472 of 65206 relevant lines covered (75.87%)

315533.03 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	16045190833.1	03 Jul 2025 08:49AM UTC	120	75.87	GitHub Action Run

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

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 16045190833

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

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 16045190833

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

README BADGES
x