{"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","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`","depth":"twilight","depthScore":42,"depthScoreParts":{"impact":41.3,"likelihood":0.7,"exploitation":0,"ransomware":0},"changes":[]}