power function not supported

tekartik / sqflite

SQLite flutter plugin

BSD 2-Clause "Simplified" License

2.88k stars 527 forks source link

power function not supported #1100

Closed bishal-rumba007 closed 5 months ago

bishal-rumba007 commented 7 months ago

I am getting this error saying no such function: power

E/flutter (11236): [ERROR:flutter/runtime/dart_vm_initializer.cc(41)] Unhandled Exception: DatabaseException(no such function: POWER (code 1 SQLITE_ERROR): , while compiling: insert into

While executing complex query imported from .sql file, is there any work around for this? I also tried to use EXP and LN for which is also not available.

alextekartik commented 6 months ago

I guess it depends on the native implementation. You might want to try using sqflite_common_ffi and sqlite flutter libs https://pub.dev/packages/sqflite_common_ffi