babelfish-for-postgresql / babelfish_extensions / 20519729256

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%)

52503 of 68299 relevant lines covered (76.87%)

389212.97 hits per line