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
This is how NaN, +Infinity, and -Infinity values of type DOUBLE PRECISION are created:
select log\(1, 1\), log\(1, 0\.5\), log\(1, 1\.5\) from RDB$DATABASE
It's possible to get a NaN value of type FLOAT:
select cast\(log\(1, 1\) as float\) from RDB$DATABASE
But infinities cannot be cast to FLOAT:
select cast\(log\(1, 1\.5\) as float\) from RDB$DATABASE
This is producing an error:
> SQL Error [335544916] [22003]: arithmetic exception, numeric overflow, or string truncation; numeric value is out of range [SQLState:22003, ISC error code:335544916]
Submitted by: Lukas Eder (lukas.eder)
According to the docs:
https://firebirdsql.org/refdocs/langrefupd25-intfunc-log.html
This is how NaN, +Infinity, and -Infinity values of type DOUBLE PRECISION are created:
It's possible to get a NaN value of type FLOAT:
But infinities cannot be cast to FLOAT:
This is producing an error:
> SQL Error [335544916] [22003]: arithmetic exception, numeric overflow, or string truncation; numeric value is out of range [SQLState:22003, ISC error code:335544916]
See also this Stack Overflow question:
https://stackoverflow.com/q/66763171/521799
Commits: 2ec5134 a640e2f
The text was updated successfully, but these errors were encountered: