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).
Fix
Patch, vendor advisory and mitigation references on NVD 6
- https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf Patch, Third Party Advisory
- https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35 Patch
- https://www.oracle.com/security-alerts/cpuapr2020.html Patch, 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://www.oracle.com/security-alerts/cpuapr2020.html Patch, Third Party Advisory
Every line above is quoted from NVD, CISA, Microsoft, the vendor's own advisory or DISA; nothing is generated.
Change history 1
- First seenCVSS 7.5 · sqlite, siemens, oracleNVD modified 2026-10-14 08:16
Affected (CPE criteria) 12
cpe:2.3:a:sqlite:sqlite:3.30.1:*:*:*:*:*:*:*cpe:2.3:a:siemens:sinec_infrastructure_network_services:*:*:*:*:*:*:*:*cpe:2.3:a:oracle:mysql_workbench:*:*:*:*:*:*:*:*cpe:2.3:o:debian:debian_linux:9.0:*:*:*:*:*:*:*cpe:2.3:o:debian:debian_linux:10.0:*:*:*:*:*:*:*cpe:2.3:o:redhat:enterprise_linux_desktop:6.0:*:*:*:*:*:*:*cpe:2.3:o:redhat:enterprise_linux_server:6.0:*:*:*:*:*:*:*cpe:2.3:o:redhat:enterprise_linux_workstation:6.0:*:*:*:*:*:*:*cpe:2.3:a:suse:package_hub:-:*:*:*:*:*:*:*cpe:2.3:a:opensuse:backports_sle:15.0:sp1:*:*:*:*:*:*cpe:2.3:o:opensuse:leap:15.1:*:*:*:*:*:*:*cpe:2.3:a:netapp:cloud_backup:-:*:*:*:*:*:*:*
References 22
- 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
- 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
- https://cert-portal.siemens.com/productcert/html/ssa-389290.html
- https://cert-portal.siemens.com/productcert/html/ssa-398330.html