CVE-2019-19923

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

Published: 2019-12-24 Last update: 2026-06-16 Assigner: [email protected] Source: [email protected]
NVD Status：Modified，CVE State: published
View at NVD, CVE.org, EUVD

CVE-2019-19923 is rated Moderate Risk (63.2/100): CVSS High severity, with high exploitation likelihood (EPSS 6.81%, 93th percentile). EPSS ranks this CVE among the most likely to be exploited in the near term. High exploitation likelihood—assess exposure and prioritize remediation.

Risk is dynamic; we continuously reassess and refresh what is shown on this page as upstream context changes.

Exploit prediction scoring system (EPSS) score for CVE-2019-19923

EPSS lead: Daily EPSS estimates relative likelihood of exploitation; percentile ranks this CVE among scored vulnerabilities (higher = more severe relative rank).

# Date Old EPSS score New EPSS score Delta (New - Old)
1 2026-06-15 6.20% 6.81% +0.61%
2 2026-03-04 0.78% 6.20% +5.42%
3 2026-03-01 — 0.78% —

Full EPSS history (42 records total)

Common vulnerability scoring system (CVSS) metrics for CVE-2019-19923

CVSS metrics for this CVE.

Base score Version Severity Vector Exploitability Impact Score source
7.5 3.1 HIGH
CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H Click to expand
Attack vector (AV:N)
Could be attacked over the internet or any normal routed network—not just someone sitting at the machine.
Attack complexity (AC:L)
Once they can reach the bug, pulling it off is straightforward—no weird race conditions or rare setup.
Privileges required (PR:N)
No account or special rights needed—anonymous or random user is enough.
User interaction (UI:N)
Nobody has to click “OK” or open a trap file; it can work without a victim helping.
Scope (S:U)
Damage stays in the same “trust bubble” as the broken component—no big spill into unrelated systems.
Confidentiality (C:N)
Doesn’t really leak secrets in a meaningful way.
Integrity (I:N)
Data isn’t meaningfully altered or forged.
Availability (A:H)
Could take the service down hard or make it unusable for people who depend on it.
 3.9 3.6 [email protected]
5.0 2.0 MEDIUM
AV:N/AC:L/Au:N/C:N/I:N/A:P Click to expand
Access vector (AV:N)
Can be exploited remotely over network reachability.
Access complexity (AC:L)
Exploitation conditions are straightforward and predictable.
Authentication (AU:N)
No authentication is required.
Confidentiality impact (C:N)
No confidentiality impact.
Integrity impact (I:N)
No integrity impact.
Availability impact (A:P)
Partial availability impact.
 10.0 2.9 [email protected]

Weakness enumeration for CVE-2019-19923

OS Trackers for CVE-2019-19923

vendor priority summary link
alpine high CVE-2019-19923: 1 source package rows (sqlite); 11 state rows across 6 repos (3.11-main, 3.19-main, 3.20-main, 3.21-main, 3.22-main, edge-main); fixed 0, open 11. https://security.alpinelinux.org/vuln/CVE-2019-19923
debian not yet assigned CVE-2019-19923 not yet assigned priority: Debian including 2 source packages (chromium, sqlite3), 10 status rows across 5 suites (bookworm, bullseye, forky, sid, trixie): resolved 10. https://security-tracker.debian.org/tracker/CVE-2019-19923
redhat medium — https://access.redhat.com/security/cve/CVE-2019-19923
suse medium CVE-2019-19923 severity moderate: SUSE including 409 source package names (0.1.0:libsqlite3-0-3.36.0-3.12.1, 0.1.75:libsqlite3-0-3.36.0-3.12.1, …), 1145 product×package rows across 569 product lines (Container bci/bci-init, Container bci/bci-sle15-kernel-module-devel, … (569 product lines)): Fixed 860, Known Not Affected 149, Known Affected 136. https://www.suse.com/security/cve/CVE-2019-19923/
ubuntu medium CVE-2019-19923 medium priority: Ubuntu including 1 source packages (sqlite3), 6 status rows across 6 suites (bionic, disco, eoan, trusty, upstream, xenial): released 3, not-affected 2, ignored 1. https://ubuntu.com/security/CVE-2019-19923

Affected software / configurations for CVE-2019-19923

Vendor Product Version Raw CPE
sqlite sqlite 3.30.1 cpe:2.3:a:sqlite:sqlite:3.30.1:*:*:*:*:*:*:*
siemens sinec_infrastructure_network_services < 1.0.1.1 cpe:2.3:a:siemens:sinec_infrastructure_network_services:*:*:*:*:*:*:*:*
oracle mysql_workbench <= 8.0.19 cpe:2.3:a:oracle:mysql_workbench:*:*:*:*:*:*:*:*
debian debian_linux 9.0 cpe:2.3:o:debian:debian_linux:9.0:*:*:*:*:*:*:*
debian debian_linux 10.0 cpe:2.3:o:debian:debian_linux:10.0:*:*:*:*:*:*:*
redhat enterprise_linux_desktop 6.0 cpe:2.3:o:redhat:enterprise_linux_desktop:6.0:*:*:*:*:*:*:*
redhat enterprise_linux_server 6.0 cpe:2.3:o:redhat:enterprise_linux_server:6.0:*:*:*:*:*:*:*
redhat enterprise_linux_workstation 6.0 cpe:2.3:o:redhat:enterprise_linux_workstation:6.0:*:*:*:*:*:*:*
suse package_hub — cpe:2.3:a:suse:package_hub:-:*:*:*:*:*:*:*
opensuse backports_sle 15.0 cpe:2.3:a:opensuse:backports_sle:15.0:sp1:*:*:*:*:*:*
opensuse leap 15.1 cpe:2.3:o:opensuse:leap:15.1:*:*:*:*:*:*:*
netapp cloud_backup — cpe:2.3:a:netapp:cloud_backup:-:*:*:*:*:*:*:*

References for CVE-2019-19923

URL Tags
http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00010.html Mailing List Third Party Advisory
http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00015.html Mailing List Third Party Advisory
http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00025.html Mailing List Third Party Advisory
https://access.redhat.com/errata/RHSA-2020:0514 Third Party Advisory
https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf Patch Third Party Advisory
https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35 Patch
https://security.netapp.com/advisory/ntap-20200114-0003/ Third Party Advisory
https://usn.ubuntu.com/4298-1/ Broken Link
https://www.debian.org/security/2020/dsa-4638 Third Party Advisory
https://www.oracle.com/security-alerts/cpuapr2020.html Patch Third Party Advisory
cvelogic Threat Intelligence