Skip to content

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

HighCVSS 7.5 EPSS 6.8%
Published
Updated
Exploit status
No public exploit known

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

Affected products

ProductAffected versionsFixed in
debian/chromium(Debian:12) < 80.0.3987.106-1 80.0.3987.106-1
debian/chromium(Debian:13) < 80.0.3987.106-1 80.0.3987.106-1
debian/chromium(Debian:14) < 80.0.3987.106-1 80.0.3987.106-1
debian/sqlite3(Debian:12) < 3.30.1+fossil191229-1 3.30.1+fossil191229-1
debian/sqlite3(Debian:13) < 3.30.1+fossil191229-1 3.30.1+fossil191229-1
debian/sqlite3(Debian:14) < 3.30.1+fossil191229-1 3.30.1+fossil191229-1
Siemens SIMATIC S7-1500 CPU 1518-4 PN/DP MFP >= V3.1.0, < V3.1.5 V3.1.5
Siemens SIMATIC S7-1500 CPU 1518F-4 PN/DP MFP >= V3.1.0, < V3.1.5 V3.1.5
Siemens SIPLUS S7-1500 CPU 1518-4 PN/DP MFP >= V3.1.0, < V3.1.5 V3.1.5
SQLite = 3.30.1 No fix listed
Siemens sinec infrastructure network services < 1.0.1.1 1.0.1.1
oracle mysql workbench <= 8.0.19 No fix listed
debian linux = 9.0 No fix listed
debian linux = 10.0 No fix listed
redhat enterprise linux desktop = 6.0 No fix listed
redhat enterprise linux server = 6.0 No fix listed
redhat enterprise linux workstation = 6.0 No fix listed
SUSE package hub All versions No fix listed
openSUSE backports sle = 15.0-sp1 No fix listed
openSUSE leap = 15.1 No fix listed
netapp cloud backup All versions No fix listed

References