{"id":"UBUNTU-CVE-2018-8740","details":"In SQLite through 3.22.0, databases whose schema is corrupted using a CREATE TABLE AS statement could cause a NULL pointer dereference, related to build.c and prepare.c.","modified":"2026-04-22T12:04:25.683213Z","published":"2018-03-17T00:29:00Z","related":["USN-4205-1","USN-4394-1"],"upstream":["CVE-2018-8740"],"references":[{"type":"REPORT","url":"https://ubuntu.com/security/CVE-2018-8740"},{"type":"REPORT","url":"https://www.sqlite.org/cgi/src/timeline?r=corrupt-schema"},{"type":"ADVISORY","url":"https://ubuntu.com/security/notices/USN-4205-1"},{"type":"ADVISORY","url":"https://ubuntu.com/security/notices/USN-4394-1"},{"type":"REPORT","url":"https://www.cve.org/CVERecord?id=CVE-2018-8740"}],"affected":[{"package":{"name":"sqlite3","ecosystem":"Ubuntu:14.04:LTS","purl":"pkg:deb/ubuntu/sqlite3@3.8.2-1ubuntu2.2?arch=source&distro=trusty"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.8.2-1ubuntu2.2"}]}],"versions":["3.7.17-1ubuntu1","3.8.0.2-1ubuntu1","3.8.1-1ubuntu1","3.8.1-1ubuntu3","3.8.2-1ubuntu1","3.8.2-1ubuntu2","3.8.2-1ubuntu2.1"],"ecosystem_specific":{"availability":"No subscription required","binaries":[{"binary_version":"3.8.2-1ubuntu2.2","binary_name":"lemon"},{"binary_version":"3.8.2-1ubuntu2.2","binary_name":"libsqlite3-0"},{"binary_version":"3.8.2-1ubuntu2.2","binary_name":"libsqlite3-tcl"},{"binary_version":"3.8.2-1ubuntu2.2","binary_name":"sqlite3"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2018/UBUNTU-CVE-2018-8740.json"}},{"package":{"name":"sqlite3","ecosystem":"Ubuntu:16.04:LTS","purl":"pkg:deb/ubuntu/sqlite3@3.11.0-1ubuntu1.1?arch=source&distro=xenial"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.11.0-1ubuntu1.1"}]}],"versions":["3.8.11.1-1","3.9.1-2","3.9.2-1","3.10.0-1","3.10.1-1","3.10.2-1","3.11.0-1ubuntu1"],"ecosystem_specific":{"availability":"No subscription required","binaries":[{"binary_version":"3.11.0-1ubuntu1.1","binary_name":"lemon"},{"binary_version":"3.11.0-1ubuntu1.1","binary_name":"libsqlite3-0"},{"binary_version":"3.11.0-1ubuntu1.1","binary_name":"libsqlite3-tcl"},{"binary_version":"3.11.0-1ubuntu1.1","binary_name":"sqlite3"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2018/UBUNTU-CVE-2018-8740.json"}},{"package":{"name":"sqlite3","ecosystem":"Ubuntu:18.04:LTS","purl":"pkg:deb/ubuntu/sqlite3@3.22.0-1ubuntu0.4?arch=source&distro=bionic"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.22.0-1ubuntu0.4"}]}],"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","3.22.0-1ubuntu0.3"],"ecosystem_specific":{"availability":"No subscription required","binaries":[{"binary_version":"3.22.0-1ubuntu0.4","binary_name":"lemon"},{"binary_version":"3.22.0-1ubuntu0.4","binary_name":"libsqlite3-0"},{"binary_version":"3.22.0-1ubuntu0.4","binary_name":"libsqlite3-tcl"},{"binary_version":"3.22.0-1ubuntu0.4","binary_name":"sqlite3"}]},"database_specific":{"source":"https://github.com/canonical/ubuntu-security-notices/blob/main/osv/cve/2018/UBUNTU-CVE-2018-8740.json"}}],"schema_version":"1.7.5","severity":[{"type":"CVSS_V3","score":"CVSS:3.0/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H"},{"type":"Ubuntu","score":"low"}]}