Rapid7 Vulnerability & Exploit Database

Red Hat: CVE-2019-19923: CVE-2019-19923 sqlite: mishandling of certain uses of SELECT DISTINCT involving a LEFT JOIN in flattenSubquery in select.c leads to a NULL pointer dereference (Multiple Advisories)

Free InsightVM Trial No Credit Card Necessary
Watch Demo See how it all works
Back to Search

Red Hat: CVE-2019-19923: CVE-2019-19923 sqlite: mishandling of certain uses of SELECT DISTINCT involving a LEFT JOIN in flattenSubquery in select.c leads to a NULL pointer dereference (Multiple Advisories)

Severity
5
CVSS
(AV:N/AC:L/Au:N/C:N/I:N/A:P)
Published
12/24/2019
Created
02/19/2020
Added
02/18/2020
Modified
12/15/2023

Description

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).

Solution(s)

  • redhat-upgrade-lemon
  • redhat-upgrade-lemon-debuginfo
  • redhat-upgrade-sqlite
  • redhat-upgrade-sqlite-analyzer-debuginfo
  • redhat-upgrade-sqlite-debuginfo
  • redhat-upgrade-sqlite-debugsource
  • redhat-upgrade-sqlite-devel
  • redhat-upgrade-sqlite-doc
  • redhat-upgrade-sqlite-libs
  • redhat-upgrade-sqlite-libs-debuginfo
  • redhat-upgrade-sqlite-tcl-debuginfo

With Rapid7 live dashboards, I have a clear view of all the assets on my network, which ones can be exploited, and what I need to do in order to reduce the risk in my environment in real-time. No other tool gives us that kind of value and insight.

– Scott Cheney, Manager of Information Security, Sierra View Medical Center

;