Arch Linux

sayonalion

Member

Registered: 2016-10-25

Posts: 46

[SOLVED] SQLite version doesn't change

Hi.

After update sqlite package to version 3.35.1, the program itself is not updated and remains of version 3.32.2.

Here's the steps I perform:

1. Run `pacman -Syu` — the installed packages are updated including the sqlite package;

2. Run `pacman -Qi sqlite | grep Version` — Version :  3.35.1-1;

3. Run `sqlite3 --version` — 3.32.2 2020-06-04 12:58:43 ec02243ea6ce33b090870ae55ab8aa2534b54d216d45c4aa2fdbb00e8686alt2.

The DBMS obviously lacks the features that have been added to the new version.

What is the reason of this inconsistency?

Thanks.

Last edited by sayonalion (2021-03-16 20:29:59)

tucuxi

Member

From: Switzerland

Registered: 2020-03-08

Posts: 291

Re: [SOLVED] SQLite version doesn't change

Here:

$ pacman -Q sqlite3
sqlite 3.35.1-2
$ sqlite3 --version
3.35.1 2021-03-15 16:53:57 aea12399bf1fdc76af43499d4624c3afa17c3e6c2459b71c195804bb98dealt1

Try `type sqlite3`.

sayonalion

Member

Registered: 2016-10-25

Posts: 46

Re: [SOLVED] SQLite version doesn't change

$ type sqlite3
sqlite3 is /opt/android-sdk/platform-tools/sqlite3

As it turned out the Android SDK uses its own version of SQLite. It's installed as a part of a package platform-tools after you run the command `sdkmanager platform-tools`. sdkmanager itself is a part of the android-sdk-cmdline-tools-latest Arch AUR package. /opt/android-sdk/platform-tools was in my PATH, so the shell was using the Android SDK sqlite3 executable instead of the system one.

tucuxi, thanks for the help.