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

Difference in included version of SQLite between 3.2.1 and 3.1.1 #3466

Open
AndreSteenveld opened this Issue Dec 4, 2018 · 0 comments

Comments

2 participants
@AndreSteenveld

AndreSteenveld commented Dec 4, 2018

There seems to be a difference in the compiled version of sqlite for version 3.2.1 and 3.1.1 on OSX, I haven't looked at any other operating systems. In sqlitestudio version 3.1.1 the output of pragma compile_options; is:

COMPILER=clang-6.1.0
ENABLE_FTS3
ENABLE_FTS5
ENABLE_JSON1
ENABLE_RTREE
SYSTEM_MALLOC
THREADSAFE=1

The output of the same command in version 3.2.1 is:

COMPILER=clang-6.1.0
ENABLE_FTS3
ENABLE_RTREE
THREADSAFE=1

To confirm this I've installed the latest version using brew ($ brew cask install sqlitestudio) and downloaded 3.1.1 from the sqlitestudio web page (https://sqlitestudio.pl/files/sqlitestudio3/complete/macosx/).

The lack of the JSON1 extension breaks some of my views but I can imagine that it would break full text search for other people. It took me a while to figure out that this was the problem because my database seemed to work well in older versions, it was rather counter intuitive.

As a work around I have installed version 3.1.1 on my system.

The low hanging fruit solution would seem to be including a version of sqlite which includes everything but the kitchen sink. But a better solution IMO would be to be able to specify your own binary for sqlite.

@pawelsalawa pawelsalawa added the bug label Dec 4, 2018

@pawelsalawa pawelsalawa added this to the 3.2.2 milestone Dec 4, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment