Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQLITE_ENABLE_DBSTAT_VTAB #231

Closed
orsinium opened this issue Jan 26, 2023 · 5 comments · Fixed by #232
Closed

SQLITE_ENABLE_DBSTAT_VTAB #231

orsinium opened this issue Jan 26, 2023 · 5 comments · Fixed by #232

Comments

@orsinium
Copy link

When I try to query the dbstat table I get the following exception:

     ** (Exqlite.Error) no such table: dbstat
     SELECT * FROM dbstat;

My noob understanding of the issue is that exlite ships with a sqlite version inside that is built without the "SQLITE_ENABLE_DBSTAT_VTAB" compile-time option. Is there a way to set it? I tried to export EXQLITE_USE_SYSTEM=1 and export SQLITE_ENABLE_DBSTAT_VTAB=1 and then mix deps.compile --force, nothing worked so far.

@orsinium
Copy link
Author

I also tried:

export EXQLITE_SYSTEM_CFLAGS=-DSQLITE_ENABLE_DBSTAT_VTAB=1
mix deps.compile --force 

@warmwaffles
Copy link
Member

Sure it's a simple add to the -D list in the makefile. Looks like it works.

@warmwaffles
Copy link
Member

I also noticed that we do not use EXQLITE_SYSTEM_CFLAGS unless we undefine EXQLITE_USE_SYSTEM. So that will need to be changed.

@orsinium let me get this in and I can cut a v0.13.1 release

@warmwaffles
Copy link
Member

@orsinium released under v0.13.1

@orsinium
Copy link
Author

It works! Thank you :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants