You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
summary: TRUNC() does not accept second argument = -128 (but show it as required boundary in error message) => TRUNC() does not accept second argument = -128 (but shows it as required boundary in error message)
I'm not sure the range of [-128, 127] makes sense for the TRUNC function. The range should be the amount of decimal digits, so the correct range would be [-38,38] as far as I can tell. Where does the range [-128, 127] come from?
Submitted by: @pavel-zotov
Rollowing commands have the same issue on 2.5, 3.0 & 4.0:
SQL> set heading off;
SQL> select trunc(1,-127) from rdb$database;
SQL> select trunc(1,-128) from rdb$database;
Statement failed, SQLSTATE = 42000
expression evaluation not supported
-The numeric scale must be between -128 and 127 in TRUNC
Commits: fc6b04f
The text was updated successfully, but these errors were encountered: