CVE-2019-19923
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).
- Score
- CVSS 3.1 7.5 High
- Status
- Modified - cve@mitre.org
- Published
- 2019-12-24
- Last modified
- 2026-10-14
- Weaknesses
- CWE-476
Affected products
- Debian Linux (Debian)
- Cloud Backup (Netapp)
- Backports Sle (Opensuse)
- Leap (Opensuse)
- Mysql Workbench (Oracle)
- Enterprise Linux Desktop (Redhat)
- Enterprise Linux Server (Redhat)
- Enterprise Linux Workstation (Redhat)
- Simatic S7-1500 Cpu 1518-4 Pndp Mfp (Siemens)
- Simatic S7-1500 Cpu 1518f-4 Pndp Mfp (Siemens)
- Sinec Infrastructure Network Services (Siemens)
- Siplus S7-1500 Cpu 1518-4 Pndp Mfp (Siemens)
- Sqlite (Sqlite)
- Package Hub (Suse)
References
- https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35
- https://security.netapp.com/advisory/ntap-20200114-0003/
- http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00010.html
- http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00015.html
- https://access.redhat.com/errata/RHSA-2020:0514
- http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00025.html
- https://www.debian.org/security/2020/dsa-4638
- https://usn.ubuntu.com/4298-1/
- https://www.oracle.com/security-alerts/cpuapr2020.html
- https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf
- https://cert-portal.siemens.com/productcert/html/ssa-389290.html
- https://cert-portal.siemens.com/productcert/html/ssa-398330.html
