CVE-2019-19923 — flattenSubquery in select.c in SQLite 3.30.1 mishandles certain uses of SELECT DISTINCT involving...
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).
Who exploits it and how urgent it is
A 0–100 score combining confirmed exploitation, ransomware and APT use, public exploits, EPSS and severity.
How the score was calculated
- EPSS 6.8% (30-day exploitation probability)+14
- Technical severity (high)+6
The score orders the patch queue; it does not replace your asset context (internet exposure, criticality, compensating controls).
Triage
Is it exploited, how likely is exploitation, what does it touch, and how severe do the sources call it.
Remediation
Fixes and mitigations documented by the sources — linked to the original advisory.
- Documented patch — cert-portal.siemens.com (NIST National Vulnerability Database)
- Documented patch — github.com (NIST National Vulnerability Database)
- Documented patch — www.oracle.com (NIST National Vulnerability Database)
First 24 hours
Ordered from the record’s own fields — exposure first, because you cannot patch what you have not found. A rule-generated starting point.
- Identify exposed assets running the affected vendor/product/version combinations (Debian Debian Linux, Netapp Cloud Backup, Opensuse Backports Sle…).
- The attack is network-based and needs no privileges: restrict exposure (ACLs, VPN, WAF) until patched.
- Apply the fixed version or the patch documented under Remediation.
- EPSS ahead of 94% of scored CVEs: prioritize it in the patch queue.
- Search available logs for exploit probes matching the vulnerability class (memory corruption), errors and authentication anomalies.
Affected scope
Vendor, product and versions as the sources word them.
| Vendor | Product | Versions | Status | Source |
|---|---|---|---|---|
| Debian | Debian Linux | version 9.0version 10.0 | Vulnerable | NIST National Vulnerability Database |
| Netapp | Cloud Backup | versions not specified by the source | Vulnerable | NIST National Vulnerability Database |
| Opensuse | Backports Sle | version 15.0-sp1 | Vulnerable | NIST National Vulnerability Database |
| Opensuse | Leap | version 15.1 | Vulnerable | NIST National Vulnerability Database |
| Oracle | Mysql Workbench | ≤ 8.0.19 | Vulnerable | NIST National Vulnerability Database |
| Red Hat | Enterprise Linux Desktop | version 6.0 | Vulnerable | NIST National Vulnerability Database |
| Red Hat | Enterprise Linux Server | version 6.0 | Vulnerable | NIST National Vulnerability Database |
| Red Hat | Enterprise Linux Workstation | version 6.0 | Vulnerable | NIST National Vulnerability Database |
| Siemens | Sinec Infrastructure Network Services | < 1.0.1.1 | Vulnerable | NIST National Vulnerability Database |
| Sqlite | Sqlite | version 3.30.1 | Vulnerable | NIST National Vulnerability Database |
| SUSE | Package Hub | versions not specified by the source | Vulnerable | NIST National Vulnerability Database |
Attack characteristics
The CVSS vector, decoded. It describes the attack, not your exposure to it.
Every base score collected
Sources score independently and may disagree; each row says who scored it and under which version.
| Score | Version | Severity | Expl. | Impact | Scored by |
|---|---|---|---|---|---|
| 7.5 | CVSS 3.1 | High | 3.9 | 3.6 | nvd@nist.gov via NIST National Vulnerability Database |
| 7.5 | CVSS 3.1 | High | — | — | GitHub, Inc. via GitHub Security Advisories |
| 5.0 | CVSS 2.0 | Medium | 10.0 | 2.9 | nvd@nist.gov via NIST National Vulnerability Database |
CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H (score shown at the top: nvd@nist.gov) Weakness MITRE
Weakness class according to MITRE’s CWE catalog.
EPSS over time FIRST
Oct 13, 2026 → Oct 14, 2026 · 2 reading(s) · max 6.81%
Detection
Read off the CVSS vector and the weakness class. Starting points, not tested rules.
- Prioritize edge telemetry for the network-reachable component (proxy, WAF, IDS/IPS).
- Correlate service crashes/restarts with inbound traffic; repeated crashes may indicate attempts.
Timeline
What happened to this CVE, newest first.
- 2026
- Record published
- Fix documented
- Affected products added · sqlite/sqlite, siemens/sinec infrastructure network services, oracle/mysql workbench, debian/debian linux, redhat/enterp
- CVSS changed · 7.5
- Source status changed · → Modified
- Record created in this database
- 2019
- CVE published
Source activity
Repeated readings are counted rather than listed.
- 2× References added · Oct 14, 2026 – Oct 14, 2026
- 1× Official description updated · Oct 14, 2026 – Oct 14, 2026
References
14 on the record
- github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35
- cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf
- www.oracle.com/security-alerts/cpuapr2020.html
- lists.opensuse.org/opensuse-security-announce/2020-02/msg00015.html
- github.com/advisories/GHSA-5gmx-grg5-hh7x
- www.debian.org/security/2020/dsa-4638
- cert-portal.siemens.com/productcert/html/ssa-389290.html
- cert-portal.siemens.com/productcert/html/ssa-398330.html
- access.redhat.com/errata/RHSA-2020:0514
- security.netapp.com/advisory/ntap-20200114-0003/
- nvd.nist.gov/vuln/detail/CVE-2019-19923
- lists.opensuse.org/opensuse-security-announce/2020-02/msg00010.html
- lists.opensuse.org/opensuse-security-announce/2020-02/msg00025.html
- usn.ubuntu.com/4298-1/
Elsewhere on this site
Related CVEs (same products)
- High CVE-2026-12996 A use-after-free in OpenVPN 2.6.0 through 2.6.20 and 2.7_alpha1 through 2.7.4 allows remote... Jul 30, 2026
- Medium CVE-2026-56968 Use of Uninitialized Resource in Gnu Sasl Jun 23, 2026
- High CVE-2026-11824 SQLite before 3.53.2 Heap Buffer Overflow via FTS5 fts5ChunkIterate Jun 9, 2026
- High CVE-2026-11822 SQLite before 3.53.2 Memory Corruption in FTS5 Extension Jun 9, 2026
- High CVE-2026-49975 Apache HTTP Server: mod_http2 denial of service Jun 8, 2026
- High CVE-2026-9256 NGINX ngx_http_rewrite_module vulnerability May 22, 2026
Not in any source we poll
Listed rather than left blank: an empty field and an unmeasured one look identical on screen, and only one is a reason to look elsewhere.
- No CISA SSVC assessment.
- No confirmed IOCs, IP addresses, domains, file hashes, or malware artifacts supplied.
- No organization-specific asset inventory, compensating-control status, or patch deployment evidence supplied.
- No exploit packet captures, log samples, or incident case IDs supplied.
Answered from this record
Text assembled only from the fields above — no additional claims.
What should defenders know first?
CVE-2019-19923 is "flattenSubquery in select.c in SQLite 3.30.1 mishandles certain uses of SELECT DISTINCT involving...", rated High. It affects Debian Linux (Debian); versions are in the scope table. It is not in CISA KEV, which does not rule out exploitation. CVSS 7.5 describes technical severity. EPSS 6.81% estimates the probability of exploitation in 30 days; neither replaces your asset context. First verify whether exposed or business-critical assets run the affected versions, apply vendor fixes or mitigations, and preserve logs for review.
Comments
Moderated technical discussion. Read the community guidelines.
No comments yet.
Sign in or create an account to comment and suggest corrections.