1
77%
BABEL_5_X_DEV: 77%

Ran 03 Jul 2025 01:39AM UTC

Files 120

Run time 5s

Badge

Embed ▾

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

Job # 16039145218.1

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

babelfish-for-postgresql / babelfish_extensions / 16039145218 / 1
77%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 16039145218.1

babelfish-for-postgresql / babelfish_extensions / 16039145218 / 1 77% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 16039145218.1

babelfish-for-postgresql / babelfish_extensions / 16039145218 / 1
77%
BABEL_5_X_DEV: 77%

README BADGES
x