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).
{
"unresolved_ranges": [
{
"source": "CPE_RANGE",
"cpes": [
"cpe:2.3:a:oracle:mysql_workbench:*:*:*:*:*:*:*:*"
],
"vendor_product": "oracle:mysql_workbench",
"extracted_events": [
{
"last_affected": "8.0.19"
}
]
},
{
"source": "CPE_RANGE",
"cpes": [
"cpe:2.3:a:siemens:sinec_infrastructure_network_services:*:*:*:*:*:*:*:*"
],
"vendor_product": "siemens:sinec_infrastructure_network_services",
"extracted_events": [
{
"fixed": "1.0.1.1"
}
]
},
{
"source": "CPE_STRING",
"cpes": [
"cpe:2.3:o:debian:debian_linux:10.0:*:*:*:*:*:*:*",
"cpe:2.3:o:debian:debian_linux:9.0:*:*:*:*:*:*:*"
],
"vendor_product": "debian:debian_linux",
"extracted_events": [
{
"introduced": "9.0"
},
{
"last_affected": "9.0"
},
{
"introduced": "10.0"
},
{
"last_affected": "10.0"
}
]
},
{
"source": "CPE_STRING",
"cpes": [
"cpe:2.3:a:opensuse:backports_sle:15.0:sp1:*:*:*:*:*:*"
],
"vendor_product": "opensuse:backports_sle",
"extracted_events": [
{
"introduced": "15.0-sp1"
},
{
"last_affected": "15.0-sp1"
}
]
},
{
"source": "CPE_STRING",
"cpes": [
"cpe:2.3:o:opensuse:leap:15.1:*:*:*:*:*:*:*"
],
"vendor_product": "opensuse:leap",
"extracted_events": [
{
"introduced": "15.1"
},
{
"last_affected": "15.1"
}
]
},
{
"source": "CPE_STRING",
"cpes": [
"cpe:2.3:o:redhat:enterprise_linux_desktop:6.0:*:*:*:*:*:*:*"
],
"vendor_product": "redhat:enterprise_linux_desktop",
"extracted_events": [
{
"introduced": "6.0"
},
{
"last_affected": "6.0"
}
]
},
{
"source": "CPE_STRING",
"cpes": [
"cpe:2.3:o:redhat:enterprise_linux_server:6.0:*:*:*:*:*:*:*"
],
"vendor_product": "redhat:enterprise_linux_server",
"extracted_events": [
{
"introduced": "6.0"
},
{
"last_affected": "6.0"
}
]
},
{
"source": "CPE_STRING",
"cpes": [
"cpe:2.3:o:redhat:enterprise_linux_workstation:6.0:*:*:*:*:*:*:*"
],
"vendor_product": "redhat:enterprise_linux_workstation",
"extracted_events": [
{
"introduced": "6.0"
},
{
"last_affected": "6.0"
}
]
},
{
"source": "CPE_STRING",
"cpes": [
"cpe:2.3:a:sqlite:sqlite:3.30.1:*:*:*:*:*:*:*"
],
"vendor_product": "sqlite:sqlite",
"extracted_events": [
{
"introduced": "3.30.1"
},
{
"last_affected": "3.30.1"
}
]
}
]
}"https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2019-19923.json"
[
{
"source": "https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35",
"signature_type": "Function",
"signature_version": "v1",
"digest": {
"function_hash": "330814732743507439986540557302774929713",
"length": 5590.0
},
"id": "CVE-2019-19923-134f638b",
"target": {
"function": "flattenSubquery",
"file": "src/select.c"
},
"deprecated": false
},
{
"source": "https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35",
"signature_type": "Line",
"signature_version": "v1",
"digest": {
"line_hashes": [
"18104233075719913524635092338994927414",
"231876987339024958742979482512986350232",
"160277624447613318640615005514603846097",
"8615964068487288384404672935273546870",
"158745051547251140066162530979138522345",
"183413588476470140403235573409063477251",
"275703712529451719009097609695050452259"
],
"threshold": 0.9
},
"id": "CVE-2019-19923-5fb5e80f",
"target": {
"file": "src/select.c"
},
"deprecated": false
}
]
"2026-08-04T15:57:39Z"