CVE-2019-19923

Summary

CVECVE-2019-19923
StatePUBLIC
Assigner[email protected]
Source PriorityCVE Program / NVD first with legacy fallback
Published2019-12-24 16:15:00 UTC
Updated2022-04-15 16:18:00 UTC
DescriptionflattenSubquery 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).

Risk And Classification

Problem Types: CWE-476

NVD Known Affected Configurations (CPE 2.3)

TypeVendorProductVersionUpdateEditionLanguage
Operating System Debian Debian Linux 10.0 All All All
Operating System Debian Debian Linux 9.0 All All All
Application Netapp Cloud Backup - All All All
Application Opensuse Backports Sle 15.0 sp1 All All
Operating System Opensuse Leap 15.1 All All All
Application Oracle Mysql Workbench All All All All
Operating System Redhat Enterprise Linux Desktop 6.0 All All All
Operating System Redhat Enterprise Linux Server 6.0 All All All
Operating System Redhat Enterprise Linux Workstation 6.0 All All All
Application Siemens Sinec Infrastructure Network Services All All All All
Application Sqlite Sqlite 3.30.1 All All All
Application Sqlite Sqlite 3.30.1 All All All
Operating System Suse Linux Enterprise 12.0 All All All
Application Suse Package Hub - All All All

References

ReferenceSourceLinkTags
USN-4298-1: SQLite vulnerabilities | Ubuntu security notices | Ubuntu UBUNTU usn.ubuntu.com
Red Hat Customer Portal REDHAT access.redhat.com
[security-announce] openSUSE-SU-2020:0210-1: important: Security update SUSE lists.opensuse.org
[security-announce] openSUSE-SU-2020:0189-1: important: Security update SUSE lists.opensuse.org
Continue to back away from the LEFT JOIN optimization of check-in [41… · sqlite/sqlite@396afe6 · GitHub MISC github.com Patch
[security-announce] openSUSE-SU-2020:0233-1: important: Security update SUSE lists.opensuse.org
cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf CONFIRM cert-portal.siemens.com
January 2020 SQLite Vulnerabilities in NetApp Products | NetApp Product Security CONFIRM security.netapp.com
Oracle Critical Patch Update Advisory - April 2020 N/A www.oracle.com
Debian -- Security Information -- DSA-4638-1 chromium DEBIAN www.debian.org
CVE Program record CVE.ORG www.cve.org canonical
NVD vulnerability detail NVD nvd.nist.gov canonical, analysis

Legacy QID Mappings

  • 296075 Oracle Solaris 11.4 Support Repository Update (SRU) 21.69.0 Missing (CPUAPR2020)
  • 377341 Alibaba Cloud Linux Security Update for sqlite (ALINUX3-SA-2022:0111)
  • 591406 Siemens SIMATIC S7-1500 CPU GNU/Linux subsystem Multiple Vulnerabilities (SSB-439005, ICSA-22-104-13)
  • 750831 SUSE Enterprise Linux Security Update for sqlite3 (SUSE-SU-2021:2320-1)
  • 750834 OpenSUSE Security Update for sqlite3 (openSUSE-SU-2021:2320-1)
  • 750856 OpenSUSE Security Update for sqlite3 (openSUSE-SU-2021:1058-1)
  • 751168 SUSE Enterprise Linux Security Update for sqlite3 (SUSE-SU-2021:3215-1)
© CVE.report 2026 |

Use of this information constitutes acceptance for use in an AS IS condition. There are NO warranties, implied or otherwise, with regard to this information or its use. Any use of this information is at the user's risk. It is the responsibility of user to evaluate the accuracy, completeness or usefulness of any information, opinion, advice or other content. EACH USER WILL BE SOLELY RESPONSIBLE FOR ANY consequences of his or her direct or indirect use of this web site. ALL WARRANTIES OF ANY KIND ARE EXPRESSLY DISCLAIMED. This site will NOT BE LIABLE FOR ANY DIRECT, INDIRECT or any other kind of loss.

CVE, CWE, and OVAL are registred trademarks of The MITRE Corporation and the authoritative source of CVE content is MITRE's CVE web site. This site includes MITRE data granted under the following license.

CVE.report and Source URL Uptime Status status.cve.report