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 options I have tried various ways to add -DSQLITE_ENABLE_DBPAGE_VTAB in the recipe file sqlite3.inc, including setting CFLAGS_append, CFLAGS +=, and EXTRA_CFLAGS+= Interestingly if I change into the expanded source directory, and do ./configure --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 SQLITE_ENABLE_DBPAGE_VTAB. 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
