sqlite3 doesn't build with -DSQLITE_ENABLE_DBPAGE_VTAB with bitbake
I need sqlite3 to be built with -DSQLITE_ENABLE_DBPAGE_VTAB so that I can
use the ".recover" command. The ".dbinfo" command doesn't work either.
I add -DSQLITE_ENABLE_DBPAGE_VTAB to the sqlite recipe CFLAGS in various
ways but I never get sqlite3 built with the option. Example error: the
".dbinfo" command requires the -DSQLITE_ENABLE_DBPAGE_VTAB compile-time
I have tried various ways to add -DSQLITE_ENABLE_DBPAGE_VTAB in the recipe
file sqlite3.inc, including setting CFLAGS_append, CFLAGS +=, and
Interestingly if I change into the expanded source directory, and do
--host=x86_64and then make (I have an ARM toolchain set-up), I get a
version of sqlite3 that does have SQLITE_ENABLE_DBPAGE_VTAB.
I am doing bitbake sqlite, and even tried rm -rf build/tmp and have
everything rebuilt. The sqlite3 command just doesn't get
EXTRA_CFLAGS += " -DSQLITE_ENABLE_DBPAGE_VTAB "
This is the error.
SQLite version 3.29.0 2019-07-10 17:32:03 Enter ".help" for usage hints.
sqlite> .dbinfo the ".dbinfo" command requires the
-DSQLITE_ENABLE_DBPAGE_VTAB compile-time options sqlite> .quit
This is with the hand-made version
#/new/sqlite3 my.db SQLite version 3.29.0 2019-07-10 17:32:03 Enter ".help"
for usage hints. sqlite> .dbinfo database page size: 4096 write format: 1
read format: 1 reserved bytes: 0 file change counter: 97071 database page
count: 1795 freelist page count: 0 schema cookie: 10 schema format: 4
default cache size: 0 autovacuum top root: 0 incremental vacuum: 0 text
encoding: 1 (utf8) user version: 0 application id: 0 software version:
3029000 number of tables: 10 number of indexes: 2 number of triggers: 0
number of views: 0 schema size: 977 data version 1 sqlite>
sqlite-users mailing list
[hidden email] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users