Skip to content
Fencer Vulns
high 7.5

CVE-2019-19923 json

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…

published 2019-12-24 6 y ago modified 2026-10-14 26 d ago also EUVD-2019-9512

cvss
7.5
version 3.1, NVD
cisa kev
Not listed
not in CISA's catalog
epss
6.8%
EPSS 6.8% chance of exploitation in 30 days, percentile 94%
public exploits
0
none known

Summary

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

Patch / fix

  • Siemens SIMATIC S7-1500 CPU 1518-4 PN/DP MFP V3.1.5
  • Siemens SIMATIC S7-1500 CPU 1518F-4 PN/DP MFP V3.1.5
  • Siemens SIPLUS S7-1500 CPU 1518-4 PN/DP MFP V3.1.5
  • sqlite3 Debian 14, Debian 13, Debian 12 3.30.1+fossil191229-1
  • chromium Debian 14, Debian 13, Debian 12 80.0.3987.106-1

debian advisories DEBIAN-CVE-2019-19923

  • sqlite3 Ubuntu 18.04 LTS 3.22.0-1ubuntu0.3

ubuntu advisories UBUNTU-CVE-2019-19923

Ubuntu security data © Canonical Ltd., from https://github.com/canonical/ubuntu-security-notices via OSV; changed: normalised to fixed package versions per release. CC BY-SA 4.0

  • sqlite RHEL 8 3.26.0-6.el8
  • lemon RHEL 8 3.26.0-6.el8
  • sqlite-libs RHEL 8 3.26.0-6.el8
  • chromium-browser RHEL 6 EXTRAS 80.0.3987.87-1.el6_10

red hat advisories RHSA-2020:1810RHSA-2020:0514

  • sqlite3 SLES for SAP 12 SP5, SLES for SAP 12 SP4, SLES for SAP 12 SP3 +11 more 3.36.0-9.18.1
  • sqlite3 SLES for SAP 15 SP1, SLES for SAP 15, SLES 15-LTSS +13 more 3.36.0-3.12.1

suse advisories SUSE-SU-2021:3215-1SUSE-SU-2021:2320-1

  • chromium openSUSE Tumbleweed 93.0.4577.82-1.1
  • chromium openSUSE Tumbleweed 113.0.5672.92-1.1
  • sqlite3 openSUSE Leap 15.2 3.36.0-lp152.4.3.1
  • sqlite3 openSUSE Leap 15.3 3.36.0-3.12.1
  • re2 Package Hub 12 SP3, Package Hub 12 20200101-25.1
  • chromium Package Hub 12 SP3, Package Hub 12 80.0.3987.87-31.1
  • chromium Package Hub 15 SP1 80.0.3987.87-bp151.3.59.1
  • chromium openSUSE Leap 15.1 80.0.3987.87-lp151.2.63.1

opensuse advisories openSUSE-SU-2024:10681-1openSUSE-SU-2024:12948-1openSUSE-SU-2021:1058-1openSUSE-SU-2021:2320-1openSUSE-SU-2020:0233-1openSUSE-SU-2020:0210-1

  • chromium Arch Linux 80.0.3987.87-1

arch linux advisories AVG-1092

Vendor advisories

What the vendors themselves say about their products: affected, fixed or not affected, and what to do.

red hat product security vex CVE-2019-19923 updated cvss 7.5

sqlite: mishandling of certain uses of SELECT DISTINCT involving a LEFT JOIN in flattenSubquery in select.c leads to a NULL pointer dereference

  • Red Hat Enterprise Linux AppStream (v. 8) lemon 3.26.0-6.el8 Red Hat Enterprise Linux BaseOS (v. 8) sqlite 3.26.0-6.el8, sqlite-libs 3.26.0-6.el8
    fixed: vendor fix RHSA-2020:1810
  • Red Hat Enterprise Linux Desktop Supplementary (v. 6) chromium-browser 80.0.3987.87-1.el6_10 Red Hat Enterprise Linux HPC Node Supplementary (v. 6) chromium-browser 80.0.3987.87-1.el6_10 Red Hat Enterprise Linux Server Supplementary (v. 6) chromium-browser 80.0.3987.87-1.el6_10 Red Hat Enterprise Linux Workstation Supplementary (v. 6) chromium-browser 80.0.3987.87-1.el6_10
    fixed: vendor fix RHSA-2020:0514
  • Red Hat Enterprise Linux 5 sqlite Red Hat Enterprise Linux 6 lemon, sqlite, sqlite-tcl Red Hat Enterprise Linux 7 lemon, sqlite, sqlite-tcl
    not affected: vulnerable code not present

Red Hat CSAF VEX © Red Hat, Inc., from https://security.access.redhat.com/data/csaf/v2/vex/; changed: reduced to product statuses and remediations. CC BY 4.0 · csaf

cisa ICSA-23-348-10 updated cvss 7.5

Siemens SIMATIC S7-1500

  • Siemens SIMATIC S7-1500 CPU 1518-4 PN/DP MFP (6ES7518-4AX00-1AB0) >= 3.1.0, < 3.1.5 Siemens SIMATIC S7-1500 CPU 1518-4 PN/DP MFP (6ES7518-4AX00-1AC0) >= 3.1.0, < 3.1.5 Siemens SIMATIC S7-1500 CPU 1518F-4 PN/DP MFP (6ES7518-4FX00-1AB0) >= 3.1.0, < 3.1.5 Siemens SIMATIC S7-1500 CPU 1518F-4 PN/DP MFP (6ES7518-4FX00-1AC0) >= 3.1.0, < 3.1.5 Siemens SIPLUS S7-1500 CPU 1518-4 PN/DP MFP (6AG1518-4AX00-4AC0) >= 3.1.0, < 3.1.5
    affected: fixed in V3.1.5, mitigation support.industry.siemens.com

Facts from CISA's republication of the vendor's own advisory (CSAF); the linked advisory is the authoritative source. CISA notification · csaf

Exploit prediction

6.81% chance of exploitation in the next 30 days, higher than 94% of all scored CVEs (FIRST EPSS, 2026-11-08).

CVSS scores

assigned by version score vector
NVD 3.1 7.5 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H
NVD 2.0 5.0 AV:N/AC:L/Au:N/C:N/I:N/A:P

Affected products

  • Siemens SIMATIC S7-1500 CPU 1518-4 PN/DP MFP
  • Siemens SIMATIC S7-1500 CPU 1518F-4 PN/DP MFP
  • Siemens SIPLUS S7-1500 CPU 1518-4 PN/DP MFP

Classification

Weakness

References

Sources

Fencer Vulns keeps one entry per vulnerability: the CVE id wins, then GHSA, and records that alias each other are merged, except that two CVEs always keep separate entries. The same data is available as JSON.