| Name | CVE-2019-19244 |
| Description | sqlite3Select 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. |
| Source | CVE (at NVD; CERT, LWN, oss-sec, fulldisc, Red Hat, Ubuntu, Gentoo, SUSE bugzilla/CVE, GitHub advisories/code/issues, web search, more) |
| Debian Bugs | 946656 |
Vulnerable and fixed packages
The table below lists information on source packages.
| Source Package | Release | Version | Status |
|---|
| sqlite (PTS) | buster | 2.8.17-15 | fixed |
| buster (security) | 2.8.17-15+deb10u1 | fixed |
| sqlite3 (PTS) | buster | 3.27.2-3+deb10u1 | vulnerable |
| buster (security) | 3.27.2-3+deb10u2 | vulnerable |
| bullseye | 3.34.1-3 | fixed |
| bookworm | 3.40.1-2 | fixed |
| trixie | 3.45.1-1 | fixed |
| sid | 3.45.3-1 | fixed |
The information below is based on the following data on fixed versions.
| Package | Type | Release | Fixed Version | Urgency | Origin | Debian Bugs |
|---|
| sqlite | source | (unstable) | (not affected) | | | |
| sqlite3 | source | jessie | (not affected) | | | |
| sqlite3 | source | stretch | (not affected) | | | |
| sqlite3 | source | (unstable) | 3.30.1+fossil191229-1 | unimportant | | 946656 |
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