REDHAT-BUG-1788846: SQL Injection
First published: Wed Jan 08 2020(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). Upstream fix: <a href="https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35">https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35</a>
| Affected Software | Affected Version | How to fix |
|---|---|---|
| SQLite JDBC |
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://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35
- 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/errata/RHSA-2020:0514
- 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
Frequently Asked Questions
What is the severity of REDHAT-BUG-1788846?
The severity of REDHAT-BUG-1788846 is classified as a potential vulnerability due to the risk of NULL pointer dereference or incorrect results.
How do I fix REDHAT-BUG-1788846?
To fix REDHAT-BUG-1788846, users should upgrade to the latest version of SQLite that contains the upstream fix.
What versions of SQLite are affected by REDHAT-BUG-1788846?
REDHAT-BUG-1788846 affects SQLite 3.30.1 specifically, particularly in scenarios involving SELECT DISTINCT and LEFT JOIN with views.
What type of issue is described in REDHAT-BUG-1788846?
REDHAT-BUG-1788846 describes a mishandling issue in flattenSubquery in select.c that can lead to a NULL pointer dereference.
Is there an upstream fix for REDHAT-BUG-1788846?
Yes, there is an upstream fix for REDHAT-BUG-1788846 that has been implemented in later versions of SQLite.
- agent/type
- agent/weakness
- agent/last-modified-date
- agent/first-publish-date
- collector/redhat-bugzilla
- source/Red Hat
- alias/CVE-2019-19923
- agent/severity
- agent/references
- agent/description
- agent/event
- agent/source
- agent/softwarecombine
- agent/tags
- agent/guess-ai
- agent/software-canonical-lookup
- agent/software-canonical-lookup-request
- vendor/sqlite
- canonical/sqlite