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-10-15T10:48:27.188159Z
- 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
-
- http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00010.html
- http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00015.html
- http://lists.opensuse.org/opensuse-security-announce/2020-02/msg00025.html
- https://access.redhat.com/errata/RHSA-2020:0514
- https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf
- https://security.netapp.com/advisory/ntap-20200114-0003/
- https://www.debian.org/security/2020/dsa-4638
- https://www.oracle.com/security-alerts/cpuapr2020.html
- https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35
- https://usn.ubuntu.com/4298-1/
Affected packages
Git / github.com/sqlite/sqlite
Affected ranges
- Type
- GIT
- Repo
- https://github.com/sqlite/sqlite
- Events
-
Introduced0 Unknown introduced commit / All previous commits are affectedFixed
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
[
{
"deprecated": false,
"target": {
"function": "flattenSubquery",
"file": "src/select.c"
},
"signature_type": "Function",
"digest": {
"function_hash": "330814732743507439986540557302774929713",
"length": 5590.0
},
"source": "https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35",
"signature_version": "v1",
"id": "CVE-2019-19923-134f638b"
},
{
"deprecated": false,
"target": {
"file": "src/select.c"
},
"signature_type": "Line",
"digest": {
"threshold": 0.9,
"line_hashes": [
"18104233075719913524635092338994927414",
"231876987339024958742979482512986350232",
"160277624447613318640615005514603846097",
"8615964068487288384404672935273546870",
"158745051547251140066162530979138522345",
"183413588476470140403235573409063477251",
"275703712529451719009097609695050452259"
]
},
"source": "https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35",
"signature_version": "v1",
"id": "CVE-2019-19923-5fb5e80f"
}
]