Open
Description
Introduction
Many built-in mathematical functions are unavailable because the file sqlite3.c
is compiled without the correct flag.
See rusqlite/rusqlite#1211 as the rationale behind the default compile settings chosen by the upstream library.
To Reproduce
Any query that uses a function from the page https://www.sqlite.org/draft/lang_mathfunc.html (such as exp
, log
and so on) will error out.
Expected behavior
I think that it would be a sensible default to enable this particular flag at compile time for SQLPage, since some of these functions are very useful in data manipulation.
Version information
- Database: the built-in SQLite DB
- SQLPage Version: 0.35.1
Additional context
I am opening a pull request with a config.toml
to compile using the -DSQLITE_ENABLE_MATH_FUNCTIONS
compile-time option.