CVE-2019-19923

Name: CVE-2019-19923
Creator: NVD / NIST
Published: 2019-12-24T16:15:11.26+00:00
License: https://creativecommons.org/publicdomain/zero/1.0/

HIGHCVSS 7.5/10EPSS 6.81%

Last modified Jun 17, 2026

CVE-2019-19923 is a high-severity vulnerability rated 7.5/10 on the CVSS scale. 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).. EPSS estimates a 6.81% chance of exploitation in the next 30 days.

Description

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

Metrics

CVSS 3.1

7.5/10

CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H

EPSS Probability

6.81%

93.2th percentile

Probability of exploitation in the next 30 days. Learn more

Weakness Enumeration

CWE-476

Affected Software

Vendor	Product	Versions	Update
Sqlite	Sqlite	3.30.1	—
Siemens	Sinec Infrastructure Network Services	< 1.0.1.1	—
Oracle	Mysql Workbench	<= 8.0.19	—
Debian	Debian Linux	9.0	—
Debian	Debian Linux	10.0	—
Redhat	Enterprise Linux Desktop	6.0	—
Redhat	Enterprise Linux Server	6.0	—
Redhat	Enterprise Linux Workstation	6.0	—
Suse	Package Hub	All versions	—
Opensuse	Backports Sle	15.0	Sp1
Opensuse	Leap	15.1	—
Netapp	Cloud Backup	All versions	—

References

http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00010.htmlMailing List, Third Party Advisory
http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00015.htmlMailing List, Third Party Advisory
http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00025.htmlMailing List, Third Party Advisory
https://access.redhat.com/errata/RHSA-2020:0514Third Party Advisory
https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdfPatch, Third Party Advisory
https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35Patch
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-4638Third Party Advisory
https://www.oracle.com/security-alerts/cpuapr2020.htmlPatch, Third Party Advisory
http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00010.htmlMailing List, Third Party Advisory
http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00015.htmlMailing List, Third Party Advisory
http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00025.htmlMailing List, Third Party Advisory
https://access.redhat.com/errata/RHSA-2020:0514Third Party Advisory
https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdfPatch, Third Party Advisory
https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35Patch
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-4638Third Party Advisory
https://www.oracle.com/security-alerts/cpuapr2020.htmlPatch, Third Party Advisory

Timeline

Published: Dec 24, 2019
Last Modified: Jun 17, 2026
Status: Modified

Frequently Asked Questions

What is CVE-2019-19923?

How severe is CVE-2019-19923?

CVE-2019-19923 has a CVSS score of 7.5/10 (HIGH severity). The EPSS model estimates a 6.81% probability of exploitation in the next 30 days.

How do I fix CVE-2019-19923?

Check the vendor references and advisories linked above for patched versions and mitigation guidance. You can also run a Strix scan to test if your systems are affected.

Are you affected by CVE-2019-19923?

Run a free Strix scan to check your systems for this vulnerability.

Scan your code now

Source: NVD / NIST