CVE-2019-19923

Source
https://nvd.nist.gov/vuln/detail/CVE-2019-19923
Import Source
https://storage.googleapis.com/osv-test-cve-osv-conversion/osv-output/CVE-2019-19923.json
JSON Data
https://api.test.osv.dev/v1/vulns/CVE-2019-19923
Downstream
Related
Published
2019-12-24T16:15:11Z
Modified
2025-09-19T10:58:56.617075Z
Severity
  • 7.5 (High) CVSS_V3 - CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H CVSS Calculator
Summary
[none]
Details

flattenSubquery in select.c in SQLite 3.30.1 mishandles certain uses of SELECT DISTINCT involving a LEFT JOIN in which the right-hand side is a view. This can cause a NULL pointer dereference (or incorrect results).

References

Affected packages

Git / github.com/sqlite/sqlite

Affected ranges

Type
GIT
Repo
https://github.com/sqlite/sqlite
Events
Introduced
0 Unknown introduced commit / All previous commits are affected
Fixed

Affected versions

Other

cvs-to-fossil-cutover
experimental
fts3-refactor

version-3.*

version-3.10.0
version-3.11.0
version-3.11.1
version-3.12.0
version-3.13.0
version-3.14.0
version-3.15.0
version-3.16.0
version-3.19.0
version-3.19.1
version-3.19.2
version-3.21.0
version-3.22.0
version-3.23.0
version-3.23.1
version-3.24.0
version-3.25.0
version-3.26.0
version-3.27.0
version-3.28.0
version-3.29.0
version-3.30.0
version-3.6.10
version-3.6.15
version-3.7.10
version-3.7.11
version-3.7.12
version-3.7.12.1
version-3.7.13
version-3.7.14
version-3.7.15
version-3.7.16
version-3.7.16.1
version-3.7.16.2
version-3.7.17
version-3.7.2
version-3.7.4
version-3.7.5
version-3.7.6
version-3.7.6.1
version-3.7.7
version-3.7.8
version-3.7.9
version-3.8.0
version-3.8.1
version-3.8.10
version-3.8.10.1
version-3.8.11
version-3.8.11.1
version-3.8.2
version-3.8.3
version-3.8.4
version-3.8.4.1
version-3.8.5
version-3.8.6
version-3.8.7
version-3.8.7.1
version-3.8.8
version-3.8.9
version-3.9.0
version-3.9.1

Database specific

{
    "vanir_signatures": [
        {
            "signature_type": "Function",
            "digest": {
                "length": 5590.0,
                "function_hash": "330814732743507439986540557302774929713"
            },
            "source": "https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35",
            "deprecated": false,
            "id": "CVE-2019-19923-134f638b",
            "target": {
                "file": "src/select.c",
                "function": "flattenSubquery"
            },
            "signature_version": "v1"
        },
        {
            "signature_type": "Line",
            "digest": {
                "threshold": 0.9,
                "line_hashes": [
                    "18104233075719913524635092338994927414",
                    "231876987339024958742979482512986350232",
                    "160277624447613318640615005514603846097",
                    "8615964068487288384404672935273546870",
                    "158745051547251140066162530979138522345",
                    "183413588476470140403235573409063477251",
                    "275703712529451719009097609695050452259"
                ]
            },
            "source": "https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35",
            "deprecated": false,
            "id": "CVE-2019-19923-5fb5e80f",
            "target": {
                "file": "src/select.c"
            },
            "signature_version": "v1"
        }
    ]
}