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
To use math functions like pow() and round(), you currently have to do go build -tags "sqlite_math_functions" .... This works, but this build tag is often forgotten/missed until an error like "not such function" is kicked out.
I think it should be considered to add the math functions into builds by default (aka no build tag required). I think it is common enough to use round(), 'floor(), and ceil() that adding the math functions by default would make sense.
This would help adapting SQL queries from MySQL/MariaDB or Postgres where the math functionality is always present. It would also help swapping in this library versus the modernc/cznic library that has the math functionality enabled by default [1]
Obviously, the README would need updated to either remove the "Math Functions" from the "Feature/Extension List" table too (or note that the math functions are built-in).
To use math functions like
pow()
andround()
, you currently have to dogo build -tags "sqlite_math_functions" ...
. This works, but this build tag is often forgotten/missed until an error like "not such function" is kicked out.I think it should be considered to add the math functions into builds by default (aka no build tag required). I think it is common enough to use
round()
, 'floor()
, andceil()
that adding the math functions by default would make sense.This would help adapting SQL queries from MySQL/MariaDB or Postgres where the math functionality is always present. It would also help swapping in this library versus the modernc/cznic library that has the math functionality enabled by default [1]
[1] https://gitlab.com/cznic/sqlite/-/tags/v1.14.5
The text was updated successfully, but these errors were encountered: