VDB

CVE-2019-19923

CVE-2019-19923 PUBLISHED

Reported by mitre · Published December 24, 2019

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

Fixed versions

Upgrade to a fixed version or later. Language registries are listed first, then Linux distributions, then vendor products.

PackageEcosystemFixed in
SIMATIC S7-1500 CPU 1518-4 PN/DP MFPSiemens3.1.5
SIMATIC S7-1500 CPU 1518F-4 PN/DP MFPSiemens3.1.5

Affected products

VendorProductVersions
n/an/an/a
SiemensSIMATIC S7-1500 CPU 1518-4 PN/DP MFP3.1.0
SiemensSIMATIC S7-1500 CPU 1518F-4 PN/DP MFP3.1.0
n/an/a*
SiemensSIPLUS S7-1500 CPU 1518-4 PN/DP MFP3.1.0
archchromium0

Timeline

  • Dec 24, 2019 CVE Published
  • Apr 14, 2021 EPSS Score (30 in total, the first dated here)
  • Dec 16, 2025 PoC Published
  • Mar 6, 2026 Distribution Patch (43 in total, the first dated here)
  • Mar 6, 2026 Security Advisory (55 in total, the first dated here)
  • Sep 12, 2026 Coalition ESS Score
  • Sep 20, 2026 CVE Updated

Query this with the API

The same record, from the CLI:

vulnetix vdb vuln CVE-2019-19923
vulnetix vdb fixes CVE-2019-19923

Or with curl, using the org id and key from your account page:

curl -s -H "Authorization: ApiKey ${VULNETIX_ORG_ID}:${VULNETIX_API_KEY}" \
  "https://api.vdb.vulnetix.com/v2/vuln/CVE-2019-19923/fixes/registry"

The Community plan is free and allows 50 queries a day. Get a free API key · API quickstart

References

Look up in the Resolve Platform →
$ Lookup Community · 50/day Open Lookup ›