| Name | CVE-2019-19923 |
| Description | flattenSubquery in select.c in SQLite 3.30.1 mishandles certain uses of SELECT DISTINCT involving a LEFT JOIN in which the right-hand side is a view. This can cause a NULL pointer dereference (or incorrect results). |
| Source | CVE (at NVD; CERT, LWN, oss-sec, fulldisc, Red Hat, Ubuntu, Gentoo, SUSE bugzilla/CVE, GitHub advisories/code/issues, web search, more) |
| References | DSA-4638-1 |
Vulnerable and fixed packages
The table below lists information on source packages.
| Source Package | Release | Version | Status |
|---|
| chromium (PTS) | buster, buster (security) | 90.0.4430.212-1~deb10u1 | fixed |
| bullseye (security), bullseye | 120.0.6099.224-1~deb11u1 | fixed |
| bookworm | 121.0.6167.139-1~deb12u1 | fixed |
| bookworm (security) | 123.0.6312.122-1~deb12u1 | fixed |
| trixie | 123.0.6312.105-1~deb13u1 | fixed |
| sid | 124.0.6367.60-1 | fixed |
| sqlite (PTS) | buster | 2.8.17-15 | fixed |
| buster (security) | 2.8.17-15+deb10u1 | fixed |
| sqlite3 (PTS) | buster | 3.27.2-3+deb10u1 | fixed |
| buster (security) | 3.27.2-3+deb10u2 | fixed |
| 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 |
|---|
| chromium | source | stretch | (unfixed) | end-of-life | | |
| chromium | source | buster | 80.0.3987.132-1~deb10u1 | | DSA-4638-1 | |
| chromium | source | (unstable) | 80.0.3987.106-1 | | | |
| sqlite | source | (unstable) | (not affected) | | | |
| sqlite3 | source | jessie | (not affected) | | | |
| sqlite3 | source | stretch | (not affected) | | | |
| sqlite3 | source | buster | 3.27.2-3+deb10u1 | | | |
| sqlite3 | source | (unstable) | 3.30.1+fossil191229-1 | | | |
Notes
[stretch] - sqlite3 <not-affected> (Vulnerable code introduced later)
[jessie] - sqlite3 <not-affected> (Vulnerable code introduced later)
- sqlite <not-affected> (Vulnerable code introduced later)
[stretch] - chromium <end-of-life> (see DSA 4562)
https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35