CVE-2019-19923

NameCVE-2019-19923
DescriptionflattenSubquery 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).
SourceCVE (at NVD; CERT, LWN, oss-sec, fulldisc, bugtraq, EDB, Metasploit, Red Hat, Ubuntu, Gentoo, SUSE bugzilla/CVE, Mageia, GitHub code/issues, web search, more)
ReferencesDSA-4638-1
NVD severitymedium

Vulnerable and fixed packages

The table below lists information on source packages.

Source PackageReleaseVersionStatus
chromium (PTS)stretch (security)73.0.3683.75-1~deb9u1vulnerable
buster, buster (security)80.0.3987.162-1~deb10u1fixed
bullseye, sid81.0.4044.92-1fixed
sqlite3 (PTS)jessie3.8.7.1-1+deb8u2fixed
jessie (security)3.8.7.1-1+deb8u6fixed
stretch3.16.2-5+deb9u1fixed
buster3.27.2-3vulnerable
bullseye3.31.1-5fixed
sid3.32.1-1fixed

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

PackageTypeReleaseFixed VersionUrgencyOriginDebian Bugs
chromiumsource(unstable)80.0.3987.106-1
chromiumsourcebuster80.0.3987.132-1~deb10u1DSA-4638-1
chromiumsourcestretch(unfixed)end-of-life
sqlite3source(unstable)3.30.1+fossil191229-1
sqlite3sourcejessie(not affected)
sqlite3sourcestretch(not affected)

Notes

[buster] - sqlite3 <no-dsa> (Minor issue)
[stretch] - sqlite3 <not-affected> (Vulnerable code introduced later)
[jessie] - sqlite3 <not-affected> (Vulnerable code introduced later)
[stretch] - chromium <end-of-life> (see DSA 4562)
https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35

Search for package or bug name: Reporting problems