sqlite3 doesn't build with -DSQLITE_ENABLE_DBPAGE_VTAB with bitbake

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

sqlite3 doesn't build with -DSQLITE_ENABLE_DBPAGE_VTAB with bitbake

Kevin Dankwardt
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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users