First published: Tue Dec 24 2019(Updated: )
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).
Credit: cve@mitre.org cve@mitre.org
Affected Software | Affected Version | How to fix |
---|---|---|
SQLite SQLite | =3.30.1 | |
Siemens Sinec Infrastructure Network Services | <1.0.1.1 | |
Oracle Mysql Workbench | <=8.0.19 | |
Debian Debian Linux | =9.0 | |
Debian Debian Linux | =10.0 | |
Redhat Enterprise Linux Desktop | =6.0 | |
Redhat Enterprise Linux Server | =6.0 | |
Redhat Enterprise Linux Workstation | =6.0 | |
Suse Package Hub | ||
SUSE Linux Enterprise | =12.0 | |
openSUSE Backports SLE | =15.0-sp1 | |
openSUSE Leap | =15.1 | |
Netapp Cloud Backup | ||
All of | ||
Suse Package Hub | ||
SUSE Linux Enterprise | =12.0 | |
IBM Data Risk Manager | <=2.0.6 | |
debian/chromium | 120.0.6099.224-1~deb11u1 128.0.6613.84-1~deb12u1 129.0.6668.100-1~deb12u1 129.0.6668.89-1 129.0.6668.100-2 | |
debian/sqlite3 | 3.34.1-3 3.34.1-3+deb11u1 3.40.1-2 3.46.0-1 3.46.1-1 |
Sign up to SecAlerts for real-time vulnerability data matched to your software, aggregated from hundreds of sources.
CVE-2019-19923 is a vulnerability in SQLite that allows a remote attacker to cause a denial of service.
CVE-2019-19923 affects SQLite by causing a NULL pointer dereference flaw in the flattenSubquery function in select.c.
CVE-2019-19923 has a severity rating of high, with a CVSS score of 7.5.
The affected software versions of CVE-2019-19923 include IBM Data Risk Manager 2.0.6, sqlite3 3.22.0-1ubuntu0.3, and sqlite3 3.29.0-2ubuntu0.2.
To fix CVE-2019-19923, you can apply the patch provided by IBM for Data Risk Manager or update to a fixed version of sqlite3.