{"id":"CVE-2019-19242","aliases":["ALPINE-CVE-2019-19242","BELL-CVE-2019-19242","DEBIAN-CVE-2019-19242","EUVD-2019-8868","GHSA-565m-5c74-6h7v","MGASA-2020-0070"],"status":"published","title":"SQLite 3.30.1 mishandles pExpr-\u003ey.pTab, as demonstrated by the TK_COLUMN case in...","description":"SQLite 3.30.1 mishandles pExpr-\u003ey.pTab, as demonstrated by the TK_COLUMN case in sqlite3ExprCodeTarget in expr.c.","severity":{"version":"3.1","score":5.9,"vector":"CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:N/I:N/A:H","level":"medium","assessor":"primary","from":"nvd"},"epss":{"day":"2026-11-09","score":0.02715,"percentile":0.86109,"model":"v2026.06.15"},"facts":{"in_kev":false,"known_exploited":false,"public_exploit":false,"fix_available":true},"cwes":["CWE-476"],"published":"2019-11-25T15:30:11Z","modified":"2026-10-20T13:45:08Z","fixes":[{"ecosystem":"Alpine:v3.10","package":"sqlite","fixed_in":["3.28.0-r2"],"sources":["osv"]},{"ecosystem":"Alpine:v3.11","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.12","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.13","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.14","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.15","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.16","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.17","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.18","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.19","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.20","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.21","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.22","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.23","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.24","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.8","package":"sqlite","fixed_in":["3.25.3-r3"],"sources":["osv"]},{"ecosystem":"Alpine:v3.9","package":"sqlite","fixed_in":["3.28.0-r2"],"sources":["osv"]},{"ecosystem":"Debian:12","package":"sqlite3","fixed_in":["3.30.1+fossil191229-1"],"sources":["osv"]},{"ecosystem":"Debian:13","package":"sqlite3","fixed_in":["3.30.1+fossil191229-1"],"sources":["osv"]},{"ecosystem":"Debian:14","package":"sqlite3","fixed_in":["3.30.1+fossil191229-1"],"sources":["osv"]}],"affected":[{"source":"osv","ecosystem":"Alpine:v3.10","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.28.0-r2"}]}]},{"source":"osv","ecosystem":"Alpine:v3.11","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.12","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.13","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.14","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.15","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.16","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.17","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.18","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.19","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.20","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.21","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.22","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.23","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.24","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.8","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.25.3-r3"}]}]},{"source":"osv","ecosystem":"Alpine:v3.9","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.28.0-r2"}]}]},{"source":"osv","ecosystem":"Debian:12","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1+fossil191229-1"}]}]},{"source":"osv","ecosystem":"Debian:13","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1+fossil191229-1"}]}]},{"source":"osv","ecosystem":"Debian:14","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1+fossil191229-1"}]}]},{"source":"osv","ecosystem":"Mageia:7","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.31.1-1.mga7"}]}],"bundled":9}],"products":[{"vendor":"canonical","product":"ubuntu_linux"},{"vendor":"oracle","product":"mysql_workbench"},{"vendor":"redhat","product":"enterprise_linux"},{"vendor":"siemens","product":"simatic s7-1500 cpu 1518-4 pn/dp mfp"},{"vendor":"siemens","product":"simatic s7-1500 cpu 1518f-4 pn/dp mfp"},{"vendor":"siemens","product":"sinec_infrastructure_network_services"},{"vendor":"siemens","product":"siplus s7-1500 cpu 1518-4 pn/dp mfp"},{"vendor":"sqlite","product":"sqlite"}],"references":[{"url":"https://github.com/sqlite/sqlite/commit/57f7ece78410a8aae86aa4625fb7556897db384c","tags":["x_refsource_MISC","x_transferred","Patch","Third Party Advisory","fix"]},{"url":"https://usn.ubuntu.com/4205-1/","tags":["vendor-advisory","x_refsource_UBUNTU","x_transferred","Third Party Advisory","advisory","web"]},{"url":"https://www.oracle.com/security-alerts/cpuapr2020.html","tags":["x_refsource_MISC","x_transferred","Patch","Third Party Advisory","fix"]},{"url":"https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf","tags":["x_refsource_CONFIRM","x_transferred","Patch","Third Party Advisory","fix"]},{"url":"https://cert-portal.siemens.com/productcert/html/ssa-389290.html","tags":["web"]},{"url":"https://cert-portal.siemens.com/productcert/html/ssa-398330.html","tags":["web"]},{"url":"https://nvd.nist.gov/vuln/detail/CVE-2019-19242"},{"url":"https://usn.ubuntu.com/4205-1"},{"url":"https://github.com/advisories/GHSA-565m-5c74-6h7v"},{"url":"https://security.alpinelinux.org/vuln/CVE-2019-19242","tags":["advisory"]},{"url":"https://docs.bell-sw.com/security/cves/CVE-2019-19242","tags":["advisory"]},{"url":"https://security-tracker.debian.org/tracker/CVE-2019-19242","tags":["advisory"]},{"url":"https://advisories.mageia.org/MGASA-2020-0070.html","tags":["advisory"]},{"url":"https://bugs.mageia.org/show_bug.cgi?id=26104","tags":["report"]},{"url":"https://www.sqlite.org/releaselog/3_29_0.html","tags":["web"]},{"url":"https://www.sqlite.org/releaselog/3_30_0.html","tags":["web"]},{"url":"https://www.sqlite.org/releaselog/3_30_1.html","tags":["web"]},{"url":"https://www.sqlite.org/releaselog/3_31_0.html","tags":["web"]},{"url":"https://www.sqlite.org/releaselog/3_31_1.html","tags":["web"]},{"url":"https://chromereleases.googleblog.com/2019/12/stable-channel-update-for-desktop.html","tags":["web"]}],"sources":{"cve":[{"id":"CVE-2019-19242","description":"SQLite 3.30.1 mishandles pExpr-\u003ey.pTab, as demonstrated by the TK_COLUMN case in sqlite3ExprCodeTarget in expr.c.","status":"published","published":"2019-11-25T15:30:11Z","modified":"2026-10-14T07:00:29.607Z","updated_at":"2026-11-02T14:20:20.397093Z"}],"euvd":[{"id":"EUVD-2019-8868","description":"SQLite 3.30.1 mishandles pExpr-\u003ey.pTab, as demonstrated by the TK_COLUMN case in sqlite3ExprCodeTarget in expr.c.","status":"published","published":"2019-11-25T15:30:11Z","modified":"2026-10-14T07:00:29Z","updated_at":"2026-11-02T17:27:17.374818Z"}],"ghsa":[{"id":"GHSA-565m-5c74-6h7v","title":"SQLite 3.30.1 mishandles pExpr-\u003ey.pTab, as demonstrated by the TK_COLUMN case in...","description":"SQLite 3.30.1 mishandles pExpr-\u003ey.pTab, as demonstrated by the TK_COLUMN case in sqlite3ExprCodeTarget in expr.c.","status":"published","published":"2022-05-24T17:02:19Z","modified":"2026-10-14T09:32:30Z","cvss":[{"version":"3.1","score":5.9,"vector":"CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:N/I:N/A:H","level":"medium"}],"cwes":["CWE-476"],"updated_at":"2026-11-02T15:13:23.530725Z"}],"nvd":[{"id":"CVE-2019-19242","description":"SQLite 3.30.1 mishandles pExpr-\u003ey.pTab, as demonstrated by the TK_COLUMN case in sqlite3ExprCodeTarget in expr.c.","status":"published","published":"2019-11-27T17:15:14.23Z","modified":"2026-10-14T07:16:50.91Z","cvss":[{"version":"3.1","score":5.9,"vector":"CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:N/I:N/A:H","level":"medium","assessor":"primary"},{"version":"2.0","score":4.3,"vector":"AV:N/AC:M/Au:N/C:N/I:N/A:P","level":"medium","assessor":"primary"}],"cwes":["CWE-476"],"updated_at":"2026-11-02T14:05:38.993437Z"}],"osv":[{"id":"ALPINE-CVE-2019-19242","description":"SQLite 3.30.1 mishandles pExpr-\u003ey.pTab, as demonstrated by the TK_COLUMN case in sqlite3ExprCodeTarget in expr.c.","status":"published","published":"2019-11-27T17:15:14.23Z","modified":"2026-09-21T06:17:52.507792037Z","cvss":[{"version":"3.1","score":5.9,"vector":"CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:N/I:N/A:H","level":"medium"}],"updated_at":"2026-11-02T15:27:47.663013Z"},{"id":"BELL-CVE-2019-19242","title":"CVE-2019-19242 does not affect BellSoft software","status":"withdrawn","published":"2023-08-31T12:15:41.21814Z","modified":"2026-01-26T09:48:46.350813Z","cvss":[{"version":"3.1","score":5.9,"vector":"CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:N/I:N/A:H","level":"medium"}],"updated_at":"2026-11-02T15:28:15.340685Z"},{"id":"CVE-2019-19242","description":"SQLite 3.30.1 mishandles pExpr-\u003ey.pTab, as demonstrated by the TK_COLUMN case in sqlite3ExprCodeTarget in expr.c.","status":"published","published":"2019-11-27T17:15:14.23Z","modified":"2026-10-20T13:45:08.223720083Z","cvss":[{"version":"3.1","score":5.9,"vector":"CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:N/I:N/A:H","level":"medium"}],"updated_at":"2026-11-02T15:44:12.010761Z"},{"id":"DEBIAN-CVE-2019-19242","description":"SQLite 3.30.1 mishandles pExpr-\u003ey.pTab, as demonstrated by the TK_COLUMN case in sqlite3ExprCodeTarget in expr.c.","status":"published","published":"2019-11-27T17:15:14.23Z","modified":"2026-10-15T07:47:36.854110941Z","cvss":[{"version":"3.1","score":5.9,"vector":"CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:N/I:N/A:H","level":"medium"}],"updated_at":"2026-11-02T15:45:31.867036Z"},{"id":"MGASA-2020-0070","title":"Updated sqlite3 packages fix security vulnerabilities","description":"Updated sqlite3 packages fix security vulnerabilities:\n\nAn out of bounds write flaw (CVE-2019-13734), insufficient data validation\nflaw (CVE-2019-13750), uninitialized use flaw (CVE-2019-13751), and out of\nbounds read flaws (CVE-2019-13752, CVE-2019-13753) in SQLite before 3.31.0.\n\nIt was discovered that SQLite incorrectly handled certain schemas. An\nattacker could possibly use this issue to cause a denial of service\n(CVE-2019-16168).\n\nIt was discovered that SQLite incorrectly handled certain schemas. An\nattacker could possibly use this issue to mishandles some expressions\n(CVE-2019-19242).\n\nIt was discovered that SQLite incorrectly handled certain queries. An\nattacker could possibly use this issue to execute arbitrary code\n(CVE-2019-19244).\n\nexprListAppendList in window.c in SQLite 3.30.1 allows attackers to trigger\nan invalid pointer dereference because constant integer values in ORDER BY\nclauses of window definitions are mishandled (CVE-2019-19880).\n\nFor other changes in this update, see the referenced releaaselogs.\n","status":"published","published":"2020-01-30T18:28:34Z","modified":"2026-04-16T04:44:19.743145533Z","updated_at":"2026-11-02T15:49:41.151324Z"}]}}