babelfish-for-postgresql / babelfish_extensions / 17849248151

76%

BABEL_5_X_DEV: 77%

push

github

SET DATEFIRST should only accept integer arguments (#4044) (#4102)

This commit enables the check that allows only integral values to be set as a DATEFIRST values

Previously, customer could use non integral values to set the value of DATEFIRST

1> SET DATEFIRST 6.5
2> GO
1> SELECT @@DATEFIRST
2> GO

datefirst  
-----------
          6

Changes made to fix the issue:

To fix this issue we added a check to only allow integral values to be used to set the value of DATEFIRST

1> SET DATEFIRST 6.5
2> GO
Msg 2743, Level 16, State 3, Server EC2AMAZ-GOMIGPU, Line 1
SET DATEFIRST option requires integer parameter.

Task: BABEL-5841

Signed-off-by: Jaspal Singh ijaspals@amazon.com

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

49972 of 65736 relevant lines covered (76.02%)

385276.32 hits per line