CVE-2019-19923: SQL Injection
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 |
|---|---|---|
| IBM Data Risk Manager | <=2.0.6 | |
| 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 | |
| ubuntu/sqlite3 | <3.22.0-1ubuntu0.3 | 3.22.0-1ubuntu0.3 |
| ubuntu/sqlite3 | <3.29.0-2ubuntu0.2 | 3.29.0-2ubuntu0.2 |
| ubuntu/sqlite3 | <3.30.1+ | 3.30.1+ |
| debian/chromium | 90.0.4430.212-1~deb10u1 120.0.6099.224-1~deb11u1 121.0.6167.139-1~deb12u1 124.0.6367.118-1~deb12u1 124.0.6367.118-1 | |
| debian/sqlite | 2.8.17-15 2.8.17-15+deb10u1 | |
| debian/sqlite3 | 3.27.2-3+deb10u1 3.27.2-3+deb10u2 3.34.1-3 3.40.1-2 3.45.3-1 |
Never miss a vulnerability like this again
Sign up to SecAlerts for real-time vulnerability data matched to your software, aggregated from hundreds of sources.
Reference Links
- https://exchange.xforce.ibmcloud.com/vulnerabilities/173490
- https://www.ibm.com/support/pages/node/6335281 (Advisory)
- http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00010.html
- http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00015.html
- http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00025.html
- https://access.redhat.com/errata/RHSA-2020:0514
- https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf
- https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35
- https://security.netapp.com/advisory/ntap-20200114-0003/
- https://usn.ubuntu.com/4298-1/
- https://www.debian.org/security/2020/dsa-4638
- https://www.oracle.com/security-alerts/cpuapr2020.html
- https://launchpad.net/bugs/cve/CVE-2019-19923
- https://bugzilla.redhat.com/show_bug.cgi/show_bug.cgi?id=1788847
- https://bugzilla.redhat.com/show_bug.cgi/show_bug.cgi?id=1789799
- https://access.redhat.com/security/cve/cve-2019-19923
- https://access.redhat.com/errata/RHSA-2020:1810
- https://bugzilla.redhat.com/show_bug.cgi?id=1788846
- https://security-tracker.debian.org/tracker/CVE-2019-19923
- https://ubuntu.com/security/notices/USN-4298-1
- https://www.cve.org/CVERecord?id=CVE-2019-19923
- https://nvd.nist.gov/vuln/detail/CVE-2019-19923
- https://ubuntu.com/security/CVE-2019-19923
Frequently Asked Questions
What is CVE-2019-19923?
CVE-2019-19923 is a vulnerability in SQLite that allows a remote attacker to cause a denial of service.
How does CVE-2019-19923 impact SQLite?
CVE-2019-19923 affects SQLite by causing a NULL pointer dereference flaw in the flattenSubquery function in select.c.
What is the severity of CVE-2019-19923?
CVE-2019-19923 has a severity rating of high, with a CVSS score of 7.5.
Which software versions are affected by CVE-2019-19923?
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.
How can I fix CVE-2019-19923?
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.
- collector/ibm-support
- collector/nvd-index
- agent/type
- agent/weakness
- agent/last-modified-date
- agent/first-publish-date
- collector/launchpad-cve
- source/Launchpad
- collector/redhat-bugzilla
- source/Red Hat
- alias/CVE-2019-19923
- agent/author
- agent/severity
- agent/references
- agent/remedy
- agent/description
- collector/nvd-cve
- source/NVD
- agent/software-canonical-lookup
- agent/tags
- agent/event
- collector/security-tracker-debian
- source/Debian
- agent/softwarecombine
- collector/usn-cve
- source/Ubuntu
- vendor/ibm
- canonical/ibm data risk manager
- version/ibm data risk manager/2.0.6
- vendor/sqlite
- canonical/sqlite sqlite
- version/sqlite sqlite/3.30.1
- vendor/siemens
- canonical/siemens sinec infrastructure network services
- vendor/oracle
- canonical/oracle mysql workbench
- version/oracle mysql workbench/8.0.19
- vendor/debian
- canonical/debian debian linux
- version/debian debian linux/9.0
- version/debian debian linux/10.0
- vendor/redhat
- canonical/redhat enterprise linux desktop
- version/redhat enterprise linux desktop/6.0
- canonical/redhat enterprise linux server
- version/redhat enterprise linux server/6.0
- canonical/redhat enterprise linux workstation
- version/redhat enterprise linux workstation/6.0
- vendor/suse
- canonical/suse package hub
- canonical/suse linux enterprise
- version/suse linux enterprise/12.0
- vendor/opensuse
- canonical/opensuse backports sle
- version/opensuse backports sle/15.0-sp1
- canonical/opensuse leap
- version/opensuse leap/15.1
- vendor/netapp
- canonical/netapp cloud backup
- package-manager/debian
- package-manager/ubuntu