{"id":"CVE-2019-19924","details":"SQLite 3.30.1 mishandles certain parser-tree rewriting, related to expr.c, vdbeaux.c, and window.c. This is caused by incorrect sqlite3WindowRewrite() error handling.","modified":"2026-01-30T09:49:00.792855Z","published":"2019-12-24T16:15:11.370Z","related":["SUSE-SU-2021:2320-1","SUSE-SU-2021:3215-1","openSUSE-SU-2021:1058-1","openSUSE-SU-2021:2320-1"],"references":[{"type":"WEB","url":"https://lists.apache.org/thread.html/r58af02e294bd07f487e2c64ffc0a29b837db5600e33b6e698b9d696b%40%3Cissues.bookkeeper.apache.org%3E"},{"type":"WEB","url":"https://lists.apache.org/thread.html/rf4c02775860db415b4955778a131c2795223f61cb8c6a450893651e4%40%3Cissues.bookkeeper.apache.org%3E"},{"type":"WEB","url":"https://usn.ubuntu.com/4298-1/"},{"type":"ADVISORY","url":"https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf"},{"type":"ADVISORY","url":"https://github.com/sqlite/sqlite/commit/8654186b0236d556aa85528c2573ee0b6ab71be3"},{"type":"ADVISORY","url":"https://security.netapp.com/advisory/ntap-20200114-0003/"},{"type":"ADVISORY","url":"https://www.oracle.com/security-alerts/cpuapr2020.html"},{"type":"FIX","url":"https://cert-portal.siemens.com/productcert/pdf/ssa-389290.pdf"},{"type":"FIX","url":"https://github.com/sqlite/sqlite/commit/8654186b0236d556aa85528c2573ee0b6ab71be3"},{"type":"FIX","url":"https://www.oracle.com/security-alerts/cpuapr2020.html"}],"affected":[{"ranges":[{"type":"GIT","repo":"https://github.com/sqlite/sqlite","events":[{"introduced":"0"},{"fixed":"8654186b0236d556aa85528c2573ee0b6ab71be3"}]}],"versions":["cvs-to-fossil-cutover","experimental","fts3-refactor","version-3.10.0","version-3.11.0","version-3.11.1","version-3.12.0","version-3.13.0","version-3.14.0","version-3.15.0","version-3.16.0","version-3.19.0","version-3.19.1","version-3.19.2","version-3.21.0","version-3.22.0","version-3.23.0","version-3.23.1","version-3.24.0","version-3.25.0","version-3.26.0","version-3.27.0","version-3.28.0","version-3.29.0","version-3.30.0","version-3.6.10","version-3.6.15","version-3.7.10","version-3.7.11","version-3.7.12","version-3.7.12.1","version-3.7.13","version-3.7.14","version-3.7.15","version-3.7.16","version-3.7.16.1","version-3.7.16.2","version-3.7.17","version-3.7.2","version-3.7.4","version-3.7.5","version-3.7.6","version-3.7.6.1","version-3.7.7","version-3.7.8","version-3.7.9","version-3.8.0","version-3.8.1","version-3.8.10","version-3.8.10.1","version-3.8.11","version-3.8.11.1","version-3.8.2","version-3.8.3","version-3.8.4","version-3.8.4.1","version-3.8.5","version-3.8.6","version-3.8.7","version-3.8.7.1","version-3.8.8","version-3.8.9","version-3.9.0","version-3.9.1"],"database_specific":{"vanir_signatures":[{"id":"CVE-2019-19924-0cbda4f5","deprecated":false,"signature_type":"Function","digest":{"function_hash":"289341195574350212391054022878281305145","length":510},"target":{"file":"src/expr.c","function":"codeCompare"},"signature_version":"v1","source":"https://github.com/sqlite/sqlite/commit/8654186b0236d556aa85528c2573ee0b6ab71be3"},{"id":"CVE-2019-19924-3ebbb9e3","deprecated":false,"signature_type":"Function","digest":{"function_hash":"261577890961411014898351609100443694783","length":3044},"target":{"file":"src/window.c","function":"sqlite3WindowRewrite"},"signature_version":"v1","source":"https://github.com/sqlite/sqlite/commit/8654186b0236d556aa85528c2573ee0b6ab71be3"},{"id":"CVE-2019-19924-556c1242","deprecated":false,"signature_type":"Line","digest":{"threshold":0.9,"line_hashes":["325699382715287326009987521307471454456","270222519232114022808879911164492275075","234771701567774970236996005718943768462","157367755804963360587907976423518170340","251448130515872088556476770431500172221","144272897311174661132725549144917480053","33614506948838653228691560302179833877"]},"target":{"file":"src/window.c"},"signature_version":"v1","source":"https://github.com/sqlite/sqlite/commit/8654186b0236d556aa85528c2573ee0b6ab71be3"},{"id":"CVE-2019-19924-6d9de27b","deprecated":false,"signature_type":"Line","digest":{"threshold":0.9,"line_hashes":["11434213176979394703454359497710365439","310763219010397771047909940992835381421","156757343900631303322355437558628914552"]},"target":{"file":"src/expr.c"},"signature_version":"v1","source":"https://github.com/sqlite/sqlite/commit/8654186b0236d556aa85528c2573ee0b6ab71be3"},{"id":"CVE-2019-19924-b0007590","deprecated":false,"signature_type":"Line","digest":{"threshold":0.9,"line_hashes":["215444345926076654548411634251613729759","252380961147499365412023835791821933268","123604298311559770011683048397407628154","333404582138517325406381684493404653273"]},"target":{"file":"src/vdbeaux.c"},"signature_version":"v1","source":"https://github.com/sqlite/sqlite/commit/8654186b0236d556aa85528c2573ee0b6ab71be3"},{"id":"CVE-2019-19924-d9b45c3a","deprecated":false,"signature_type":"Function","digest":{"function_hash":"9434467424313002811330113527187731038","length":465},"target":{"file":"src/vdbeaux.c","function":"vdbeVComment"},"signature_version":"v1","source":"https://github.com/sqlite/sqlite/commit/8654186b0236d556aa85528c2573ee0b6ab71be3"}],"source":"https://storage.googleapis.com/osv-test-cve-osv-conversion/osv-output/CVE-2019-19924.json"}}],"schema_version":"1.7.3","severity":[{"type":"CVSS_V3","score":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:L/A:N"}]}