{"id":"UBUNTU-CVE-2019-19923","details":"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).","modified":"2026-04-22T12:16:32.183274Z","published":"2019-12-24T16:15:00Z","related":["USN-4298-1"],"upstream":["CVE-2019-19923"],"references":[{"type":"REPORT","url":"https://ubuntu.com/security/CVE-2019-19923"},{"type":"ADVISORY","url":"https://ubuntu.com/security/notices/USN-4298-1"},{"type":"REPORT","url":"https://www.cve.org/CVERecord?id=CVE-2019-19923"}],"affected":[{"package":{"name":"sqlite3","ecosystem":"Ubuntu:18.04:LTS","purl":"pkg:deb/ubuntu/sqlite3@3.22.0-1ubuntu0.3?arch=source&distro=bionic"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.22.0-1ubuntu0.3"}]}],"versions":["3.19.3-3","3.20.1-2","3.21.0-1","3.22.0-1","3.22.0-1ubuntu0.1","3.22.0-1ubuntu0.2"],"ecosystem_specific":{"binaries":[{"binary_version":"3.22.0-1ubuntu0.3","binary_name":"lemon"},{"binary_version":"3.22.0-1ubuntu0.3","binary_name":"libsqlite3-0"},{"binary_version":"3.22.0-1ubuntu0.3","binary_name":"libsqlite3-tcl"},{"binary_version":"3.22.0-1ubuntu0.3","binary_name":"sqlite3"}],"availability":"No subscription required"},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2019/UBUNTU-CVE-2019-19923.json"}}],"schema_version":"1.7.5","severity":[{"type":"CVSS_V3","score":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H"},{"type":"Ubuntu","score":"medium"}]}