CVE-2019-19244

NameCVE-2019-19244
Descriptionsqlite3Select in select.c in SQLite 3.30.1 allows a crash if a sub-select uses both DISTINCT and window functions, and also has certain ORDER BY usage.
SourceCVE (at NVD; CERT, LWN, oss-sec, fulldisc, Red Hat, Ubuntu, Gentoo, SUSE bugzilla/CVE, GitHub advisories/code/issues, web search, more)
Debian Bugs946656

Vulnerable and fixed packages

The table below lists information on source packages.

Source PackageReleaseVersionStatus
sqlite (PTS)jessie, jessie (lts)2.8.17-12+deb8u1fixed
stretch (lts), stretch2.8.17-14+deb9u1fixed
buster2.8.17-15fixed
buster (security)2.8.17-15+deb10u1fixed
sqlite3 (PTS)jessie, jessie (lts)3.8.7.1-1+deb8u8fixed
stretch (security)3.16.2-5+deb9u3fixed
stretch (lts), stretch3.16.2-5+deb9u4fixed
buster3.27.2-3+deb10u1vulnerable
buster (security)3.27.2-3+deb10u2vulnerable
bullseye3.34.1-3fixed
bookworm3.40.1-2fixed
trixie3.45.1-1fixed
sid3.45.2-1fixed

The information below is based on the following data on fixed versions.

PackageTypeReleaseFixed VersionUrgencyOriginDebian Bugs
sqlitesource(unstable)(not affected)
sqlite3sourcewheezy(not affected)
sqlite3sourcejessie(not affected)
sqlite3sourcestretch(not affected)
sqlite3source(unstable)3.30.1+fossil191229-1unimportant946656

Notes

[stretch] - sqlite3 <not-affected> (Vulnerable code introduced later)
[jessie] - sqlite3 <not-affected> (Vulnerable code, i.e. window functions, not present)
- sqlite <not-affected> (Vulnerable code, i.e. window functions, not present)
https://github.com/sqlite/sqlite/commit/e59c562b3f6894f84c715772c4b116d7b5c01348
Only triggerable with SQLITE_DEBUG, which Debian builds don't use
[wheezy] - sqlite3 <not-affected> (Vulnerable code not present)

Search for package or bug name: Reporting problems