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).
CVSS breakdown
CVSS 3.1
Attack Vector
Network
Attack Complexity
Low
Privileges Required
None
User Interaction
None
Scope
Unchanged
Confidentiality
None
Integrity
None
Availability
High
Affected products
- Debian / debian_linux9.0 – 9.0
- Debian / debian_linux10.0 – 10.0
- NetApp / cloud_backup
- openSUSE / backports_sle15.0 – 15.0
- openSUSE / Leap15.1 – 15.1
- oracle / mysql_workbench8.0.19
- RedHat / enterprise_linux_desktop6.0 – 6.0
- RedHat / enterprise_linux_server6.0 – 6.0
- RedHat / enterprise_linux_workstation6.0 – 6.0
- Siemens / sinec_infrastructure_network_services1.0.1.1
- SQLite / SQLite3.30.1 – 3.30.1
- SUSE / package_hub
References
- PATCHhttps://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35
- MISChttps://security.netapp.com/advisory/ntap-20200114-0003/
- MAILING_LISThttp://lists.opensuse.org/opensuse-security-announce/2020-02/msg00010.html
- MAILING_LISThttp://lists.opensuse.org/opensuse-security-announce/2020-02/msg00015.html
- VENDOR_ADVISORYhttps://access.redhat.com/errata/RHSA-2020:0514
- MAILING_LISThttp://lists.opensuse.org/opensuse-security-announce/2020-02/msg00025.html
- VENDOR_ADVISORYhttps://www.debian.org/security/2020/dsa-4638
- VENDOR_ADVISORYhttps://usn.ubuntu.com/4298-1/
- VENDOR_ADVISORYhttps://www.oracle.com/security-alerts/cpuapr2020.html
- MISChttps://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf
Updated 15m ago · 8 sources