CVE-2019-19923NULL Pointer Dereference in Sqlite

Severity
7.5HIGHNVD
EPSS
6.2%
top 9.11%
CISA KEV
Not in KEV
Exploit
No known exploits
Timeline
PublishedDec 24
Latest updateMay 24

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).

CVSS vector

CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:HExploitability: 3.9 | Impact: 3.6

Affected Packages10 packages

Debianghost/sqlite3< 3.30.1+fossil191229-1+3
NVDsqlite/sqlite3.30.1
Debianchromium/chromium< 80.0.3987.106-1+3

Also affects: Debian Linux 10.0, 9.0

Patches

🔴Vulnerability Details

3
GHSA
GHSA-5gmx-grg5-hh7x: flattenSubquery in select2022-05-24
CVEList
CVE-2019-19923: flattenSubquery in select2019-12-24
OSV
CVE-2019-19923: flattenSubquery in select2019-12-24

📋Vendor Advisories

4
Ubuntu
SQLite vulnerabilities2020-03-10
Chrome
Stable Channel Update for Desktop: CVE-2019-199232020-02-04
Red Hat
sqlite: mishandling of certain uses of SELECT DISTINCT involving a LEFT JOIN in flattenSubquery in select.c leads to a NULL pointer dereference2020-01-08
Debian
CVE-2019-19923: chromium - flattenSubquery in select.c in SQLite 3.30.1 mishandles certain uses of SELECT D...2019

💬Community

3
Bugzilla
CVE-2019-19923 sqlite: mishandling of certain uses of SELECT DISTINCT involving a LEFT JOIN in flattenSubquery in select.c leads to a NULL pointer dereference [fedora-30]2020-01-10
Bugzilla
CVE-2019-19923 sqlite: mishandling of certain uses of SELECT DISTINCT involving a LEFT JOIN in flattenSubquery in select.c leads to a NULL pointer dereference2020-01-08
Bugzilla
CVE-2019-19923 sqlite: mishandling of certain uses of SELECT DISTINCT involving a LEFT JOIN in flattenSubquery in select.c leads to a NULL pointer dereference [fedora-31]2020-01-08
CVE-2019-19923 — NULL Pointer Dereference in Sqlite | cvebase