search

capacitor-community / sqlite

Community plugin for native & electron SQLite databases
MIT License
433 stars 106 forks source link

Add support of math functions #446

Closed quolpr closed 9 months ago

quolpr commented 10 months ago

We recently discovered that at least iOS version (not sure about android) misses math functions https://www.sqlite.org/lang_mathfunc.html . We tried to use SQRT function, but SQLite returns "no such function: SQRT".

The example query is: SELECT SQRT(4)

jepiqueau commented 9 months ago

@quolpr can you try to add -DSQLITE_ENABLE_MATH_FUNCTIONS in the OTHER_CFLAGS for the file SQLCipher.debug and SQLCipher.release in the Pods/SQLCipher/Support Files rebuild and tell me if it works

jepiqueau commented 9 months ago

@quolpr it is not supported by android.sqlite so i will close it as not planned