CVE-2019-19923

See a problem?
Please try reporting it to the source first.
Source
https://cve.org/CVERecord?id=CVE-2019-19923
Import Source
https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2019-19923.json
JSON Data
https://api.osv.dev/v1/vulns/CVE-2019-19923
Downstream
Related
Published
2019-12-24T16:15:11.260Z
Modified
2026-03-15T22:31:32.564600Z
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
Last affected
25e9591209453dc0904f8f0f1c4d5090c836e19b
Fixed
396afe6f6aa90a31303c183e11b2b2d4b7956b35
Database specific 
{
    "versions": [
        {
            "introduced": "0"
        },
        {
            "last_affected": "3.30.1"
        }
    ]
}

Affected versions

Other
cvs-to-fossil-cutover
experimental
fts3-refactor
version-1.*
version-1.0
version-1.0.1
version-1.0.10
version-1.0.12
version-1.0.13
version-1.0.14
version-1.0.15
version-1.0.16
version-1.0.17
version-1.0.18
version-1.0.19
version-1.0.20
version-1.0.21
version-1.0.22
version-1.0.23
version-1.0.24
version-1.0.25
version-1.0.26
version-1.0.27
version-1.0.28
version-1.0.29
version-1.0.3
version-1.0.30
version-1.0.31
version-1.0.32
version-1.0.4
version-1.0.5
version-1.0.8
version-1.0.9
version-2.*
version-2.0.0
version-2.0.1
version-2.0.2
version-2.0.3
version-2.0.4
version-2.0.5
version-2.0.6
version-2.0.7
version-2.0.8
version-2.1.0
version-2.1.1
version-2.1.2
version-2.1.3
version-2.1.4
version-2.1.5
version-2.1.6
version-2.1.7
version-2.2.0
version-2.2.1
version-2.2.2
version-2.2.3
version-2.2.4
version-2.2.5
version-2.3.0
version-2.3.1
version-2.3.2
version-2.3.3
version-2.4.0
version-2.4.1
version-2.4.10
version-2.4.11
version-2.4.12
version-2.4.2
version-2.4.3
version-2.4.4
version-2.4.5
version-2.4.6
version-2.4.7
version-2.4.8
version-2.4.9
version-2.5.0
version-2.5.1
version-2.5.2
version-2.5.3
version-2.5.4
version-2.5.5
version-2.5.6
version-2.6.0
version-2.6.1
version-2.6.2
version-2.6.3
version-2.7.0
version-2.7.1
version-2.7.2
version-2.7.3
version-2.7.4
version-2.7.5
version-2.7.6
version-2.8.0
version-2.8.1
version-2.8.10
version-2.8.11
version-2.8.12
version-2.8.13
version-2.8.2
version-2.8.3
version-2.8.4
version-2.8.5
version-2.8.6
version-2.8.7
version-2.8.8
version-2.8.9
version-3.*
version-3.0.0
version-3.0.1
version-3.0.2
version-3.0.3
version-3.0.4
version-3.0.5
version-3.0.6
version-3.0.7
version-3.0.8
version-3.1.0
version-3.1.1
version-3.1.2
version-3.1.3
version-3.1.3.1
version-3.1.4
version-3.1.5
version-3.1.6
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.2.0
version-3.2.1
version-3.2.2
version-3.2.3
version-3.2.4
version-3.2.5
version-3.2.6
version-3.2.7
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.3.0
version-3.3.1
version-3.3.10
version-3.3.11
version-3.3.12
version-3.3.13
version-3.3.14
version-3.3.15
version-3.3.16
version-3.3.17
version-3.3.2
version-3.3.3
version-3.3.4
version-3.3.5
version-3.3.6
version-3.3.7
version-3.3.8
version-3.3.9
version-3.30.0
version-3.30.1
version-3.4.0
version-3.4.1
version-3.4.2
version-3.5.0
version-3.5.1
version-3.5.2
version-3.5.3
version-3.5.4
version-3.5.5
version-3.5.6
version-3.5.7
version-3.5.8
version-3.5.9
version-3.6.0
version-3.6.1
version-3.6.10
version-3.6.11
version-3.6.12
version-3.6.13
version-3.6.14
version-3.6.15
version-3.6.16
version-3.6.17
version-3.6.18
version-3.6.19
version-3.6.2
version-3.6.20
version-3.6.21
version-3.6.22
version-3.6.23
version-3.6.3
version-3.6.4
version-3.6.5
version-3.6.6
version-3.6.7
version-3.6.8
version-3.6.9
version-3.7.0
version-3.7.1
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.3
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 
[
    {
        "digest": {
            "length": 5590.0,
            "function_hash": "330814732743507439986540557302774929713"
        },
        "signature_version": "v1",
        "deprecated": false,
        "signature_type": "Function",
        "id": "CVE-2019-19923-134f638b",
        "target": {
            "function": "flattenSubquery",
            "file": "src/select.c"
        },
        "source": "https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35"
    },
    {
        "digest": {
            "threshold": 0.9,
            "line_hashes": [
                "18104233075719913524635092338994927414",
                "231876987339024958742979482512986350232",
                "160277624447613318640615005514603846097",
                "8615964068487288384404672935273546870",
                "158745051547251140066162530979138522345",
                "183413588476470140403235573409063477251",
                "275703712529451719009097609695050452259"
            ]
        },
        "signature_version": "v1",
        "deprecated": false,
        "signature_type": "Line",
        "id": "CVE-2019-19923-5fb5e80f",
        "target": {
            "file": "src/select.c"
        },
        "source": "https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35"
    }
]
unresolved_ranges 
[
    {
        "events": [
            {
                "introduced": "0"
            },
            {
                "fixed": "1.0.1.1"
            }
        ]
    },
    {
        "events": [
            {
                "introduced": "0"
            },
            {
                "last_affected": "8.0.19"
            }
        ]
    },
    {
        "events": [
            {
                "introduced": "0"
            },
            {
                "last_affected": "9.0"
            }
        ]
    },
    {
        "events": [
            {
                "introduced": "0"
            },
            {
                "last_affected": "10.0"
            }
        ]
    },
    {
        "events": [
            {
                "introduced": "0"
            },
            {
                "last_affected": "6.0"
            }
        ]
    },
    {
        "events": [
            {
                "introduced": "0"
            },
            {
                "last_affected": "6.0"
            }
        ]
    },
    {
        "events": [
            {
                "introduced": "0"
            },
            {
                "last_affected": "6.0"
            }
        ]
    },
    {
        "events": [
            {
                "introduced": "0"
            },
            {
                "last_affected": "15.0-sp1"
            }
        ]
    },
    {
        "events": [
            {
                "introduced": "0"
            },
            {
                "last_affected": "15.1"
            }
        ]
    }
]
source 
"https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2019-19923.json"