Vulnerability Details CVE-2019-19923
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).
Exploit prediction scoring system (EPSS) score
EPSS Score 0.139
EPSS Ranking 93.9%
CVSS Severity
CVSS v3 Score 7.5
CVSS v2 Score 5.0
References
- 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
- 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
Products affected by CVE-2019-19923
-
cpe:2.3:a:netapp:cloud_backup:-
-
cpe:2.3:a:opensuse:backports_sle:15.0
-
cpe:2.3:a:oracle:mysql_workbench:-
-
cpe:2.3:a:oracle:mysql_workbench:5.2.47
-
cpe:2.3:a:oracle:mysql_workbench:6.0.9
-
cpe:2.3:a:oracle:mysql_workbench:6.1.7
-
cpe:2.3:a:oracle:mysql_workbench:6.2.5
-
cpe:2.3:a:oracle:mysql_workbench:6.3.10
-
cpe:2.3:a:oracle:mysql_workbench:6.3.8
-
cpe:2.3:a:oracle:mysql_workbench:8.0.12
-
cpe:2.3:a:oracle:mysql_workbench:8.0.13
-
cpe:2.3:a:oracle:mysql_workbench:8.0.14
-
cpe:2.3:a:oracle:mysql_workbench:8.0.15
-
cpe:2.3:a:oracle:mysql_workbench:8.0.16
-
cpe:2.3:a:oracle:mysql_workbench:8.0.17
-
cpe:2.3:a:oracle:mysql_workbench:8.0.18
-
cpe:2.3:a:oracle:mysql_workbench:8.0.19
-
cpe:2.3:a:siemens:sinec_infrastructure_network_services:-
-
cpe:2.3:a:siemens:sinec_infrastructure_network_services:1.0.1
-
cpe:2.3:a:sqlite:sqlite:3.30.1
-
cpe:2.3:a:suse:package_hub:-
-
cpe:2.3:o:debian:debian_linux:10.0
-
cpe:2.3:o:debian:debian_linux:9.0
-
cpe:2.3:o:opensuse:leap:15.1
-
cpe:2.3:o:redhat:enterprise_linux_desktop:6.0
-
cpe:2.3:o:redhat:enterprise_linux_server:6.0
-
cpe:2.3:o:redhat:enterprise_linux_workstation:6.0
-
cpe:2.3:o:suse:linux_enterprise:12.0