CVE-2019-19923
HIGH severity · CVSS 7.5 · CWE-476
7.5CVSS HIGH
Summary
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).
Impact & exploitability
Attack vectorNetwork
Attack complexityLow
Privileges requiredNone
User interactionNone
Confidentiality impactNone
Integrity impactNone
Availability impactHigh
Exploit probability (EPSS)7%
CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H
Recommendation
Apply the vendor fix promptly. Open any affected product above for its exact safe version.
Official patch: https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf ↗
Additional information
- NVD record
- https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdfPatch
- https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35Patch
- http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00010.htmlAdvisory
- http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00015.htmlAdvisory
- http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00025.htmlAdvisory
- https://access.redhat.com/errata/RHSA-2020:0514Advisory
- https://security.netapp.com/advisory/ntap-20200114-0003/Advisory
- https://usn.ubuntu.com/4298-1/