Release 0.22.0: the index_info pragma stopped working

[orsinium]

In #232, the SQLITE_ENABLE_DBSTAT_VTAB option was enabled that made pragmas work with exqlite. That, in turn, made ecto_sqlite3_extras possible. However, in 0.22.0 release of exqlite (which seems to only update the sqlite version), the index_info pragma started to return no results.

• PR: Bump exqlite from 0.21.0 to 0.22.0 orsinium-labs/ecto_sqlite3_extras#33
• Failing query: https://github.com/orsinium-labs/ecto_sqlite3_extras/blob/master/lib/queries/index_size.ex#L26
• Sqlite changelog: https://www.sqlite.org/changes.html
• Exqlite diff between releases: v0.21.0...v0.22.0

Do you know what might be the cause?

[orsinium]

Seems to work in 0.23.0 🤔

orsinium-labs/ecto_sqlite3_extras#37

[warmwaffles]

With v0.22 which version of exqlite where you testing with?

[orsinium]

With v0.22 which version of exqlite where you testing with?

With exqlite 0.22.0. You can find both builds in the dependabot PRs:

• Bump exqlite from 0.21.0 to 0.22.0 orsinium-labs/ecto_sqlite3_extras#33
• Bump exqlite from 0.21.0 to 0.23.0 orsinium-labs/ecto_sqlite3_extras#37

[warmwaffles]

I don't know the reason for that failure TBH.

[orsinium]

That's alright, it seems to work now. Thank you for looking into it ❤️