babelfish-for-postgresql / babelfish_extensions / 9263552896
74%
BABEL_5_X_DEV: 75%

LAST BUILD BRANCH: BABEL-5467
DEFAULT BRANCH: BABEL_5_X_DEV
Ran
Jobs 1
Files 114
Run time 1min
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst
coverage: 73.196% (+0.01%) from 73.184%
9263552896

push

github

web-flow 
Fix issue with convert function when converting string to date, datetimeoffset, datetime2, datetime, smalldatetime or time (#2622)

For converting string to datetime2, datetimeoffset and smalldatetime using convert function, we are directly using cast function which will convert the string to given type with default style. Added support to use corresponding SQL helper functions defined which will fix this issue.

For conversion of string to date, datetime, smalldatetime and time using convert function, there are helper functions defined but are unable to handle all the supported datetime string literals. Refactored these definitions and fixed this issue.

For conversion of string to datetime2 and datetimeoffset using convert function, there are no helper functions defined which handles this conversion as there are for conversion of string to date, datetime, smalldatetime and time. Added definitions to handle these datatypes as well.

Function sys.babelfish_get_microsecs_from_fractsecs() is unable to handle the edge case where fractional seconds get overflowed after rounding it to given scale. Function babelfish_get_timeunit_from_string only returns HOURS, MINUTES, SECONDS and FRACTSECONDS from a given time string. Extended this function to return OFFHOURS, OFFMINUTES and OFFSIGN to get details of timeoffset from time string.

Cherry-picked from: #2613

Issues Resolved: BABEL-4896

Signed-off-by: Rohit Bhagat rohitbgt@amazon.com

41716 of 56992 relevant lines covered (73.2%)

107986.71 hits per line

Uncovered Existing Lines

Lines Coverage ∆ File
1
84.97
 -0.27% contrib/babelfishpg_tsql/src/collation.c
Jobs
ID Job ID Ran Files Coverage
1 9263552896.1 114
73.2
 GitHub Action Run
Source Files on build 9263552896