Medium
Security advisory
SQLite 3.30.1 mishandles pExpr->y.pTab, as demonstrated by the TK_COLUMN case in sqlite3ExprCodeTarget in expr.c.
- Products
- Not specified
- Affected versions
- Not specified
- Fixed versions
- Not specified
- CVEs
- CVE-2019-19242
- Confirmed fixed CVEs
- Not specified
- Updated in this feed
- 31 Oct 2026, 12:30 UTC · Revision 1
Source evidence
SQLite 3.30.1 mishandles pExpr->y.pTab, as demonstrated by the TK_COLUMN case in sqlite3ExprCodeTarget in expr.c.
osv:CVE-2019-19242
Complete source record
{
"id": "039f8fe785de4be6be75c09818bcc86b132d68f978b44fa4d96c0a93b50a8431",
"url": "https://osv.dev/vulnerability/CVE-2019-19242",
"method": "structured",
"payload": {
"kind": "advisory",
"title": "CVE-2019-19242",
"summary": "SQLite 3.30.1 mishandles pExpr->y.pTab, as demonstrated by the TK_COLUMN case in sqlite3ExprCodeTarget in expr.c.",
"evidence": "osv:CVE-2019-19242",
"products": [],
"severity": "medium",
"structured": {
"id": "CVE-2019-19242",
"aliases": [
"CVE-2019-19242"
],
"metrics": [
{
"type": "CVSS_V3",
"score": "CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:N/I:N/A:H"
}
],
"affected": [
{
"ranges": [
{
"repo": "https://github.com/sqlite/sqlite",
"type": "GIT",
"events": [
{
"introduced": "25e9591209453dc0904f8f0f1c4d5090c836e19b"
},
{
"last_affected": "25e9591209453dc0904f8f0f1c4d5090c836e19b"
},
{
"fixed": "57f7ece78410a8aae86aa4625fb7556897db384c"
}
],
"database_specific": {
"extracted_events": [
{
"cpe": "cpe:2.3:a:sqlite:sqlite:3.30.1:*:*:*:*:*:*:*",
"range": [
{
"introduced": "3.30.1"
},
{
"last_affected": "3.30.1"
}
],
"source": "CPE_STRING"
},
{
"range": [
{
"fixed": "57f7ece78410a8aae86aa4625fb7556897db384c"
}
],
"source": "REFERENCES_COMMIT"
}
]
}
}
],
"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": [
{
"id": "CVE-2019-19242-03a69a64",
"digest": {
"threshold": 0.9,
"line_hashes": [
"272171035038571025389595851029157703074",
"267442456182522856045235945392506900464",
"118415636789467465061053839391898871037",
"206027221619297694965688112644458520441"
]
},
"source": "https://github.com/sqlite/sqlite/commit/57f7ece78410a8aae86aa4625fb7556897db384c",
"target": {
"file": "src/wherecode.c"
},
"deprecated": false,
"signature_type": "Line",
"signature_version": "v1"
},
{
"id": "CVE-2019-19242-56baf8c3",
"digest": {
"length": 334,
"function_hash": "219203062469301619849027150853221467284"
},
"source": "https://github.com/sqlite/sqlite/commit/57f7ece78410a8aae86aa4625fb7556897db384c",
"target": {
"file": "src/wherecode.c",
"function": "whereIndexExprTransColumn"
},
"deprecated": false,
"signature_type": "Function",
"signature_version": "v1"
},
{
"id": "CVE-2019-19242-59c37900",
"digest": {
"threshold": 0.9,
"line_hashes": [
"73196936375848863988946647638199175336",
"54061856683093212388608604271662140636",
"187896069255515307547888284833172571856",
"94603599993386840175216938376850118166"
]
},
"source": "https://github.com/sqlite/sqlite/commit/57f7ece78410a8aae86aa4625fb7556897db384c",
"target": {
"file": "src/expr.c"
},
"deprecated": false,
"signature_type": "Line",
"signature_version": "v1"
},
{
"id": "CVE-2019-19242-a996fa2a",
"digest": {
"length": 16927,
"function_hash": "112052855901138366623425549513834949919"
},
"source": "https://github.com/sqlite/sqlite/commit/57f7ece78410a8aae86aa4625fb7556897db384c",
"target": {
"file": "src/expr.c",
"function": "sqlite3ExprCodeTarget"
},
"deprecated": false,
"signature_type": "Function",
"signature_version": "v1"
}
],
"vanir_signatures_modified": "2026-10-20T13:45:08Z"
}
}
],
"modified": "2026-10-20T13:45:08.223720083Z",
"provider": "osv",
"references": [
"https://cert-portal.siemens.com/productcert/html/ssa-389290.html",
"https://cert-portal.siemens.com/productcert/html/ssa-398330.html",
"https://usn.ubuntu.com/4205-1/",
"https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf",
"https://github.com/sqlite/sqlite/commit/57f7ece78410a8aae86aa4625fb7556897db384c",
"https://www.oracle.com/security-alerts/cpuapr2020.html"
],
"provider_metadata": {
"unresolved_ranges": [
{
"cpes": [
"cpe:2.3:a:oracle:mysql_workbench:*:*:*:*:*:*:*:*"
],
"vendor_product": "oracle:mysql_workbench",
"extracted_events": [
{
"range": [
{
"last_affected": "8.0.19"
}
],
"source": "CPE_RANGE"
}
]
},
{
"cpes": [
"cpe:2.3:a:siemens:sinec_infrastructure_network_services:*:*:*:*:*:*:*:*"
],
"vendor_product": "siemens:sinec_infrastructure_network_services",
"extracted_events": [
{
"range": [
{
"fixed": "1.0.1.1"
}
],
"source": "CPE_RANGE"
}
]
},
{
"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:*:*:*:*:*:*:*"
],
"vendor_product": "canonical:ubuntu_linux",
"extracted_events": [
{
"range": [
{
"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"
}
]
},
{
"cpes": [
"cpe:2.3:o:redhat:enterprise_linux:8.0:*:*:*:*:*:*:*"
],
"vendor_product": "redhat:enterprise_linux",
"extracted_events": [
{
"range": [
{
"introduced": "8.0"
},
{
"last_affected": "8.0"
}
],
"source": "CPE_STRING"
}
]
}
]
}
},
"related_cves": [
{
"value": "CVE-2019-19242",
"evidence": "/id"
}
],
"security_relevant": true,
"severity_evidence": "/severity/0/score"
},
"source_id": "core-osv",
"document_id": 388062,
"published_at": "2019-11-27T17:15:14.23+00:00"
}