CVE-2019-19242

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:14Z
Modified
2026-08-07T14:52:52Z
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":  [
        {
            "cpes":  [
                "cpe:2.3:a:oracle:mysql_workbench:*:*:*:*:*:*:*:*"
            ],
            "extracted_events":  [
                {
                    "last_affected":  "8.0.19"
                }
            ],
            "source":  "CPE_RANGE",
            "vendor_product":  "oracle:mysql_workbench"
        },
        {
            "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"
        },
        {
            "cpes":  [
                "cpe:2.3:o:redhat:enterprise_linux:8.0:*:*:*:*:*:*:*"
            ],
            "extracted_events":  [
                {
                    "introduced":  "8.0"
                },
                {
                    "last_affected":  "8.0"
                }
            ],
            "source":  "CPE_STRING",
            "vendor_product":  "redhat:enterprise_linux"
        }
    ]
}
References

Affected packages

Git / github.com/sqlite/sqlite

Affected ranges

Type
GIT
Repo
https://github.com/sqlite/sqlite
Events
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

source
"https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2019-19242.json"
vanir_signatures
[
    {
        "deprecated":  false,
        "digest":  {
            "line_hashes":  [
                "272171035038571025389595851029157703074",
                "267442456182522856045235945392506900464",
                "118415636789467465061053839391898871037",
                "206027221619297694965688112644458520441"
            ],
            "threshold":  0.9
        },
        "id":  "CVE-2019-19242-03a69a64",
        "signature_type":  "Line",
        "signature_version":  "v1",
        "source":  "https://github.com/sqlite/sqlite/commit/57f7ece78410a8aae86aa4625fb7556897db384c",
        "target":  {
            "file":  "src/wherecode.c"
        }
    },
    {
        "deprecated":  false,
        "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,
        "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"
        }
    }
]
vanir_signatures_modified
"2026-08-07T14:52:52Z"