| Name | CVE-2019-19317 |
| Description | lookupName in resolve.c in SQLite 3.30.1 omits bits from the colUsed bitmask in the case of a generated column, which allows attackers to cause a denial of service or possibly have unspecified other impact. |
| Source | CVE (at NVD; CERT, LWN, oss-sec, fulldisc, Red Hat, Ubuntu, Gentoo, SUSE bugzilla/CVE, GitHub advisories/code/issues, web search, more) |
Vulnerable and fixed packages
The table below lists information on source packages.
| Source Package | Release | Version | Status |
|---|
| sqlite (PTS) | jessie, jessie (lts) | 2.8.17-12+deb8u1 | fixed |
| stretch (lts), stretch | 2.8.17-14+deb9u1 | fixed |
| buster (security), buster, buster (lts) | 2.8.17-15+deb10u1 | fixed |
| sqlite3 (PTS) | jessie, jessie (lts) | 3.8.7.1-1+deb8u8 | fixed |
| stretch (security) | 3.16.2-5+deb9u3 | fixed |
| stretch (lts), stretch | 3.16.2-5+deb9u4 | fixed |
| buster, buster (lts) | 3.27.2-3+deb10u3 | fixed |
| buster (security) | 3.27.2-3+deb10u2 | fixed |
| bullseye | 3.34.1-3 | fixed |
| bullseye (security) | 3.34.1-3+deb11u1 | fixed |
| bookworm | 3.40.1-2+deb12u1 | fixed |
| sid, trixie | 3.46.1-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 | wheezy | (not affected) | | | |
| sqlite3 | source | (unstable) | (not affected) | | | |
Notes
- sqlite3 <not-affected> (Generated column support was added with SQLite version 3.31.0)
- sqlite <not-affected> (Generated column support was added with SQLite version 3.31.0)
Fixed by: https://github.com/sqlite/sqlite/commit/522ebfa7cee96fb325a22ea3a2464a63485886a8
Additional testcases: https://github.com/sqlite/sqlite/commit/73bacb7f93eab9f4bd5a65cbc4ae242acf63c9e3
[wheezy] - sqlite3 <not-affected> (Generated column support was added with SQLite version 3.31.0)