Skip to content

SQLite built-in math functions are not available in SQLPage #937

Open
@francesco-cattoglio

Description

@francesco-cattoglio

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions