Skip to content
Fencer Vulns
high 7.5

CVE-2019-19244 json

sqlite3Select in select.c in SQLite 3.30.1 allows a crash if a sub-select uses both DISTINCT and window functions, and also has certain ORD…

published 2019-11-25 6 y ago modified 2026-10-14 26 d ago also EUVD-2019-8870

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

Summary

sqlite3Select in select.c in SQLite 3.30.1 allows a crash if a sub-select uses both DISTINCT and window functions, and also has certain ORDER BY usage.

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

debian advisories DEBIAN-CVE-2019-19244

  • 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

  • sqlite3 openSUSE Leap 15.2 3.36.0-lp152.4.3.1
  • sqlite3 openSUSE Leap 15.3 3.36.0-3.12.1

opensuse advisories openSUSE-SU-2021:1058-1openSUSE-SU-2021:2320-1

  • sqlite Alpine 3.10, Alpine 3.9 3.28.0-r2
  • sqlite Alpine 3.24, Alpine 3.23, Alpine 3.22 +11 more 3.30.1-r1
  • sqlite Alpine 3.8 3.25.3-r3

alpine advisories ALPINE-CVE-2019-19244

Alpine secdb © Alpine Linux, from https://secdb.alpinelinux.org via OSV; changed: normalised to fixed package versions per release. CC BY-SA 4.0

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-19244 updated cvss 7.5

sqlite: allows a crash if a sub-select uses both DISTINCT and window functions and also has certain ORDER BY usage

  • Red Hat Enterprise Linux 5 sqlite Red Hat Enterprise Linux 6 lemon, sqlite, sqlite-tcl
    affected: no fix planned “Out of support scope”
  • Red Hat Enterprise Linux 7 lemon, sqlite, sqlite-tcl Red Hat Enterprise Linux 8 lemon, sqlite, sqlite-libs
    affected: no fix available “Fix deferred”

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

cisa ICSA-24-284-16 updated cvss 7.5

Rockwell Automation DataMosaix Private Cloud

  • Rockwell Automation DataMosaix Private Cloud <=7.07
    affected: mitigation “Rockwell Automation encourages users to implement security best practices to minimize the risk of the vulnerability.” rockwellautomation.custhelp.com

From CISA ICS and IT advisories (CSAF, https://github.com/cisagov/CSAF), a U.S. Government work; changed: reduced to products, statuses and remediations. CISA notification · csaf

CISA SSVC

Exploitation
none
Automatable
yes
Technical impact
partial
Assessed
31 d ago

Exploit prediction

3.59% chance of exploitation in the next 30 days, higher than 89% 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

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.