CVE-2019-19923

Published: 24 December 2019

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

Priority

Medium

CVSS 3 base score: 7.5

Status

Package Release Status
sqlite3
Launchpad, Ubuntu, Debian
Upstream
Released (3.30.1+fossil191229-1)
Ubuntu 20.04 LTS (Focal Fossa) Not vulnerable
(3.31.1-1ubuntu1)
Ubuntu 18.04 LTS (Bionic Beaver)
Released (3.22.0-1ubuntu0.3)
Ubuntu 16.04 LTS (Xenial Xerus) Not vulnerable
(code not present)
Ubuntu 14.04 ESM (Trusty Tahr) Not vulnerable
(code not present)
Patches:
Upstream: https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35