CVE-2019-19242

See a problem?
Please try reporting it to the source first.
Source
https://cve.org/CVERecord?id=CVE-2019-19242
Import Source
https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2019-19242.json
JSON Data
https://api.osv.dev/v1/vulns/CVE-2019-19242
Downstream
Published
2019-11-27T17:15:14.230Z
Modified
2026-08-07T14:52:52.103292Z
Severity
  • 5.9 (Medium) CVSS_V3 - CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:N/I:N/A:H CVSS Calculator
Summary
[none]
Details

SQLite 3.30.1 mishandles pExpr->y.pTab, as demonstrated by the TK_COLUMN case in sqlite3ExprCodeTarget in expr.c.

Database specific 
{
    "unresolved_ranges": [
        {
            "vendor_product": "oracle:mysql_workbench",
            "cpes": [
                "cpe:2.3:a:oracle:mysql_workbench:*:*:*:*:*:*:*:*"
            ],
            "extracted_events": [
                {
                    "last_affected": "8.0.19"
                }
            ],
            "source": "CPE_RANGE"
        },
        {
            "vendor_product": "siemens:sinec_infrastructure_network_services",
            "cpes": [
                "cpe:2.3:a:siemens:sinec_infrastructure_network_services:*:*:*:*:*:*:*:*"
            ],
            "extracted_events": [
                {
                    "fixed": "1.0.1.1"
                }
            ],
            "source": "CPE_RANGE"
        },
        {
            "vendor_product": "canonical:ubuntu_linux",
            "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": "redhat:enterprise_linux",
            "cpes": [
                "cpe:2.3:o:redhat:enterprise_linux:8.0:*:*:*:*:*:*:*"
            ],
            "extracted_events": [
                {
                    "introduced": "8.0"
                },
                {
                    "last_affected": "8.0"
                }
            ],
            "source": "CPE_STRING"
        }
    ]
}
References

Affected packages

Git / github.com/sqlite/sqlite

Affected ranges

Type
GIT
Repo
https://github.com/sqlite/sqlite
Events
Introduced
25e9591209453dc0904f8f0f1c4d5090c836e19b
Last affected
25e9591209453dc0904f8f0f1c4d5090c836e19b
Fixed
57f7ece78410a8aae86aa4625fb7556897db384c
Database specific
Show details 
{
    "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"
    ]
}

Affected versions

3.*
3.30.1
version-3.*
version-3.30.1

Database specific

vanir_signatures_modified 
"2026-08-07T14:52:52Z"
vanir_signatures 
[
    {
        "id": "CVE-2019-19242-03a69a64",
        "deprecated": false,
        "signature_type": "Line",
        "signature_version": "v1",
        "digest": {
            "threshold": 0.9,
            "line_hashes": [
                "272171035038571025389595851029157703074",
                "267442456182522856045235945392506900464",
                "118415636789467465061053839391898871037",
                "206027221619297694965688112644458520441"
            ]
        },
        "source": "https://github.com/sqlite/sqlite/commit/57f7ece78410a8aae86aa4625fb7556897db384c",
        "target": {
            "file": "src/wherecode.c"
        }
    },
    {
        "id": "CVE-2019-19242-56baf8c3",
        "deprecated": false,
        "signature_type": "Function",
        "signature_version": "v1",
        "digest": {
            "length": 334.0,
            "function_hash": "219203062469301619849027150853221467284"
        },
        "source": "https://github.com/sqlite/sqlite/commit/57f7ece78410a8aae86aa4625fb7556897db384c",
        "target": {
            "function": "whereIndexExprTransColumn",
            "file": "src/wherecode.c"
        }
    },
    {
        "id": "CVE-2019-19242-59c37900",
        "deprecated": false,
        "signature_type": "Line",
        "signature_version": "v1",
        "digest": {
            "threshold": 0.9,
            "line_hashes": [
                "73196936375848863988946647638199175336",
                "54061856683093212388608604271662140636",
                "187896069255515307547888284833172571856",
                "94603599993386840175216938376850118166"
            ]
        },
        "source": "https://github.com/sqlite/sqlite/commit/57f7ece78410a8aae86aa4625fb7556897db384c",
        "target": {
            "file": "src/expr.c"
        }
    },
    {
        "id": "CVE-2019-19242-a996fa2a",
        "deprecated": false,
        "signature_type": "Function",
        "signature_version": "v1",
        "digest": {
            "length": 16927.0,
            "function_hash": "112052855901138366623425549513834949919"
        },
        "source": "https://github.com/sqlite/sqlite/commit/57f7ece78410a8aae86aa4625fb7556897db384c",
        "target": {
            "function": "sqlite3ExprCodeTarget",
            "file": "src/expr.c"
        }
    }
]
source 
"https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2019-19242.json"