Read the docs
TI-2019-14369 Aliases CVE-2019-19923GHSA-5gmx-grg5-hh7x

flattenSubquery in select.c in SQLite 3.30.1 mishandles certain uses of SELECT DISTINCT…

Priority MEDIUM 43CWE-476Published · Updated

Key facts

Attack vector
Network
Privileges required
None
User interaction
None
Attack complexity
Low
Impact type
Denial of service
Confidentiality · integrity · availability
None · None · High
Fix status
Fixed

Attack profile from CVSS 3.1 · NVD. Fix status from CNA and Red Hat. Impact type from CWE-476.

Summary

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

Why it matters now

EPSS 0.0681 94th percentileScored 2026-11-07
Fix Fixed Red Hat: 2 advisories

SSVC decision points

Not available: CISA has not published SSVC decision points for this record.

Affected products

VendorProductAffected versionsFixed inStatusSource
——all versions—No fix listedCNA
  • — Vendor— Affected all versions Fixed in — No fix listed CNA

CPE configurations NVD · 13

CPEVersionsRoleVendor
cpe:2.3:a:sqlite:sqlite:3.30.1:*:*:*:*:*:*:*3.30.1VulnerableSQLite
cpe:2.3:a:siemens:sinec_infrastructure_network_services:*:*:*:*:*:*:*:*before 1.0.1.1VulnerableSiemens
cpe:2.3:a:oracle:mysql_workbench:*:*:*:*:*:*:*:*up to 8.0.19VulnerableOracle
cpe:2.3:o:debian:debian_linux:9.0:*:*:*:*:*:*:*9.0VulnerableDebian
cpe:2.3:o:debian:debian_linux:10.0:*:*:*:*:*:*:*10.0VulnerableDebian
cpe:2.3:o:redhat:enterprise_linux_desktop:6.0:*:*:*:*:*:*:*6.0VulnerableRed Hat
cpe:2.3:o:redhat:enterprise_linux_server:6.0:*:*:*:*:*:*:*6.0VulnerableRed Hat
cpe:2.3:o:redhat:enterprise_linux_workstation:6.0:*:*:*:*:*:*:*6.0VulnerableRed Hat
cpe:2.3:a:suse:package_hub:-:*:*:*:*:*:*:*not specified by NVDVulnerableSUSE
cpe:2.3:o:suse:linux_enterprise:12.0:*:*:*:*:*:*:*12.0Running onSUSE
  • cpe:2.3:a:sqlite:sqlite:3.30.1:*:*:*:*:*:*:* Versions 3.30.1 Vulnerable ·SQLite
  • cpe:2.3:a:siemens:sinec_infrastructure_network_services:*:*:*:*:*:*:*:* Versions before 1.0.1.1 Vulnerable ·Siemens
  • cpe:2.3:a:oracle:mysql_workbench:*:*:*:*:*:*:*:* Versions up to 8.0.19 Vulnerable ·Oracle
  • cpe:2.3:o:debian:debian_linux:9.0:*:*:*:*:*:*:* Versions 9.0 Vulnerable ·Debian
  • cpe:2.3:o:debian:debian_linux:10.0:*:*:*:*:*:*:* Versions 10.0 Vulnerable ·Debian
  • cpe:2.3:o:redhat:enterprise_linux_desktop:6.0:*:*:*:*:*:*:* Versions 6.0 Vulnerable ·Red Hat
  • cpe:2.3:o:redhat:enterprise_linux_server:6.0:*:*:*:*:*:*:* Versions 6.0 Vulnerable ·Red Hat
  • cpe:2.3:o:redhat:enterprise_linux_workstation:6.0:*:*:*:*:*:*:* Versions 6.0 Vulnerable ·Red Hat
  • cpe:2.3:a:suse:package_hub:-:*:*:*:*:*:*:* Versions not specified by NVD Vulnerable ·SUSE
  • cpe:2.3:o:suse:linux_enterprise:12.0:*:*:*:*:*:*:* Versions 12.0 Running on ·SUSE
Show 3 more CPE
CPEVersionsRoleVendor
cpe:2.3:a:opensuse:backports_sle:15.0:sp1:*:*:*:*:*:*15.0 sp1VulnerableopenSUSE
cpe:2.3:o:opensuse:leap:15.1:*:*:*:*:*:*:*15.1VulnerableopenSUSE
cpe:2.3:a:netapp:cloud_backup:-:*:*:*:*:*:*:*not specified by NVDVulnerableNetApp
  • cpe:2.3:a:opensuse:backports_sle:15.0:sp1:*:*:*:*:*:* Versions 15.0 sp1 Vulnerable ·openSUSE
  • cpe:2.3:o:opensuse:leap:15.1:*:*:*:*:*:*:* Versions 15.1 Vulnerable ·openSUSE
  • cpe:2.3:a:netapp:cloud_backup:-:*:*:*:*:*:*:* Versions not specified by NVD Vulnerable ·NetApp

Remediation

Red Hat 2 advisories

  • RHSA-2020:1810 Released 2020-04-28 · Red Hat rating Moderate
    sqlite security and bug fix update
    • Red Hat Enterprise Linux AppStream (v. 8) lemon-3.26.0-6.el8
    • Red Hat Enterprise Linux BaseOS (v. 8) sqlite-3.26.0-6.el8, sqlite-devel-3.26.0-6.el8, sqlite-doc-3.26.0-6.el8 +1
  • RHSA-2020:0514 Released 2020-02-17 · Red Hat rating Important
    chromium-browser security update
    • Red Hat Enterprise Linux Desktop Supplementary (v. 6) chromium-browser-80.0.3987.87-1.el6_10
    • Red Hat Enterprise Linux HPC Node Supplementary (v. 6) chromium-browser-80.0.3987.87-1.el6_10
    • Red Hat Enterprise Linux Server Supplementary (v. 6) chromium-browser-80.0.3987.87-1.el6_10
    • Red Hat Enterprise Linux Workstation Supplementary (v. 6) chromium-browser-80.0.3987.87-1.el6_10

Vendor assessments

Red Hat

Red Hat rating: Moderate. Red Hat's page for this CVE →

ProductStatusPlan or fix
Red Hat Enterprise Linux AppStream (v. 8)Fixed RHSA-2020:1810
Red Hat Enterprise Linux BaseOS (v. 8)Fixed RHSA-2020:1810
Red Hat Enterprise Linux Desktop Supplementary (v. 6)Fixed RHSA-2020:0514
Red Hat Enterprise Linux HPC Node Supplementary (v. 6)Fixed RHSA-2020:0514
Red Hat Enterprise Linux Server Supplementary (v. 6)Fixed RHSA-2020:0514
Red Hat Enterprise Linux Workstation Supplementary (v. 6)Fixed RHSA-2020:0514
Not affected: 3 products
  • Red Hat Enterprise Linux 5
  • Red Hat Enterprise Linux 6
  • Red Hat Enterprise Linux 7

Timeline

  1. 2026-10-02 Threatist record created from CVE-2019-19923
  2. 2026-10-03 Alias added: GHSA-5gmx-grg5-hh7x

References

Patch 3

Advisory 7

Sources

This product uses the NVD API but is not endorsed or certified by the NVD. Sources and licences