Vulnerabilities · 2019 · Sqlite
CVE-2019-19923
Sqlite vulnerability
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).
Affected products
Sqlite, Sinec Infrastructure Network Services, Mysql Workbench, Debian Linux, Enterprise Linux Desktop, Enterprise Linux Server, Enterprise Linux Workstation, Package Hub, Backports Sle, Leap and more. The exact versions are in the references.
What to do now
- Check your exposureFind out whether Sqlite runs anywhere in your environment, including systems of suppliers.
- UpdateInstall the version in which the vendor fixed the vulnerability. The references lead to the advisory.
- Limit access until thenIf you cannot update at once, take the system off the internet or restrict who can reach it.
References
- cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf · Patch
- github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35 · Patch
- www.oracle.com/security-alerts/cpuapr2020.html · Patch
- lists.opensuse.org/opensuse-security-announce/2020-02/msg00010.html · Third Party Advisory
- lists.opensuse.org/opensuse-security-announce/2020-02/msg00015.html · Third Party Advisory
- lists.opensuse.org/opensuse-security-announce/2020-02/msg00025.html · Third Party Advisory
- access.redhat.com/errata/RHSA-2020:0514 · Third Party Advisory
- security.netapp.com/advisory/ntap-20200114-0003/ · Third Party Advisory
- nvd.nist.gov/vuln/detail/CVE-2019-19923
- cve.org/CVERecord?id=CVE-2019-19923
More vulnerabilities in Sqlite products
CVE-2025-29088CVE-2025-29087CVE-2025-7458CVE-2025-6965CVE-2025-3277CVE-2024-0232CVE-2023-7104CVE-2022-46908All 62
Data: CVE list and the NVD. This product uses data from the NVD API but is not endorsed or certified by the NVD.