NULL Pointer Dereference in SQLite 3.30.1 SELECT DISTINCT with LEFT JOIN and View

CVE-2019-19923 · HIGH Severity

CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H

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).

Learn more about our Cis Benchmark Audit For Microsoft Sql Server.