{"id":"CVE-2019-19242","details":"SQLite 3.30.1 mishandles pExpr-\u003ey.pTab, as demonstrated by the TK_COLUMN case in sqlite3ExprCodeTarget in expr.c.","modified":"2026-08-07T14:52:52.103292Z","published":"2019-11-27T17:15:14.230Z","database_specific":{"unresolved_ranges":[{"source":"CPE_RANGE","vendor_product":"oracle:mysql_workbench","cpes":["cpe:2.3:a:oracle:mysql_workbench:*:*:*:*:*:*:*:*"],"extracted_events":[{"last_affected":"8.0.19"}]},{"cpes":["cpe:2.3:a:siemens:sinec_infrastructure_network_services:*:*:*:*:*:*:*:*"],"extracted_events":[{"fixed":"1.0.1.1"}],"source":"CPE_RANGE","vendor_product":"siemens:sinec_infrastructure_network_services"},{"cpes":["cpe:2.3:o:canonical:ubuntu_linux:12.04:*:*:*:esm:*:*:*","cpe:2.3:o:canonical:ubuntu_linux:16.04:*:*:*:lts:*:*:*","cpe:2.3:o:canonical:ubuntu_linux:18.04:*:*:*:lts:*:*:*","cpe:2.3:o:canonical:ubuntu_linux:19.04:*:*:*:*:*:*:*","cpe:2.3:o:canonical:ubuntu_linux:19.10:*:*:*:*:*:*:*"],"extracted_events":[{"introduced":"12.04"},{"last_affected":"12.04"},{"introduced":"16.04"},{"last_affected":"16.04"},{"introduced":"18.04"},{"last_affected":"18.04"},{"introduced":"19.04"},{"last_affected":"19.04"},{"introduced":"19.10"},{"last_affected":"19.10"}],"source":"CPE_STRING","vendor_product":"canonical:ubuntu_linux"},{"source":"CPE_STRING","vendor_product":"redhat:enterprise_linux","cpes":["cpe:2.3:o:redhat:enterprise_linux:8.0:*:*:*:*:*:*:*"],"extracted_events":[{"introduced":"8.0"},{"last_affected":"8.0"}]}]},"references":[{"type":"ADVISORY","url":"https://usn.ubuntu.com/4205-1/"},{"type":"FIX","url":"https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf"},{"type":"FIX","url":"https://github.com/sqlite/sqlite/commit/57f7ece78410a8aae86aa4625fb7556897db384c"},{"type":"FIX","url":"https://www.oracle.com/security-alerts/cpuapr2020.html"}],"affected":[{"ranges":[{"type":"GIT","repo":"https://github.com/sqlite/sqlite","events":[{"introduced":"25e9591209453dc0904f8f0f1c4d5090c836e19b"},{"last_affected":"25e9591209453dc0904f8f0f1c4d5090c836e19b"},{"fixed":"57f7ece78410a8aae86aa4625fb7556897db384c"}],"database_specific":{"cpe":"cpe:2.3:a:sqlite:sqlite:3.30.1:*:*:*:*:*:*:*","extracted_events":[{"introduced":"3.30.1"},{"last_affected":"3.30.1"}],"source":["CPE_STRING","REFERENCES"]}}],"versions":["3.30.1","version-3.30.1"],"database_specific":{"source":"https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2019-19242.json","vanir_signatures_modified":"2026-08-07T14:52:52Z","vanir_signatures":[{"source":"https://github.com/sqlite/sqlite/commit/57f7ece78410a8aae86aa4625fb7556897db384c","target":{"file":"src/wherecode.c"},"deprecated":false,"digest":{"line_hashes":["272171035038571025389595851029157703074","267442456182522856045235945392506900464","118415636789467465061053839391898871037","206027221619297694965688112644458520441"],"threshold":0.9},"id":"CVE-2019-19242-03a69a64","signature_type":"Line","signature_version":"v1"},{"digest":{"function_hash":"219203062469301619849027150853221467284","length":334},"id":"CVE-2019-19242-56baf8c3","signature_type":"Function","signature_version":"v1","source":"https://github.com/sqlite/sqlite/commit/57f7ece78410a8aae86aa4625fb7556897db384c","target":{"file":"src/wherecode.c","function":"whereIndexExprTransColumn"},"deprecated":false},{"digest":{"line_hashes":["73196936375848863988946647638199175336","54061856683093212388608604271662140636","187896069255515307547888284833172571856","94603599993386840175216938376850118166"],"threshold":0.9},"id":"CVE-2019-19242-59c37900","signature_type":"Line","signature_version":"v1","source":"https://github.com/sqlite/sqlite/commit/57f7ece78410a8aae86aa4625fb7556897db384c","target":{"file":"src/expr.c"},"deprecated":false},{"deprecated":false,"digest":{"function_hash":"112052855901138366623425549513834949919","length":16927},"id":"CVE-2019-19242-a996fa2a","signature_type":"Function","signature_version":"v1","source":"https://github.com/sqlite/sqlite/commit/57f7ece78410a8aae86aa4625fb7556897db384c","target":{"file":"src/expr.c","function":"sqlite3ExprCodeTarget"}}]}}],"schema_version":"1.8.0","severity":[{"type":"CVSS_V3","score":"CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:N/I:N/A:H"}]}