#1107146 sqlite3 does not look in XDG_CONFIG_HOME for config file as described in man page

Package:
sqlite3
Source:
sqlite3
Description:
Command line interface for SQLite 3
Submitter:
Bastian Venthur
Date:
2025-06-02 09:49:02 UTC
Severity:
normal
#1107146#5
Date:
2025-06-02 08:31:12 UTC
From:
To:
Dear Maintainer,

the man page of sqlite3 says

however, it does not look in XDG_CONFIG_HOME at all. You can verify with

```
strace -f -t -e trace=file sqlite3
```

Cheers,

Bastian
#1107146#10
Date:
2025-06-02 09:04:53 UTC
From:
To:
[Bastian Venthur]

Sure enough.

% echo | XDG_CONFIG_HOME=/tmp strace -f -t -e trace=file sqlite3 2>&1 |grep /tmp
%
#1107146#15
Date:
2025-06-02 09:38:43 UTC
From:
To:
since

```
echo | XDG_CONFIG_HOME=/tmp strace -f -t -e trace=file sqlite3 2>&1 |grep /tmp
```

reveals that sqlite3 looks into `XDG_CONFIG_HOME` if the environment variable
is set but does not if it is not set, I assume it only partially implements the
standard. Because according to:

https://specifications.freedesktop.org/basedir-spec/latest/#variables

which is what all other applications I've encountered so far do.


Cheers,

Bastian
#1107146#20
Date:
2025-06-02 09:46:44 UTC
From:
To:
FYI: Seems like upstream has a fix applied for this issue:

https://www.sqlite.org/src/info/33841c9c3cb57bee

which seems not available in Debian's sources.