---
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'
cwe:
  - CWE-20
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-14'
sourceUpdated: '2026-10-14T07:16:51.083'
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
  - url: 'https://cert-portal.siemens.com/productcert/html/ssa-389290.html'
    label: 0b142b55-0307-4c5a-b3c9-f314f3fb7c5e
  - url: 'https://cert-portal.siemens.com/productcert/html/ssa-398330.html'
    label: 0b142b55-0307-4c5a-b3c9-f314f3fb7c5e
  - url: >-
      https://security.access.redhat.com/data/csaf/v2/vex/2019/cve-2019-19244.json
  - url: 'https://access.redhat.com/security/cve/CVE-2019-19244'
  - url: 'https://bugzilla.redhat.com/show_bug.cgi?id=1777945'
  - url: 'https://www.cve.org/CVERecord?id=CVE-2019-19244'
  - url: 'https://nvd.nist.gov/vuln/detail/CVE-2019-19244'
tags:
  - nvd
  - csaf
  - vex
  - red-hat
  - cve.org
epss: 0.03593
epssPercentile: 0.8938
ingestedAt: '2026-10-08T22:11:53.707Z'
ssvc:
  exploitation: none
  automatable: 'yes'
  technicalImpact: partial
  timestamp: '2026-10-08T20:56:37.514251Z'
---

## 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`

## Vendor advisories

- **Red Hat VEX** · Low · affected: Red Hat Enterprise Linux 5, Red Hat Enterprise Linux 6, Red Hat Enterprise Linux 7, Red Hat Enterprise Linux 8 · no fix planned: Red Hat Enterprise Linux 5, Red Hat Enterprise Linux 6, Red Hat Enterprise Linux 7, Red Hat Enterprise Linux 8 · updated 2026-10-08 · [vex](https://security.access.redhat.com/data/csaf/v2/vex/2019/cve-2019-19244.json)