amazon-aurora / babelfish_extensions / 20520045719

76%

main: 77%

push

github

Fix various whitespaces in system function ISNUMERIC (#4275)

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

Issues Resolved
[BABEL-6174]

Author: Tanya Gupta <tanyagp@amazon.com>

21 of 21 new or added lines in 1 file covered. (100.0%)

50493 of 66261 relevant lines covered (76.2%)

393199.83 hits per line