---
id: CVE-2019-19244
title: >-
  sqlite3Select in select.c in SQLite 3.30.1 allows a crash if a sub-select uses
  both DISTINCT and window functions, and also has certain ORDER BY usage.
summary: >-
  sqlite3Select in select.c in SQLite 3.30.1 allows a crash if a sub-select uses
  both DISTINCT and window functions, and also has certain ORDER BY usage.
severity: high
cvss: 7.5
cvssVector: 'CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H'
vendor: sqlite
product: sqlite
affected:
  - sqlite = 3.30.1
  - ubuntu_linux = 19.04
  - ubuntu_linux = 19.10
  - mysql_workbench <= 8.0.19
  - sinec_infrastructure_network_services < 1.0.1.1
patched:
  - sinec_infrastructure_network_services 1.0.1.1
published: '2019-11-25'
updated: '2026-10-08'
sourceUpdated: '2026-10-08T21:17:18.900'
source: NVD
sourceUrl: 'https://nvd.nist.gov/vuln/detail/CVE-2019-19244'
references:
  - url: 'https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf'
    label: cve@mitre.org
  - url: >-
      https://github.com/sqlite/sqlite/commit/e59c562b3f6894f84c715772c4b116d7b5c01348
    label: cve@mitre.org
  - url: 'https://usn.ubuntu.com/4205-1/'
    label: cve@mitre.org
  - url: 'https://www.oracle.com/security-alerts/cpuapr2020.html'
    label: cve@mitre.org
  - url: 'https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf'
    label: af854a3a-2127-422b-91ae-364da2661108
  - url: >-
      https://github.com/sqlite/sqlite/commit/e59c562b3f6894f84c715772c4b116d7b5c01348
    label: af854a3a-2127-422b-91ae-364da2661108
  - url: 'https://usn.ubuntu.com/4205-1/'
    label: af854a3a-2127-422b-91ae-364da2661108
  - url: 'https://www.oracle.com/security-alerts/cpuapr2020.html'
    label: af854a3a-2127-422b-91ae-364da2661108
tags:
  - nvd
epss: 0.03333
epssPercentile: 0.88283
ingestedAt: '2026-10-08T22:11:53.707Z'
---

## Overview

sqlite3Select in select.c in SQLite 3.30.1 allows a crash if a sub-select uses both DISTINCT and window functions, and also has certain ORDER BY usage.

## Affected

- `sqlite = 3.30.1`
- `ubuntu_linux = 19.04`
- `ubuntu_linux = 19.10`
- `mysql_workbench <= 8.0.19`
- `sinec_infrastructure_network_services < 1.0.1.1`

## Remediation

Upgrade past the affected range:

- `sinec_infrastructure_network_services 1.0.1.1`