---
title: "CVE-2019-19923\n    | Ubuntu"
description: Ubuntu is an open source software operating system that runs from the
  desktop, to the cloud, to all your internet connected things.
url: https://ubuntu.com/security/CVE-2019-19923?format=md
keywords: index, follow
---

# CVE-2019-19923

Publication date 24 December 2019

Last updated 25 August 2025

---

Ubuntu priority

**Medium**

[Why this priority?](https://ubuntu.com/security/cves/about#priority )

## Cvss 3 Severity Score

**7.5 · High**

[Score breakdown](https://ubuntu.com/security/CVE-2019-19923?format=md#impact-score)

Toggle side navigation

## Description

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

## Status

Show unmaintained releases

| Package | Ubuntu Release | Status |
| --- | --- | --- |
| sqlite3 | 19.10 eoan | Fixed 3.29.0-2ubuntu0.2 |
| 19.04 disco | Ignored end of life |
| 18.04 LTS bionic | Fixed 3.22.0-1ubuntu0.3 |
| 16.04 LTS xenial | Not affected |
| 14.04 LTS trusty | Not affected |

---

* [How can I get the fixes?](https://ubuntu.com/security/cves/about#security)
* [What do statuses mean?](https://ubuntu.com/security/cves/about#statuses)
* [Patch details](https://ubuntu.com/security/CVE-2019-19923?format=md#patch-details)

### Patch details

For informational purposes only. We recommend not to cherry-pick updates. [How can I get the fixes?](https://ubuntu.com/security/cves/about#security)

| Package | Patch details |
| --- | --- |
| sqlite3 | * Upstream:   [396afe6](https://github.com/sqlite/sqlite/commit/396afe6f6aa90a31303c183e11b2b2d4b7956b35) |

## Severity score breakdown

CVSS version:
CVSS v3.0

**Base score**

7.5 · High

* Base metrics

  | Parameter | Value |
  | --- | --- |
  | Attack vector | Network |
  | Attack complexity | Low |
  | Privileges required | None |
  | User interaction | None |
  | Scope | Unchanged |
  | Confidentiality impact | None |
  | Integrity impact | None |
  | Availability impact | High |
* Scores

  | Parameter | Value |
  | --- | --- |
  | Base score | 7.5 · High |
  | Exploitability score | - |
  | Impact score | - |

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

## References

* [MITRE](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2019-19923)
* [NVD](https://nvd.nist.gov/vuln/detail/CVE-2019-19923)
* [Launchpad](https://launchpad.net/bugs/cve/CVE-2019-19923)
* [Debian](https://security-tracker.debian.org/tracker/CVE-2019-19923)

### Related Ubuntu Security Notices (USN)

+ [USN-4298-1](https://usn.ubuntu.com/USN-4298-1)
+ SQLite vulnerabilities
+ 10 March 2020

### Other references

* <https://www.cve.org/CVERecord?id=CVE-2019-19923>