babelfish-for-postgresql / babelfish_extensions / 20565287108

76%

BABEL_6_X_DEV: 78%

Build Type

push

github

Committed by web-flow

Commit Message

Fix various whitespaces in system function ISNUMERIC (#4275) (#4357)

This commit handles various types of whitespaces in Babelfish for isnumeric(),
ensuring compatibility with T-SQL behavior. T-SQL allows leading special
whitespace to be trimmed but treats trailing special whitespace after numeric
content as non-numeric. We have also handled arithmetic operations between
these whitespaces and other characters. 

Following are the result:

1 - Contains only special whitespace (\t, \n, \v, \f, \r)
0 - Empty string or contains only spaces
-1 - Contains other characters (needs numeric conversion)
0 - Contains other characters and ends with special whitespace

Task: BABEL-6174

Author: Tanya Gupta <tanyagp@amazon.com>

Coverage Stats

21 of 0 new or added lines in 0 files covered. (NaN%)

103 existing lines in 1 file now uncovered.

50493 of 66261 relevant lines covered (76.2%)

393722.99 hits per line