{"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"},"slug":"CVE-2019-19244","body":"## Overview\n\nsqlite3Select 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.\n\n## Affected\n\n- `sqlite = 3.30.1`\n- `ubuntu_linux = 19.04`\n- `ubuntu_linux = 19.10`\n- `mysql_workbench <= 8.0.19`\n- `sinec_infrastructure_network_services < 1.0.1.1`\n\n## Remediation\n\nUpgrade past the affected range:\n\n- `sinec_infrastructure_network_services 1.0.1.1`\n\n## Vendor advisories\n\n- **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)","depth":"twilight","depthScore":42,"depthScoreParts":{"impact":41.3,"likelihood":0.7,"exploitation":0,"ransomware":0},"changes":[]}