BlackTreeCVE Intelligence
← Back to the CVE catalogue
Full vulnerability report · 2020
CVE-2019-20218High confidence

selectExpander in select.c in SQLite 3.30.1 proceeds with WITH stack unwinding even after a parsing error

Siemens · SIMATIC S7-1500 CPU 1518-4 PN/DP MFP

Official source article: Siemens SSA-398330 ↗. Check the applicable product and release in the original source.

7.5HighCVSS 3.1
Recommended action
Patch only the product branches with a verified fix

High technical severity; prioritise exposed affected systems while verifying vendor guidance. Verified remediation exists for at least one product or source, but 5 structured product or package states remain unresolved. Apply remediation only to the exact product branch confirmed by its source.

Fix availability varies by product
R
Operational reassessment

Published severity in operational context

Open reassessment dashboard →
Published severityHighOperational priority:High, unchanged from published severity.unchanged

Evidence used

  • No CISA KEV confirmation is currently recorded.
  • The selected CVSS metric records a network-reachable, unauthenticated path with no user interaction.
  • EPSS is 3.74% for the current model date.

Compensating controls

  • Validate the affected product branch and deploy the verified fixed release.
  • Restrict the affected network interface to trusted sources where business-safe.
  • Monitor vendor guidance and exploitation sources for a material change.

Verification

  1. Confirm that the asset runs Siemens SIMATIC S7-1500 CPU 1518-4 PN/DP MFP and falls inside the recorded affected range.
  2. Verify the installed build against the product-specific fixed version after deployment.
  3. Validate exposure, authentication requirements and compensating controls in the actual environment.
  4. Reopen this reassessment when CVSS, KEV, EPSS, exploit evidence or remediation changes.
Mitigation target: Within 30 daysRemediation target: Within 180 days

This automated reassessment organises public evidence. It does not know asset exposure, business impact or control effectiveness and does not replace CVSS or a human risk decision.

Cross-source reconciliation

Remediation availability differs by product scope

Verified remediation exists for at least one product or source, but 5 structured product or package states remain unresolved. Apply remediation only to the exact product branch confirmed by its source.

Distribution package intelligence

Release-specific package status

Debian findings are scoped to the named distribution, release and source package. An absent finding does not mean a package is unaffected.

4 package states
Repository candidate not checked

A published vendor fix does not prove that a matching update is enabled and installable on a particular asset. Confirm the local package candidate before scheduling remediation.

Distribution releaseSource packageVendor stateFixed versionEvidence
Debian trixietrixie · sourcesqlite3Vendor fix publishedDebian records a fixed source-package version for this release.3.30.1+fossil191229-1Debian Security Tracker ↗Source updated 24 Oct 2026
Debian bookwormbookworm · sourcesqlite3Vendor fix publishedDebian records a fixed source-package version for this release.3.30.1+fossil191229-1Debian Security Tracker ↗Source updated 24 Oct 2026
Debian forkyforky · sourcesqlite3Vendor fix publishedDebian records a fixed source-package version for this release.3.30.1+fossil191229-1Debian Security Tracker ↗Source updated 24 Oct 2026
Debian sidsid · sourcesqlite3Vendor fix publishedDebian records a fixed source-package version for this release.3.30.1+fossil191229-1Debian Security Tracker ↗Source updated 24 Oct 2026
Direct vendor intelligence

Authoritative vendor CSAF and VEX advisories

Structured product status and remediation from the issuing vendor. Product-state explanations are always visible; large lists can be searched or downloaded.

3 current
CVE-2019-20218 · CSAF 2.0 · revision 3 · finalRed Hat Product Securitysqlite: selectExpander in select.c proceeds with WITH stack unwinding even after a parsing error
13 known affected

The vendor explicitly identifies these products as affected by this CVE.

  • sqlite.src as a component of Red Hat Enterprise Linux 5
  • lemon as a component of Red Hat Enterprise Linux 6
  • sqlite as a component of Red Hat Enterprise Linux 6
  • sqlite-devel as a component of Red Hat Enterprise Linux 6
  • sqlite-doc as a component of Red Hat Enterprise Linux 6
  • sqlite-tcl as a component of Red Hat Enterprise Linux 6
  • sqlite.src as a component of Red Hat Enterprise Linux 6
  • lemon as a component of Red Hat Enterprise Linux 7
  • sqlite as a component of Red Hat Enterprise Linux 7
  • sqlite-devel as a component of Red Hat Enterprise Linux 7
  • sqlite-doc as a component of Red Hat Enterprise Linux 7
  • sqlite-tcl as a component of Red Hat Enterprise Linux 7
Summary
selectExpander in select.c in SQLite 3.30.1 proceeds with WITH stack unwinding even after a parsing error.
Remediation
For details on how to apply this update, which includes the changes described in this advisory, refer to: https://access.redhat.com/articles/11258
SSA-398330 · CSAF 2.0 · revision 19 · interimSiemens ProductCERTCVE-2019-20218
5 known affected

The vendor explicitly identifies these products as affected by this CVE.

  • SIMATIC S7-1500 CPU 1518-4 PN/DP MFP (6ES7518-4AX00-1AB0) >= V3.1.0 < V3.1.5
  • SIMATIC S7-1500 CPU 1518-4 PN/DP MFP (6ES7518-4AX00-1AC0) >= V3.1.0 < V3.1.5
  • SIMATIC S7-1500 CPU 1518F-4 PN/DP MFP (6ES7518-4FX00-1AB0) >= V3.1.0 < V3.1.5
  • SIMATIC S7-1500 CPU 1518F-4 PN/DP MFP (6ES7518-4FX00-1AC0) >= V3.1.0 < V3.1.5
  • SIPLUS S7-1500 CPU 1518-4 PN/DP MFP (6AG1518-4AX00-4AC0) >= V3.1.0 < V3.1.5
Summary
selectExpander in select.c in SQLite 3.30.1 proceeds with WITH stack unwinding even after a parsing error.
Remediation
Update to V3.1.5 or later version
CVE-2019-20218 · CSAF 2.0 · revision 47 · interimSUSE Product Security TeamCVE-2019-20218
13 known affected

The vendor explicitly identifies these products as affected by this CVE.

  • sqlite3 as component of SUSE Linux Enterprise Server 11 SP1 for Teradata
  • SLES 15 SP1 CHOST Images for Amazon EC2
  • SLES 15 SP2 CHOST Images for Amazon EC2
  • SLES 15 SP4 CHOST Images for Amazon EC2
  • SLES 15 SP5 CHOST Images for Amazon EC2
  • SLES 15 SP1 CHOST Images for Google
  • SLES 15 SP2 CHOST Images for Google
  • SLES 15 SP4 CHOST Images for Google
  • SLES 15 SP5 CHOST Images for Google
  • SLES 15 SP1 CHOST Images for Microsoft Azure
  • SLES 15 SP2 CHOST Images for Microsoft Azure
  • SLES 15 SP4 CHOST Images for Microsoft Azure
Summary
selectExpander in select.c in SQLite 3.30.1 proceeds with WITH stack unwinding even after a parsing error.
Remediation
To install this SUSE Security Update use the SUSE recommended installation methods like YaST online_update or "zypper patch".
Optional official sources

National CERT insights
?CERT means Computer Emergency Response Team; CSIRT is the closely related term Computer Security Incident Response Team.

Choose official national sources for this report. Each advisory shows its original language. Your selection is remembered on this device and included in shared links.

Official European source

ENISA European Vulnerability Database

Official EUVD identifiers, advisory evidence and known-exploited context. Missing fields are not treated as evidence of low risk.

1 current
ENISA EUVD identifier

EUVD-2019-10772

No EUVD known-exploited evidence

selectExpander in select.c in SQLite 3.30.1 proceeds with WITH stack unwinding even after a parsing error.

EUVD state
Present in the current official mapping
Known exploitation
Not present in the current ENISA EUVD known-exploited dataset. This is not proof of no exploitation.
ENISA score
0.0
Advisory evidence
No linked advisory details stored yet
Recommended actionPatch only the product branches with a verified fix

High technical severity; prioritise exposed affected systems while verifying vendor guidance. Verified remediation exists for at least one product or source, but 5 structured product or package states remain unresolved. Apply remediation only to the exact product branch confirmed by its source.

Fix availability varies by product
01

What, why and how

selectExpander in select.c in SQLite 3.30.1 proceeds with WITH stack unwinding even after a parsing error.

What

selectExpander in select.c in SQLite 3.30.1 proceeds with WITH stack unwinding even after a parsing error.

Why

The product does not handle or incorrectly handles an exceptional condition.

How

An attacker operating through a network path may attempt exploitation without authentication or user interaction. If successful, the issue may cause the confidentiality, integrity or availability impact described by the vendor.

What

selectExpander in select.c in SQLite 3.30.1 proceeds with WITH stack unwinding even after a parsing error.

Why

The product does not handle or incorrectly handles an exceptional condition.

How

An attacker operating through a network path may attempt exploitation without authentication or user interaction. If successful, the issue may cause the confidentiality, integrity or availability impact described by the vendor.

02

Exploit reality and attack path

CVSS severity, EPSS forecast probability, public exploit material and CISA-confirmed exploitation are separate signals.

Observed exploitation
?Confirmed exploitation and public exploit material are separate signals. Attacks can occur without public proof-of-concept or exploit code.
No confirmed evidence

No CISA KEV match was present at the last successful refresh. This means no confirmation from that source, not proof of no exploitation.

Public PoC / exploit material
?Confirmed exploitation and public exploit material are separate signals. Attacks can occur without public proof-of-concept or exploit code.
None recorded

No exploit-tagged reference or CISA SSVC proof-of-concept state is currently recorded. Research may still exist outside the structured feeds.

Likely attack path
a network path → Improper Handling of Exceptional Conditions → cause the confidentiality, integrity or availability impact described by the vendor
Attack surface
Network
Privileges required
None: unauthenticated exploitation is possible
User interaction
None
Attack complexity
Low: no specialised conditions are recorded
Security boundary
Unchanged: impact remains within the vulnerable component's security authority
Weakness
?CWE means Common Weakness Enumeration: a standard category for the underlying weakness.
CWE-755 ↗

CWE-755: Improper Handling of Exceptional Conditions. The product does not handle or incorrectly handles an exceptional condition.

CVSS vector
?CVSS means Common Vulnerability Scoring System. The vector records the metric values used to calculate technical severity.
CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H

Common Vulnerability Scoring System 3.1: the compact vector below is decoded into plain language.

AVNetworkAttack vector: The vulnerable component can be reached over a network.ACLowAttack complexity: No specialised conditions are required beyond attacker-controlled input.PRNonePrivileges required: The attacker does not need an account or existing privileges.UINoneUser interaction: No action by another user is required.SUnchangedScope: The security impact remains within the vulnerable component's authority.CNoneConfidentiality impact: No direct loss is represented by this metric.INoneIntegrity impact: No direct loss is represented by this metric.AHighAvailability impact: A successful attack can cause a major loss.
Post-exploitation / living off the land
No specific living-off-the-land technique is confirmed in the structured sources. Monitor normal administration tools for activity inconsistent with the affected service's baseline.
NetworkUnauthenticatedCWE-755
A

Official authority intelligence

Only matched European and national findings are included. Language selectors and unavailable sources are omitted.

ENISA EUVD · EUVD-2019-10772Official EUVD mapping

selectExpander in select.c in SQLite 3.30.1 proceeds with WITH stack unwinding even after a parsing error.

Official EUVD record ↗
BSI · German · WID-SEC-2023-1614Tenable Security Nessus Network Monitor: Mehrere Schwachstellen

Ein entfernter, anonymer, authentisierter oder lokaler Angreifer kann mehrere Schwachstellen in Tenable Security Nessus Network Monitor ausnutzen, um beliebigen Code auszuführen, vertrauliche Informationen offenzulegen, einen Denial-of-Service-Zustand auszulösen und Daten zu manipulieren.

Official advisory ↗
BSI · German · WID-SEC-2023-1049Oracle MySQL: Mehrere Schwachstellen

Ein entfernter, anonymer oder authentisierter Angreifer kann mehrere Schwachstellen in Oracle MySQL ausnutzen, um die Verfügbarkeit, Vertraulichkeit und Integrität zu gefährden.

Official advisory ↗
CISA · English · ICSA-23-348-10Siemens SIMATIC S7-1500

selectExpander in select.c in SQLite 3.30.1 proceeds with WITH stack unwinding even after a parsing error.

Official advisory ↗
CERT-FR · French · CERTFR-2023-AVI-1015Multiples vulnérabilités dans les produits Siemens

d?id=CVE-2019-19646 Référence CVE CVE-2019-19880 https://www.cve.org/CVERecord?id=CVE-2019-19880 Référence CVE CVE-2019-19906 https://www.cve.org/CVERecord?id=CVE-2019-19906 Référence CVE CVE-2019-19923 https://www.cve.org/CVERecord?id=CVE-2019-19923 Référence CVE CVE-2019-19924 https://www.cve.org/CVERecord?id=CVE-2019-19924 Référence CVE CVE-2019-19925 https://www.cve.org/CVERecord?id=CVE-2019-19925 Référence CVE CVE-2019-19926 https://www.cve.org/CVERecord?id=CVE-2019-19926 Référence CVE CVE-2019-19956 https://www.cve.org/CVERecord?id=CVE-2019-19956 Référence CVE CVE-2019-19959 https://www.cve.org/CVERecord?id=CVE-2019-19959 Référence CVE CVE-2019-20218 https://www.cve.org/CVERecord?id=CVE-2019-20218 Référence CVE CVE-2019-20367 https://www.cve.org/CVERecord?id=CVE-2019-20367 Référence CVE CVE-2019-20388 https://www.cve.org/CVERecord?id=CVE-2019-20388 Référence CVE CVE-2019-20795 https://www.cve.org/CVERecord?id=CVE-2019-20795 Référence CVE CVE-2019-20907 https://www.cve.org/CVERecord?id=CVE-2019-20907 Référence CVE CVE-2019-25013 https://www.cve.org/CVERecord?id=CVE-2019-25013 Référence CVE CVE-2019-3855 https://www.cve.org/CVERecord?id=CVE-2019-3855 Référence CVE CVE-2019-3856 https://www.cve.org/CVERecord?id=CVE-2019-3856 Référence CVE CVE-2019-3857 https://www.cve.org/CVERecord?id=CVE-2

Official advisory ↗
CERT-FR · French · CERTFR-2023-AVI-0499Multiples vulnérabilités dans Tenable Nessus Network Monitor

d?id=CVE-2019-19645 Référence CVE CVE-2019-19646 https://www.cve.org/CVERecord?id=CVE-2019-19646 Référence CVE CVE-2019-19880 https://www.cve.org/CVERecord?id=CVE-2019-19880 Référence CVE CVE-2019-19923 https://www.cve.org/CVERecord?id=CVE-2019-19923 Référence CVE CVE-2019-19924 https://www.cve.org/CVERecord?id=CVE-2019-19924 Référence CVE CVE-2019-19925 https://www.cve.org/CVERecord?id=CVE-2019-19925 Référence CVE CVE-2019-19926 https://www.cve.org/CVERecord?id=CVE-2019-19926 Référence CVE CVE-2019-19956 https://www.cve.org/CVERecord?id=CVE-2019-19956 Référence CVE CVE-2019-19959 https://www.cve.org/CVERecord?id=CVE-2019-19959 Référence CVE CVE-2019-20218 https://www.cve.org/CVERecord?id=CVE-2019-20218 Référence CVE CVE-2019-20388 https://www.cve.org/CVERecord?id=CVE-2019-20388 Référence CVE CVE-2019-20838 https://www.cve.org/CVERecord?id=CVE-2019-20838 Référence CVE CVE-2019-5815 https://www.cve.org/CVERecord?id=CVE-2019-5815 Référence CVE CVE-2019-8457 https://www.cve.org/CVERecord?id=CVE-2019-8457 Référence CVE CVE-2019-9936 https://www.cve.org/CVERecord?id=CVE-2019-9936 Référence CVE CVE-2019-9937 https://www.cve.org/CVERecord?id=CVE-2019-9937 Référence CVE CVE-2020-11655 https://www.cve.org/CVERecord?id=CVE-2020-11655 Référence CVE CVE-2020-11656 https://www.cve.org/CVERecord?id=CVE-2020

Official advisory ↗
JVN iPedia · Japanese · JVNDB-2019-013464SQLite における例外的な状態の処理に関する脆弱性

SQLite には、例外的な状態の処理に関する脆弱性、および不特定の脆弱性が存在します。

Official advisory ↗
03

Patch and workaround

Operational remediation based on structured source evidence.

Status
?Patch availability is based on structured fixed-version fields and authoritative update references. If no fix is verified, check the vendor advisory before making a change.
Fix availability varies by product
Affected
Fixed
Action
Use the product-specific evidence above. Patch only products with a verified fixed release, and keep every affected or under-investigation state without a matching fix in the remediation queue.
Workaround
No verified workaround is recorded. If business-safe, reduce exposure to the affected interface and allow only trusted sources until authoritative guidance is available.
04

Evidence and provenance

Published 2 Jan 2020 · Last source change 14 Oct 2026, 07:57 UTC · CWE-755 · Improper Handling of Exceptional Conditions

CVE recordCVE.org · 5.2
CVSS sourceNIST NVD
EPSS source
?The date BlackTree first stored a score for this CVE from the daily FIRST EPSS feed.
FIRST · tracked since 2026-08-14
European sourceENISA EUVD · EUVD-2019-10772
Product sourceVendor CSAF · Red Hat Product Security
Remediation sourceVendor CSAF · Red Hat Product Security
CWE sourceNIST NVD
NVD statusNVD modified after enrichment

Core structured fields are present and their contributing authorities are shown above.

Material change intelligence

What changed after publication

View recent updates ↗
  1. Vendor guidanceAuthoritative vendor guidance changed: added remediation: github.com/a6c1a71cde082e09750465d5675699062922e387; removed patch: cert-portal.siemens.com/ssa-398330.html; removed remediation: cert-portal.siemens.com/ssa-398330.html.
    Before
    patch: cert-portal.siemens.com/ssa-398330.html · patch: github.com/a6c1a71cde082e09750465d5675699062922e387 · patch: oracle.com/cpuapr2020.html · 1 more references
    After
    patch: github.com/a6c1a71cde082e09750465d5675699062922e387 · patch: oracle.com/cpuapr2020.html · remediation: github.com/a6c1a71cde082e09750465d5675699062922e387
    github.com ↗
  2. Affected versionsThe structured affected or fixed version information changed.
    Before
    SIMATIC S7-1500 CPU 1518-4 PN/DP MFP: V3.1.0 < V3.1.5; SIMATIC S7-1500 CPU 1518F-4 PN/DP MFP: V3.1.0 < V3.1.5; SIPLUS S7-1500 CPU 1518-4 PN/DP MFP: V3.1.0 < V3.1.5 · Fixed: Update to V3.1.5 or later version
    After
    SIMATIC S7-1500 CPU 1518-4 PN/DP MFP: V3.1.0 < V3.1.5; SIMATIC S7-1500 CPU 1518F-4 PN/DP MFP: V3.1.0 < V3.1.5; SIPLUS S7-1500 CPU 1518-4 PN/DP MFP: V3.1.0 < V3.1.5 · Fixed: An authoritative update reference is available, but the fixed version is not recorded in the structured CVE fields. Check the linked vendor advisory for the applicable release.
    Other authority ↗
  3. Vendor guidanceAuthoritative vendor guidance changed: added remediation: github.com/a6c1a71cde082e09750465d5675699062922e387; removed remediation: cert-portal.siemens.com/ssa-398330.html.
    Before
    patch: github.com/a6c1a71cde082e09750465d5675699062922e387 · patch: oracle.com/cpuapr2020.html · remediation: cert-portal.siemens.com/ssa-398330.html
    After
    patch: github.com/a6c1a71cde082e09750465d5675699062922e387 · patch: oracle.com/cpuapr2020.html · remediation: github.com/a6c1a71cde082e09750465d5675699062922e387
    github.com ↗
  4. Affected versionsThe structured affected or fixed version information changed.
    Before
    n/a · Fixed: Update to V3.1.5 or later version
    After
    SIMATIC S7-1500 CPU 1518-4 PN/DP MFP: V3.1.0 < V3.1.5; SIMATIC S7-1500 CPU 1518F-4 PN/DP MFP: V3.1.0 < V3.1.5; SIPLUS S7-1500 CPU 1518-4 PN/DP MFP: V3.1.0 < V3.1.5 · Fixed: An authoritative update reference is available, but the fixed version is not recorded in the structured CVE fields. Check the linked vendor advisory for the applicable release.
    Other authority ↗
  5. Affected versionsThe structured affected or fixed version information changed.
    Before
    SIMATIC S7-1500 CPU 1518-4 PN/DP MFP: V3.1.0 < V3.1.5; SIMATIC S7-1500 CPU 1518F-4 PN/DP MFP: V3.1.0 < V3.1.5; SIPLUS S7-1500 CPU 1518-4 PN/DP MFP: V3.1.0 < V3.1.5 · Fixed: An authoritative update reference is available, but the fixed version is not recorded in the structured CVE fields. Check the linked vendor advisory for the applicable release.
    After
    SIMATIC S7-1500 CPU 1518-4 PN/DP MFP: V3.1.0 < V3.1.5; SIMATIC S7-1500 CPU 1518F-4 PN/DP MFP: V3.1.0 < V3.1.5; SIPLUS S7-1500 CPU 1518-4 PN/DP MFP: V3.1.0 < V3.1.5 · Fixed: Update to V3.1.5 or later version
    Siemens ProductCERT ↗
  6. Affected versionsThe structured affected or fixed version information changed.
    Before
    SIMATIC S7-1500 CPU 1518-4 PN/DP MFP (6ES7518-4AX00-1AB0); SIMATIC S7-1500 CPU 1518-4 PN/DP MFP (6ES7518-4AX00-1AC0); SIMATIC S7-1500 CPU 1518F-4 PN/DP MFP (6ES7518-4FX00-1AB0); SIMATIC S7-1500 CPU 1518F-4 PN/DP MFP (6ES7518-4FX00-1AC0); SIPLUS S7-1500 CPU 1518-4 PN/DP MFP (6AG1518-4AX00-4AC0)
    After
    SIMATIC S7-1500 CPU 1518-4 PN/DP MFP (6ES7518-4AX00-1AB0) >= V3.1.0 < V3.1.5; SIMATIC S7-1500 CPU 1518-4 PN/DP MFP (6ES7518-4AX00-1AC0) >= V3.1.0 < V3.1.5; SIMATIC S7-1500 CPU 1518F-4 PN/DP MFP (6ES7518-4FX00-1AB0) >= V3.1.0 < V3.1.5; SIMATIC S7-1500 CPU 1518F-4 PN/DP MFP (6ES7518-4FX00-1AC0) >= V3.1.0 < V3.1.5; SIPLUS S7-1500 CPU 1518-4 PN/DP MFP (6AG1518-4AX00-4AC0) >= V3.1.0 < V3.1.5
    Siemens ProductCERT ↗
  7. Affected versionsThe structured affected or fixed version information changed.
    Before
    n/a · Fixed: An authoritative update reference is available, but the fixed version is not recorded in the structured CVE fields. Check the linked vendor advisory for the applicable release.
    After
    n/a · Fixed: Update to V3.1.5 or later version
    Siemens ProductCERT ↗
Material fields only · duplicate refreshes suppressed · history retained for the configured operational retention period
Technical terms and abbreviations used in this report
CVE
Common Vulnerabilities and Exposures: the public identifier for one disclosed vulnerability.
CVSS
Common Vulnerability Scoring System: a technical severity framework; it is not patching priority by itself.
EPSS
Exploit Prediction Scoring System: FIRST's estimate of the probability that exploitation activity will be observed in the next 30 days; it is a forecast, not confirmation.
CWE
Common Weakness Enumeration: the standard category describing the underlying software or hardware weakness.
CNA
CVE Numbering Authority: an organisation authorised to assign and publish CVE records.
CISA ADP
Cybersecurity and Infrastructure Security Agency Authorized Data Publisher: structured enrichment added to a CVE record.
NVD
National Vulnerability Database: NIST's enrichment service for CVE records.
CERT / CSIRT
A computer security incident response team that publishes warnings or coordinates incident response.
PoC
Proof of concept: public material that demonstrates or helps reproduce exploitation.
CSAF
Common Security Advisory Framework: a machine-readable format for security advisories.
LoTL
Living off the land: abuse of legitimate tools or system functions during an attack.
Free version - for non-commercial use only.CVE-2019-20218 · cve.blacktree.nl