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": [
{
"extracted_events": [
{
"last_affected": "9.0"
},
{
"last_affected": "10.0"
}
],
"vendor_product": "debian:debian_linux",
"source": "CPE_FIELD",
"cpes": [
"cpe:2.3:o:debian:debian_linux:10.0:*:*:*:*:*:*:*",
"cpe:2.3:o:debian:debian_linux:9.0:*:*:*:*:*:*:*"
]
},
{
"extracted_events": [
{
"last_affected": "15.0-sp1"
}
],
"vendor_product": "opensuse:backports_sle",
"source": "CPE_FIELD",
"cpes": [
"cpe:2.3:a:opensuse:backports_sle:15.0:sp1:*:*:*:*:*:*"
]
},
{
"extracted_events": [
{
"last_affected": "15.1"
}
],
"vendor_product": "opensuse:leap",
"source": "CPE_FIELD",
"cpes": [
"cpe:2.3:o:opensuse:leap:15.1:*:*:*:*:*:*:*"
]
},
{
"extracted_events": [
{
"last_affected": "8.0.19"
}
],
"vendor_product": "oracle:mysql_workbench",
"source": "CPE_FIELD",
"cpes": [
"cpe:2.3:a:oracle:mysql_workbench:*:*:*:*:*:*:*:*"
]
},
{
"extracted_events": [
{
"last_affected": "6.0"
}
],
"vendor_product": "redhat:enterprise_linux_desktop",
"source": "CPE_FIELD",
"cpes": [
"cpe:2.3:o:redhat:enterprise_linux_desktop:6.0:*:*:*:*:*:*:*"
]
},
{
"extracted_events": [
{
"last_affected": "6.0"
}
],
"vendor_product": "redhat:enterprise_linux_server",
"source": "CPE_FIELD",
"cpes": [
"cpe:2.3:o:redhat:enterprise_linux_server:6.0:*:*:*:*:*:*:*"
]
},
{
"extracted_events": [
{
"last_affected": "6.0"
}
],
"vendor_product": "redhat:enterprise_linux_workstation",
"source": "CPE_FIELD",
"cpes": [
"cpe:2.3:o:redhat:enterprise_linux_workstation:6.0:*:*:*:*:*:*:*"
]
},
{
"extracted_events": [
{
"fixed": "1.0.1.1"
}
],
"vendor_product": "siemens:sinec_infrastructure_network_services",
"source": "CPE_FIELD",
"cpes": [
"cpe:2.3:a:siemens:sinec_infrastructure_network_services:*:*:*:*:*:*:*:*"
]
}
]
}