{"id":"CVE-2019-19244","aliases":["ALPINE-CVE-2019-19244","BELL-CVE-2019-19244","CLSA-2026-1785562610","CLSA-2026-1785563058","DEBIAN-CVE-2019-19244","EUVD-2019-8870","GHSA-pfjf-vfqg-5r4q","MGASA-2020-0070","SUSE-SU-2021:2320-1","SUSE-SU-2021:3215-1","openSUSE-SU-2021:1058-1","openSUSE-SU-2021:2320-1"],"status":"published","title":"sqlite3Select in select.c in SQLite 3.30.1 allows a crash if a sub-select uses both DISTINCT and...","description":"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":{"version":"3.1","score":7.5,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H","level":"high","assessor":"primary","from":"nvd"},"epss":{"day":"2026-11-09","score":0.03593,"percentile":0.89523,"model":"v2026.06.15"},"facts":{"in_kev":false,"known_exploited":false,"public_exploit":false,"fix_available":true},"published":"2019-11-25T19:32:38Z","modified":"2026-10-26T09:43:48Z","fixes":[{"ecosystem":"Alpine:v3.10","package":"sqlite","fixed_in":["3.28.0-r2"],"sources":["osv"]},{"ecosystem":"Alpine:v3.11","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.12","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.13","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.14","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.15","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.16","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.17","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.18","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.19","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.20","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.21","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.22","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.23","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.24","package":"sqlite","fixed_in":["3.30.1-r1"],"sources":["osv"]},{"ecosystem":"Alpine:v3.8","package":"sqlite","fixed_in":["3.25.3-r3"],"sources":["osv"]},{"ecosystem":"Alpine:v3.9","package":"sqlite","fixed_in":["3.28.0-r2"],"sources":["osv"]},{"ecosystem":"Debian:12","package":"sqlite3","fixed_in":["3.30.1+fossil191229-1"],"sources":["osv"]},{"ecosystem":"Debian:13","package":"sqlite3","fixed_in":["3.30.1+fossil191229-1"],"sources":["osv"]},{"ecosystem":"Debian:14","package":"sqlite3","fixed_in":["3.30.1+fossil191229-1"],"sources":["osv"]}],"affected":[{"source":"osv","ecosystem":"Alpine:v3.10","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.28.0-r2"}]}]},{"source":"osv","ecosystem":"Alpine:v3.11","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.12","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.13","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.14","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.15","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.16","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.17","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.18","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.19","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.20","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.21","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.22","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.23","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.24","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1-r1"}]}]},{"source":"osv","ecosystem":"Alpine:v3.8","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.25.3-r3"}]}]},{"source":"osv","ecosystem":"Alpine:v3.9","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.28.0-r2"}]}]},{"source":"osv","ecosystem":"TuxCare:CentOS:8.4","package":"lemon","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.26.0-15.el8.tuxcare.els9"}]}],"bundled":3},{"source":"osv","ecosystem":"TuxCare:CentOS:8.4","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.26.0-15.el8.tuxcare.els9"}]}],"bundled":3},{"source":"osv","ecosystem":"TuxCare:CentOS:8.4","package":"sqlite-analyzer","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.26.0-15.el8.tuxcare.els9"}]}],"bundled":3},{"source":"osv","ecosystem":"TuxCare:CentOS:8.4","package":"sqlite-devel","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.26.0-15.el8.tuxcare.els9"}]}],"bundled":3},{"source":"osv","ecosystem":"TuxCare:CentOS:8.4","package":"sqlite-doc","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.26.0-15.el8.tuxcare.els9"}]}],"bundled":3},{"source":"osv","ecosystem":"TuxCare:CentOS:8.4","package":"sqlite-libs","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.26.0-15.el8.tuxcare.els9"}]}],"bundled":3},{"source":"osv","ecosystem":"TuxCare:CentOS:8.4","package":"sqlite-tcl","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.26.0-15.el8.tuxcare.els9"}]}],"bundled":3},{"source":"osv","ecosystem":"TuxCare:CentOS:8.5","package":"lemon","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.26.0-15.el8.tuxcare.els9"}]}],"bundled":3},{"source":"osv","ecosystem":"TuxCare:CentOS:8.5","package":"sqlite","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.26.0-15.el8.tuxcare.els9"}]}],"bundled":3},{"source":"osv","ecosystem":"TuxCare:CentOS:8.5","package":"sqlite-analyzer","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.26.0-15.el8.tuxcare.els9"}]}],"bundled":3},{"source":"osv","ecosystem":"TuxCare:CentOS:8.5","package":"sqlite-devel","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.26.0-15.el8.tuxcare.els9"}]}],"bundled":3},{"source":"osv","ecosystem":"TuxCare:CentOS:8.5","package":"sqlite-doc","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.26.0-15.el8.tuxcare.els9"}]}],"bundled":3},{"source":"osv","ecosystem":"TuxCare:CentOS:8.5","package":"sqlite-libs","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.26.0-15.el8.tuxcare.els9"}]}],"bundled":3},{"source":"osv","ecosystem":"TuxCare:CentOS:8.5","package":"sqlite-tcl","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.26.0-15.el8.tuxcare.els9"}]}],"bundled":3},{"source":"osv","ecosystem":"Debian:12","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1+fossil191229-1"}]}]},{"source":"osv","ecosystem":"Debian:13","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1+fossil191229-1"}]}]},{"source":"osv","ecosystem":"Debian:14","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.30.1+fossil191229-1"}]}]},{"source":"osv","ecosystem":"Mageia:7","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.31.1-1.mga7"}]}],"bundled":9},{"source":"osv","ecosystem":"SUSE:Linux Enterprise Module for Basesystem 15 SP2","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-3.12.1"}]}],"bundled":21},{"source":"osv","ecosystem":"SUSE:Linux Enterprise Module for Basesystem 15 SP3","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-3.12.1"}]}],"bundled":21},{"source":"osv","ecosystem":"SUSE:Linux Enterprise High Performance Computing 15-ESPOS","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-3.12.1"}]}],"bundled":21},{"source":"osv","ecosystem":"SUSE:Linux Enterprise High Performance Computing 15-LTSS","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-3.12.1"}]}],"bundled":21},{"source":"osv","ecosystem":"SUSE:Linux Enterprise High Performance Computing 15 SP1-ESPOS","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-3.12.1"}]}],"bundled":21},{"source":"osv","ecosystem":"SUSE:Linux Enterprise High Performance Computing 15 SP1-LTSS","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-3.12.1"}]}],"bundled":21},{"source":"osv","ecosystem":"SUSE:Linux Enterprise Server 15-LTSS","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-3.12.1"}]}],"bundled":21},{"source":"osv","ecosystem":"SUSE:Linux Enterprise Server 15 SP1-BCL","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-3.12.1"}]}],"bundled":21},{"source":"osv","ecosystem":"SUSE:Linux Enterprise Server 15 SP1-LTSS","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-3.12.1"}]}],"bundled":21},{"source":"osv","ecosystem":"SUSE:Linux Enterprise Server for SAP Applications 15","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-3.12.1"}]}],"bundled":21},{"source":"osv","ecosystem":"SUSE:Linux Enterprise Server for SAP Applications 15 SP1","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-3.12.1"}]}],"bundled":21},{"source":"osv","ecosystem":"SUSE:Manager Proxy 4.0","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-3.12.1"}]}],"bundled":21},{"source":"osv","ecosystem":"SUSE:Manager Retail Branch Server 4.0","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-3.12.1"}]}],"bundled":21},{"source":"osv","ecosystem":"SUSE:Manager Server 4.0","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-3.12.1"}]}],"bundled":21},{"source":"osv","ecosystem":"SUSE:Linux Enterprise Micro 5.0","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-3.12.1"}]}],"bundled":21},{"source":"osv","ecosystem":"SUSE:Enterprise Storage 6","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-3.12.1"}]}],"bundled":21},{"source":"osv","ecosystem":"SUSE:HPE Helion OpenStack 8","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-9.18.1"}]}],"bundled":28},{"source":"osv","ecosystem":"SUSE:OpenStack Cloud 8","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-9.18.1"}]}],"bundled":28},{"source":"osv","ecosystem":"SUSE:OpenStack Cloud 9","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-9.18.1"}]}],"bundled":28},{"source":"osv","ecosystem":"SUSE:OpenStack Cloud Crowbar 8","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-9.18.1"}]}],"bundled":28},{"source":"osv","ecosystem":"SUSE:OpenStack Cloud Crowbar 9","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-9.18.1"}]}],"bundled":28},{"source":"osv","ecosystem":"SUSE:Linux Enterprise Server for SAP Applications 12 SP3","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-9.18.1"}]}],"bundled":28},{"source":"osv","ecosystem":"SUSE:Linux Enterprise Server for SAP Applications 12 SP4","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-9.18.1"}]}],"bundled":28},{"source":"osv","ecosystem":"SUSE:Linux Enterprise Software Development Kit 12 SP5","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-9.18.1"}]}],"bundled":28},{"source":"osv","ecosystem":"SUSE:Linux Enterprise Server 12 SP2-BCL","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-9.18.1"}]}],"bundled":28},{"source":"osv","ecosystem":"SUSE:Linux Enterprise Server 12 SP3-LTSS","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-9.18.1"}]}],"bundled":28},{"source":"osv","ecosystem":"SUSE:Linux Enterprise Server 12 SP3-BCL","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-9.18.1"}]}],"bundled":28},{"source":"osv","ecosystem":"SUSE:Linux Enterprise Server 12 SP4-LTSS","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-9.18.1"}]}],"bundled":28},{"source":"osv","ecosystem":"SUSE:Linux Enterprise Server 12 SP5","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-9.18.1"}]}],"bundled":28},{"source":"osv","ecosystem":"SUSE:Linux Enterprise Server for SAP Applications 12 SP5","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-9.18.1"}]}],"bundled":28},{"source":"osv","ecosystem":"openSUSE:Leap 15.2","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-lp152.4.3.1"}]}],"bundled":21},{"source":"osv","ecosystem":"openSUSE:Leap 15.3","package":"sqlite3","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"3.36.0-3.12.1"}]}],"bundled":21}],"products":[{"vendor":"canonical","product":"ubuntu_linux"},{"vendor":"oracle","product":"mysql_workbench"},{"vendor":"siemens","product":"simatic s7-1500 cpu 1518-4 pn/dp mfp"},{"vendor":"siemens","product":"simatic s7-1500 cpu 1518f-4 pn/dp mfp"},{"vendor":"siemens","product":"sinec_infrastructure_network_services"},{"vendor":"siemens","product":"siplus s7-1500 cpu 1518-4 pn/dp mfp"},{"vendor":"sqlite","product":"sqlite"}],"references":[{"url":"https://github.com/sqlite/sqlite/commit/e59c562b3f6894f84c715772c4b116d7b5c01348","tags":["x_refsource_MISC","x_transferred","Patch","fix"]},{"url":"https://usn.ubuntu.com/4205-1/","tags":["vendor-advisory","x_refsource_UBUNTU","x_transferred","Third Party Advisory","advisory","web"]},{"url":"https://www.oracle.com/security-alerts/cpuapr2020.html","tags":["x_refsource_MISC","x_transferred","Patch","Third Party Advisory","fix"]},{"url":"https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf","tags":["x_refsource_CONFIRM","x_transferred","Third Party Advisory","advisory"]},{"url":"https://cert-portal.siemens.com/productcert/html/ssa-389290.html","tags":["web"]},{"url":"https://cert-portal.siemens.com/productcert/html/ssa-398330.html","tags":["web"]},{"url":"https://nvd.nist.gov/vuln/detail/CVE-2019-19244","tags":["advisory"]},{"url":"https://usn.ubuntu.com/4205-1"},{"url":"https://github.com/advisories/GHSA-pfjf-vfqg-5r4q"},{"url":"https://security.alpinelinux.org/vuln/CVE-2019-19244","tags":["advisory"]},{"url":"https://docs.bell-sw.com/security/cves/CVE-2019-19244","tags":["advisory"]},{"url":"https://errata.tuxcare.com/els_os/centos8.4els/CLSA-2026-1785562610.html","tags":["advisory"]},{"url":"https://nvd.nist.gov/vuln/detail/CVE-2019-9936","tags":["advisory"]},{"url":"https://nvd.nist.gov/vuln/detail/CVE-2019-9937","tags":["advisory"]},{"url":"https://errata.tuxcare.com/els_os/centos8.5els/CLSA-2026-1785563058.html","tags":["advisory"]},{"url":"https://security-tracker.debian.org/tracker/CVE-2019-19244","tags":["advisory"]},{"url":"https://advisories.mageia.org/MGASA-2020-0070.html","tags":["advisory"]},{"url":"https://bugs.mageia.org/show_bug.cgi?id=26104","tags":["report"]},{"url":"https://www.sqlite.org/releaselog/3_29_0.html","tags":["web"]},{"url":"https://www.sqlite.org/releaselog/3_30_0.html","tags":["web"]},{"url":"https://www.sqlite.org/releaselog/3_30_1.html","tags":["web"]},{"url":"https://www.sqlite.org/releaselog/3_31_0.html","tags":["web"]},{"url":"https://www.sqlite.org/releaselog/3_31_1.html","tags":["web"]},{"url":"https://chromereleases.googleblog.com/2019/12/stable-channel-update-for-desktop.html","tags":["web"]},{"url":"https://www.suse.com/support/update/announcement/2021/suse-su-20212320-1/","tags":["advisory"]},{"url":"https://bugzilla.suse.com/1157818","tags":["report"]},{"url":"https://bugzilla.suse.com/1158812","tags":["report"]},{"url":"https://bugzilla.suse.com/1158958","tags":["report"]},{"url":"https://bugzilla.suse.com/1158959","tags":["report"]},{"url":"https://bugzilla.suse.com/1158960","tags":["report"]},{"url":"https://bugzilla.suse.com/1159491","tags":["report"]},{"url":"https://bugzilla.suse.com/1159715","tags":["report"]},{"url":"https://bugzilla.suse.com/1159847","tags":["report"]},{"url":"https://bugzilla.suse.com/1159850","tags":["report"]},{"url":"https://bugzilla.suse.com/1160309","tags":["report"]},{"url":"https://bugzilla.suse.com/1160438","tags":["report"]},{"url":"https://bugzilla.suse.com/1160439","tags":["report"]},{"url":"https://bugzilla.suse.com/1164719","tags":["report"]},{"url":"https://bugzilla.suse.com/1172091","tags":["report"]},{"url":"https://bugzilla.suse.com/1172115","tags":["report"]},{"url":"https://bugzilla.suse.com/1172234","tags":["report"]},{"url":"https://bugzilla.suse.com/1172236","tags":["report"]},{"url":"https://bugzilla.suse.com/1172240","tags":["report"]},{"url":"https://bugzilla.suse.com/1173641","tags":["report"]},{"url":"https://bugzilla.suse.com/928700","tags":["report"]},{"url":"https://bugzilla.suse.com/928701","tags":["report"]},{"url":"https://www.suse.com/security/cve/CVE-2015-3414","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2015-3415","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2019-19244","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2019-19317","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2019-19603","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2019-19645","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2019-19646","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2019-19880","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2019-19923","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2019-19924","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2019-19925","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2019-19926","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2019-19959","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2019-20218","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2020-13434","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2020-13435","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2020-13630","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2020-13631","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2020-13632","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2020-15358","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2020-9327","tags":["web"]},{"url":"https://www.suse.com/support/update/announcement/2021/suse-su-20213215-1/","tags":["advisory"]},{"url":"https://www.suse.com/security/cve/CVE-2016-6153","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2017-10989","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2017-2518","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2018-20346","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2018-8740","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2019-16168","tags":["web"]},{"url":"https://www.suse.com/security/cve/CVE-2019-8457","tags":["web"]},{"url":"https://lists.opensuse.org/archives/list/security-announce@lists.opensuse.org/thread/SB6Z44NRR3L5O3VXGRWAB7XUKDS4TMFZ/","tags":["advisory"]},{"url":"https://lists.opensuse.org/archives/list/security-announce@lists.opensuse.org/thread/JD4EZ74IZ57MKTDKDVIUAIG6VCAEKMD5/","tags":["advisory"]}],"sources":{"cve":[{"id":"CVE-2019-19244","description":"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.","status":"published","published":"2019-11-25T19:32:38Z","modified":"2026-10-14T07:06:27.34Z","updated_at":"2026-11-02T14:20:20.74896Z"}],"euvd":[{"id":"EUVD-2019-8870","description":"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.","status":"published","published":"2019-11-25T19:32:38Z","modified":"2026-10-14T07:06:27Z","updated_at":"2026-11-02T17:27:17.374818Z"}],"ghsa":[{"id":"GHSA-pfjf-vfqg-5r4q","title":"sqlite3Select in select.c in SQLite 3.30.1 allows a crash if a sub-select uses both DISTINCT and...","description":"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.","status":"published","published":"2022-05-24T17:01:59Z","modified":"2026-10-14T09:32:29Z","cvss":[{"version":"3.1","score":7.5,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H","level":"high"}],"updated_at":"2026-11-02T15:13:23.530725Z"}],"nvd":[{"id":"CVE-2019-19244","description":"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.","status":"published","published":"2019-11-25T20:15:11.407Z","modified":"2026-10-14T07:16:51.083Z","cvss":[{"version":"3.1","score":7.5,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H","level":"high","assessor":"primary"},{"version":"2.0","score":5,"vector":"AV:N/AC:L/Au:N/C:N/I:N/A:P","level":"medium","assessor":"primary"}],"updated_at":"2026-11-02T14:05:38.993437Z"}],"osv":[{"id":"ALPINE-CVE-2019-19244","description":"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.","status":"published","published":"2019-11-25T20:15:11.407Z","modified":"2026-09-21T06:17:52.507864202Z","cvss":[{"version":"3.1","score":7.5,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H","level":"high"}],"updated_at":"2026-11-02T15:27:47.663013Z"},{"id":"BELL-CVE-2019-19244","title":"CVE-2019-19244 does not affect BellSoft software","status":"withdrawn","published":"2023-08-31T12:13:32.673221Z","modified":"2026-01-26T09:47:05.232093Z","cvss":[{"version":"3.1","score":7.5,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H","level":"high"}],"updated_at":"2026-11-02T15:28:15.340685Z"},{"id":"CVE-2019-19244","description":"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.","status":"published","published":"2019-11-25T20:15:11.407Z","modified":"2026-10-20T13:46:42.772945679Z","cvss":[{"version":"3.1","score":7.5,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H","level":"high"}],"updated_at":"2026-11-02T15:44:12.010761Z"},{"id":"DEBIAN-CVE-2019-19244","description":"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.","status":"published","published":"2019-11-25T20:15:11.407Z","modified":"2026-10-15T07:47:35.222440559Z","cvss":[{"version":"3.1","score":7.5,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H","level":"high"}],"updated_at":"2026-11-02T15:45:31.867036Z"},{"id":"CLSA-2026-1785562610","title":"sqlite: Fix of 3 CVEs","description":"- CVE-2019-9937: fix fts5 index corruption when reads and writes are\n  interleaved within a single transaction\n- CVE-2019-9936: fix heap-based buffer over-read in fts5HashEntrySort()\n  when running fts5 prefix queries inside a transaction\n- CVE-2019-19244: fix invalid Mem object when a sub-select uses both\n  DISTINCT and window functions with an ORDER BY matching its select list","status":"published","published":"2026-08-01T05:37:07Z","modified":"2026-10-26T09:43:48.953876945Z","updated_at":"2026-11-02T15:43:46.850893Z"},{"id":"CLSA-2026-1785563058","title":"sqlite: Fix of 3 CVEs","description":"- CVE-2019-9937: fix fts5 index corruption when reads and writes are\n  interleaved within a single transaction\n- CVE-2019-9936: fix heap-based buffer over-read in fts5HashEntrySort()\n  when running fts5 prefix queries inside a transaction\n- CVE-2019-19244: fix invalid Mem object when a sub-select uses both\n  DISTINCT and window functions with an ORDER BY matching its select list","status":"published","published":"2026-08-01T05:44:31Z","modified":"2026-10-26T09:43:37.54698132Z","updated_at":"2026-11-02T15:43:46.850893Z"},{"id":"MGASA-2020-0070","title":"Updated sqlite3 packages fix security vulnerabilities","description":"Updated sqlite3 packages fix security vulnerabilities:\n\nAn out of bounds write flaw (CVE-2019-13734), insufficient data validation\nflaw (CVE-2019-13750), uninitialized use flaw (CVE-2019-13751), and out of\nbounds read flaws (CVE-2019-13752, CVE-2019-13753) in SQLite before 3.31.0.\n\nIt was discovered that SQLite incorrectly handled certain schemas. An\nattacker could possibly use this issue to cause a denial of service\n(CVE-2019-16168).\n\nIt was discovered that SQLite incorrectly handled certain schemas. An\nattacker could possibly use this issue to mishandles some expressions\n(CVE-2019-19242).\n\nIt was discovered that SQLite incorrectly handled certain queries. An\nattacker could possibly use this issue to execute arbitrary code\n(CVE-2019-19244).\n\nexprListAppendList in window.c in SQLite 3.30.1 allows attackers to trigger\nan invalid pointer dereference because constant integer values in ORDER BY\nclauses of window definitions are mishandled (CVE-2019-19880).\n\nFor other changes in this update, see the referenced releaaselogs.\n","status":"published","published":"2020-01-30T18:28:34Z","modified":"2026-04-16T04:44:19.743145533Z","updated_at":"2026-11-02T15:49:41.151324Z"},{"id":"openSUSE-SU-2021:1058-1","title":"Security update for sqlite3","description":"This update for sqlite3 fixes the following issues:\n\n- Update to version 3.36.0\n- CVE-2020-15358: heap-based buffer overflow in multiSelectOrderBy due to mishandling of query-flattener\n  optimization (bsc#1173641)\n- CVE-2020-9327: NULL pointer dereference and segmentation fault because of generated column optimizations in\n  isAuxiliaryVtabOperator (bsc#1164719)\n- CVE-2019-20218: selectExpander in select.c proceeds with WITH stack unwinding even after a parsing error (bsc#1160439)\n- CVE-2019-19959: memory-management error via ext/misc/zipfile.c involving embedded '\\0' input (bsc#1160438)\n- CVE-2019-19923: improper handling  of  certain uses of SELECT DISTINCT in flattenSubquery may lead to null pointer\n  dereference (bsc#1160309)\n- CVE-2019-19924: improper error handling in sqlite3WindowRewrite() (bsc#1159850)\n- CVE-2019-19925: improper handling of NULL pathname during an update of a ZIP archive (bsc#1159847)\n- CVE-2019-19926: improper handling  of certain errors during parsing  multiSelect in select.c (bsc#1159715)\n- CVE-2019-19880: exprListAppendList in window.c allows attackers to trigger an invalid pointer dereference\n  (bsc#1159491)\n- CVE-2019-19603: during handling of CREATE TABLE and CREATE VIEW statements, does not consider confusion with\n  a shadow table name (bsc#1158960)\n- CVE-2019-19646: pragma.c mishandles NOT NULL in an integrity_check PRAGMA command in certain cases of generated\n  columns (bsc#1158959)\n- CVE-2019-19645: alter.c allows attackers to trigger infinite recursion via certain types of self-referential views\n  in conjunction with ALTER TABLE statements (bsc#1158958)\n- CVE-2019-19317: lookupName in resolve.c omits bits from the colUsed bitmask in the case of a generated column,\n  which allows attackers to cause a denial of service (bsc#1158812)\n- CVE-2019-19244: sqlite3,sqlite2,sqlite: The function sqlite3Select in select.c allows a crash if a\n  sub-select uses both DISTINCT and window functions, and also has certain ORDER BY usage (bsc#1157818)\n- CVE-2015-3415: sqlite3VdbeExec comparison operator vulnerability (bsc#928701)\n- CVE-2015-3414: sqlite3,sqlite2: dequoting of collation-sequence names (bsc#928700)\n- CVE-2020-13434: integer overflow in sqlite3_str_vappendf (bsc#1172115)\n- CVE-2020-13630: (bsc#1172234: use-after-free in fts3EvalNextRow\n- CVE-2020-13631: virtual table allowed to be renamed to one of its shadow tables (bsc#1172236)\n- CVE-2020-13632: NULL pointer dereference via crafted matchinfo() query (bsc#1172240)\n- CVE-2020-13435: Malicious SQL statements could have crashed the process that is running SQLite (bsc#1172091)\n\nThis update was imported from the SUSE:SLE-15:Update update project.","status":"published","published":"2021-07-19T21:03:43Z","modified":"2026-02-04T04:00:16.04766Z","updated_at":"2026-11-02T16:58:31.879684Z"},{"id":"openSUSE-SU-2021:2320-1","title":"Security update for sqlite3","description":"This update for sqlite3 fixes the following issues:\n\n- Update to version 3.36.0\n- CVE-2020-15358: heap-based buffer overflow in multiSelectOrderBy due to mishandling of query-flattener\n  optimization (bsc#1173641)\n- CVE-2020-9327: NULL pointer dereference and segmentation fault because of generated column optimizations in\n  isAuxiliaryVtabOperator (bsc#1164719)\n- CVE-2019-20218: selectExpander in select.c proceeds with WITH stack unwinding even after a parsing error (bsc#1160439)\n- CVE-2019-19959: memory-management error via ext/misc/zipfile.c involving embedded '\\0' input (bsc#1160438)\n- CVE-2019-19923: improper handling  of  certain uses of SELECT DISTINCT in flattenSubquery may lead to null pointer\n  dereference (bsc#1160309)\n- CVE-2019-19924: improper error handling in sqlite3WindowRewrite() (bsc#1159850)\n- CVE-2019-19925: improper handling of NULL pathname during an update of a ZIP archive (bsc#1159847)\n- CVE-2019-19926: improper handling  of certain errors during parsing  multiSelect in select.c (bsc#1159715)\n- CVE-2019-19880: exprListAppendList in window.c allows attackers to trigger an invalid pointer dereference\n  (bsc#1159491)\n- CVE-2019-19603: during handling of CREATE TABLE and CREATE VIEW statements, does not consider confusion with\n  a shadow table name (bsc#1158960)\n- CVE-2019-19646: pragma.c mishandles NOT NULL in an integrity_check PRAGMA command in certain cases of generated\n  columns (bsc#1158959)\n- CVE-2019-19645: alter.c allows attackers to trigger infinite recursion via certain types of self-referential views\n  in conjunction with ALTER TABLE statements (bsc#1158958)\n- CVE-2019-19317: lookupName in resolve.c omits bits from the colUsed bitmask in the case of a generated column,\n  which allows attackers to cause a denial of service (bsc#1158812)\n- CVE-2019-19244: sqlite3,sqlite2,sqlite: The function sqlite3Select in select.c allows a crash if a\n  sub-select uses both DISTINCT and window functions, and also has certain ORDER BY usage (bsc#1157818)\n- CVE-2015-3415: sqlite3VdbeExec comparison operator vulnerability (bsc#928701)\n- CVE-2015-3414: sqlite3,sqlite2: dequoting of collation-sequence names (bsc#928700)\n- CVE-2020-13434: integer overflow in sqlite3_str_vappendf (bsc#1172115)\n- CVE-2020-13630: (bsc#1172234: use-after-free in fts3EvalNextRow\n- CVE-2020-13631: virtual table allowed to be renamed to one of its shadow tables (bsc#1172236)\n- CVE-2020-13632: NULL pointer dereference via crafted matchinfo() query (bsc#1172240)\n- CVE-2020-13435: Malicious SQL statements could have crashed the process that is running SQLite (bsc#1172091)\n","status":"published","published":"2021-07-14T15:01:28Z","modified":"2026-02-04T02:42:44.831245Z","updated_at":"2026-11-02T16:58:32.266854Z"},{"id":"SUSE-SU-2021:2320-1","title":"Security update for sqlite3","description":"This update for sqlite3 fixes the following issues:\n\n- Update to version 3.36.0\n- CVE-2020-15358: heap-based buffer overflow in multiSelectOrderBy due to mishandling of query-flattener\n  optimization (bsc#1173641)\n- CVE-2020-9327: NULL pointer dereference and segmentation fault because of generated column optimizations in\n  isAuxiliaryVtabOperator (bsc#1164719)\n- CVE-2019-20218: selectExpander in select.c proceeds with WITH stack unwinding even after a parsing error (bsc#1160439)\n- CVE-2019-19959: memory-management error via ext/misc/zipfile.c involving embedded '\\0' input (bsc#1160438)\n- CVE-2019-19923: improper handling  of  certain uses of SELECT DISTINCT in flattenSubquery may lead to null pointer\n  dereference (bsc#1160309)\n- CVE-2019-19924: improper error handling in sqlite3WindowRewrite() (bsc#1159850)\n- CVE-2019-19925: improper handling of NULL pathname during an update of a ZIP archive (bsc#1159847)\n- CVE-2019-19926: improper handling  of certain errors during parsing  multiSelect in select.c (bsc#1159715)\n- CVE-2019-19880: exprListAppendList in window.c allows attackers to trigger an invalid pointer dereference\n  (bsc#1159491)\n- CVE-2019-19603: during handling of CREATE TABLE and CREATE VIEW statements, does not consider confusion with\n  a shadow table name (bsc#1158960)\n- CVE-2019-19646: pragma.c mishandles NOT NULL in an integrity_check PRAGMA command in certain cases of generated\n  columns (bsc#1158959)\n- CVE-2019-19645: alter.c allows attackers to trigger infinite recursion via certain types of self-referential views\n  in conjunction with ALTER TABLE statements (bsc#1158958)\n- CVE-2019-19317: lookupName in resolve.c omits bits from the colUsed bitmask in the case of a generated column,\n  which allows attackers to cause a denial of service (bsc#1158812)\n- CVE-2019-19244: sqlite3,sqlite2,sqlite: The function sqlite3Select in select.c allows a crash if a\n  sub-select uses both DISTINCT and window functions, and also has certain ORDER BY usage (bsc#1157818)\n- CVE-2015-3415: sqlite3VdbeExec comparison operator vulnerability (bsc#928701)\n- CVE-2015-3414: sqlite3,sqlite2: dequoting of collation-sequence names (bsc#928700)\n- CVE-2020-13434: integer overflow in sqlite3_str_vappendf (bsc#1172115)\n- CVE-2020-13630: (bsc#1172234: use-after-free in fts3EvalNextRow\n- CVE-2020-13631: virtual table allowed to be renamed to one of its shadow tables (bsc#1172236)\n- CVE-2020-13632: NULL pointer dereference via crafted matchinfo() query (bsc#1172240)\n- CVE-2020-13435: Malicious SQL statements could have crashed the process that is running SQLite (bsc#1172091)\n","status":"published","published":"2021-07-14T15:01:56Z","modified":"2026-02-04T02:48:22.827579Z","updated_at":"2026-11-02T15:53:49.138643Z"},{"id":"SUSE-SU-2021:3215-1","title":"Security update for sqlite3","description":"This update for sqlite3 fixes the following issues:\n\nsqlite3 is sync version 3.36.0 from Factory (jsc#SLE-16032).\n\nThe following CVEs have been fixed in upstream releases up to\nthis point, but were not mentioned in the change log so far:\n\n* bsc#1173641, CVE-2020-15358: heap-based buffer overflow in\n  multiSelectOrderBy due to mishandling of query-flattener\n  optimization\n* bsc#1164719, CVE-2020-9327: NULL pointer dereference and\n  segmentation fault because of generated column optimizations in\n  isAuxiliaryVtabOperator\n* bsc#1160439, CVE-2019-20218: selectExpander in select.c proceeds\n  with WITH stack unwinding even after a parsing error\n* bsc#1160438, CVE-2019-19959: memory-management error via\n  ext/misc/zipfile.c involving embedded '\\0' input\n* bsc#1160309, CVE-2019-19923: improper handling  of  certain uses\n  of SELECT DISTINCT in flattenSubquery may lead to null pointer\n  dereference\n* bsc#1159850, CVE-2019-19924: improper error handling in\n  sqlite3WindowRewrite()\n* bsc#1159847, CVE-2019-19925: improper handling of NULL pathname\n  during an update of a ZIP archive\n* bsc#1159715, CVE-2019-19926: improper handling  of certain\n  errors during parsing  multiSelect in select.c\n* bsc#1159491, CVE-2019-19880: exprListAppendList in window.c\n  allows attackers to trigger an invalid pointer dereference\n* bsc#1158960, CVE-2019-19603: during handling of CREATE TABLE\n  and CREATE VIEW statements, does not consider confusion with\n  a shadow table name\n* bsc#1158959, CVE-2019-19646: pragma.c mishandles NOT NULL in an\n  integrity_check PRAGMA command in certain cases of generated\n  columns\n* bsc#1158958, CVE-2019-19645: alter.c allows attackers to trigger\n  infinite recursion via certain types of self-referential views\n  in conjunction with ALTER TABLE statements\n* bsc#1158812, CVE-2019-19317: lookupName in resolve.c omits bits\n  from the colUsed bitmask in the case of a generated column,\n  which allows attackers to cause a denial of service\n* bsc#1157818, CVE-2019-19244: sqlite3,sqlite2,sqlite: The\n  function sqlite3Select in select.c allows a crash if a\n  sub-select uses both DISTINCT and window functions, and also\n  has certain ORDER BY usage\n* bsc#928701, CVE-2015-3415: sqlite3VdbeExec comparison operator\n  vulnerability\n* bsc#928700, CVE-2015-3414: sqlite3,sqlite2: dequoting of\n  collation-sequence names\n* CVE-2020-13434 bsc#1172115: integer overflow in\n  sqlite3_str_vappendf\n* CVE-2020-13630 bsc#1172234: use-after-free in fts3EvalNextRow\n* CVE-2020-13631 bsc#1172236: virtual table allowed to be renamed\n  to one of its shadow tables\n* CVE-2020-13632 bsc#1172240: NULL pointer dereference via\n  crafted matchinfo() query\n* CVE-2020-13435: Malicious SQL statements could have crashed the\n  process that is running SQLite (bsc#1172091)\n","status":"published","published":"2021-09-23T14:26:45Z","modified":"2026-02-04T02:57:08.059032Z","updated_at":"2026-11-02T15:53:49.605187Z"}]}}