Reference page — cumulative record through Monday, October 19, 2026 UTC. Reference pages update as the archive grows; only dated daily editions are immutable pages of record.

CVE-2019-19923

CVE-2019-19923HIGH

n/a n/a — flattenSubquery in select.c in SQLite 3.30.1 mishandles certain uses of SELECT DISTINCT involving a LEFT JOIN in which the right-hand sid…

  AV  AC  PR  UI  S  C  I  A   CVSS    EPSS   %ile   KEV
   N   L   N   N  U  N  N  H    7.5   .0681   93.9     —

AFFECTED
  Product  Versions  Fixed
  n/a      n/a –     —

TIMELINE
  Dec 23  Reserved by mitre
  Dec 24  Published (CNA: mitre)
  Oct 14  ENRICHED — CVE-2019-19923. Received CVSS 7.5 and CPE data from NVD.

CWE-476 · CNA: mitre · CVSS v3.1 · 12 references · NVD status: Modified

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

Lifecycle

Complete event history — 3 events, chronological
Date	Event	Detail
December 23, 2019	Reserved	Reserved by mitre
December 24, 2019	Published	Published (CNA: mitre)
October 14, 2026	ENRICHED	ENRICHED — CVE-2019-19923. Received CVSS 7.5 and CPE data from NVD.

Affected

Affected products and packages — 1 row
Vendor	Product / Package	Ecosystem	Version introduced	Fixed
n/a	n/a	—	n/a	—

Weaknesses

CWE-476

References (12)

http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00010.html [Mailing List, Third Party Advisory]
http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00015.html [Mailing List, Third Party Advisory]
http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00025.html [Mailing List, Third Party Advisory]
https://access.redhat.com/errata/RHSA-2020:0514 [Third Party Advisory]
https://cert-portal.siemens.com/productcert/html/ssa-389290.html
https://cert-portal.siemens.com/productcert/html/ssa-398330.html
https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf [Patch, Third Party Advisory]
https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35 [Patch]
https://security.netapp.com/advisory/ntap-20200114-0003/ [Third Party Advisory]
https://usn.ubuntu.com/4298-1/ [Broken Link]
https://www.debian.org/security/2020/dsa-4638 [Third Party Advisory]
https://www.oracle.com/security-alerts/cpuapr2020.html [Patch, Third Party Advisory]

Authoritative record: CVE-2019-19923 at cve.org

Weaknesses: CWE-476

About this page

This is a reference page, not a dated page of record. It assembles the complete lifecycle of CVE-2019-19923 from the CVE Program record, NVD enrichment, the CISA KEV catalog, EPSS, and OSV advisories. The box score's numbers (CVSS, EPSS, KEV status) are current as of Monday, October 19, 2026 UTC and are re-derived as the archive grows; only dated daily editions are immutable pages of record. The authoritative source for this identifier is cve.org.