CVE-2019-19923

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

Category

7.5
CVSS
Severity: High
CVSS 3.1 •
CVSS 2.0 •
EPSS 13.88% Top 10%
Vendor Advisory opensuse.org Vendor Advisory opensuse.org Vendor Advisory redhat.com Vendor Advisory opensuse.org Vendor Advisory debian.org Vendor Advisory ubuntu.com
Affected: n/a n/a
Published at:
Updated at:

References

Link Tags
https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35 patch
https://security.netapp.com/advisory/ntap-20200114-0003/ third party advisory
http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00010.html mailing list third party advisory vendor advisory
http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00015.html mailing list third party advisory vendor advisory
https://access.redhat.com/errata/RHSA-2020:0514 third party advisory vendor advisory
http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00025.html mailing list third party advisory vendor advisory
https://www.debian.org/security/2020/dsa-4638 third party advisory vendor advisory
https://usn.ubuntu.com/4298-1/ vendor advisory broken link
https://www.oracle.com/security-alerts/cpuapr2020.html third party advisory patch
https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf third party advisory patch

Frequently Asked Questions

What is the severity of CVE-2019-19923?
CVE-2019-19923 has been scored as a high severity vulnerability.
How to fix CVE-2019-19923?
To fix CVE-2019-19923, make sure you are using an up-to-date version of the affected component(s) by checking the vendor release notes. As for now, there are no other specific guidelines available.
Is CVE-2019-19923 being actively exploited in the wild?
It is possible that CVE-2019-19923 is being exploited or will be exploited in a near future based on public information. According to its EPSS score, there is a ~14% probability that this vulnerability will be exploited by malicious actors in the next 30 days.
This platform uses data from the NIST NVD, MITRE CVE, MITRE CWE, First.org and CISA KEV but is not endorsed or certified by these entities. CVE is a registred trademark of the MITRE Corporation and the authoritative source of CVE content is MITRE's CVE web site. CWE is a registred trademark of the MITRE Corporation and the authoritative source of CWE content is MITRE's CWE web site.
© 2025 Under My Watch. All Rights Reserved.