{"id":"CVE-2019-19645","details":"alter.c in SQLite through 3.30.1 allows attackers to trigger infinite recursion via certain types of self-referential views in conjunction with ALTER TABLE statements.","modified":"2026-04-02T02:04:42.555118Z","published":"2019-12-09T16:15:10.407Z","related":["SUSE-SU-2021:2320-1","SUSE-SU-2021:3215-1","openSUSE-SU-2021:1058-1","openSUSE-SU-2021:2320-1"],"references":[{"type":"ADVISORY","url":"https://security.netapp.com/advisory/ntap-20191223-0001/"},{"type":"ADVISORY","url":"https://usn.ubuntu.com/4394-1/"},{"type":"ADVISORY","url":"https://www.tenable.com/security/tns-2021-14"},{"type":"FIX","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/38096961c7cd109110ac21d3ed7dad7e0cb0ae06"}],"affected":[{"ranges":[{"type":"GIT","repo":"https://github.com/sqlite/sqlite","events":[{"introduced":"0"},{"last_affected":"25e9591209453dc0904f8f0f1c4d5090c836e19b"},{"fixed":"38096961c7cd109110ac21d3ed7dad7e0cb0ae06"}],"database_specific":{"versions":[{"introduced":"0"},{"last_affected":"3.30.1"}]}}],"versions":["cvs-to-fossil-cutover","experimental","fts3-refactor","mountain-lion","version-1.0","version-1.0.1","version-1.0.10","version-1.0.12","version-1.0.13","version-1.0.14","version-1.0.15","version-1.0.16","version-1.0.17","version-1.0.18","version-1.0.19","version-1.0.20","version-1.0.21","version-1.0.22","version-1.0.23","version-1.0.24","version-1.0.25","version-1.0.26","version-1.0.27","version-1.0.28","version-1.0.29","version-1.0.3","version-1.0.30","version-1.0.31","version-1.0.32","version-1.0.4","version-1.0.5","version-1.0.8","version-1.0.9","version-2.0.0","version-2.0.1","version-2.0.2","version-2.0.3","version-2.0.4","version-2.0.5","version-2.0.6","version-2.0.7","version-2.0.8","version-2.1.0","version-2.1.1","version-2.1.2","version-2.1.3","version-2.1.4","version-2.1.5","version-2.1.6","version-2.1.7","version-2.2.0","version-2.2.1","version-2.2.2","version-2.2.3","version-2.2.4","version-2.2.5","version-2.3.0","version-2.3.1","version-2.3.2","version-2.3.3","version-2.4.0","version-2.4.1","version-2.4.10","version-2.4.11","version-2.4.12","version-2.4.2","version-2.4.3","version-2.4.4","version-2.4.5","version-2.4.6","version-2.4.7","version-2.4.8","version-2.4.9","version-2.5.0","version-2.5.1","version-2.5.2","version-2.5.3","version-2.5.4","version-2.5.5","version-2.5.6","version-2.6.0","version-2.6.1","version-2.6.2","version-2.6.3","version-2.7.0","version-2.7.1","version-2.7.2","version-2.7.3","version-2.7.4","version-2.7.5","version-2.7.6","version-2.8.0","version-2.8.1","version-2.8.10","version-2.8.11","version-2.8.12","version-2.8.13","version-2.8.14","version-2.8.15","version-2.8.16","version-2.8.17","version-2.8.2","version-2.8.3","version-2.8.4","version-2.8.5","version-2.8.6","version-2.8.7","version-2.8.8","version-2.8.9","version-3.0.0","version-3.0.1","version-3.0.2","version-3.0.3","version-3.0.4","version-3.0.5","version-3.0.6","version-3.0.7","version-3.0.8","version-3.1.0","version-3.1.1","version-3.1.2","version-3.1.3","version-3.1.3.1","version-3.1.4","version-3.1.5","version-3.1.6","version-3.10.0","version-3.10.1","version-3.10.2","version-3.11.0","version-3.11.1","version-3.12.0","version-3.12.1","version-3.12.2","version-3.13.0","version-3.14.0","version-3.14.1","version-3.14.2","version-3.15.0","version-3.15.1","version-3.15.2","version-3.16.0","version-3.16.1","version-3.16.2","version-3.17.0","version-3.18.0","version-3.18.1","version-3.18.2","version-3.19.0","version-3.19.1","version-3.19.2","version-3.19.3","version-3.19.4","version-3.2.0","version-3.2.1","version-3.2.2","version-3.2.3","version-3.2.4","version-3.2.5","version-3.2.6","version-3.2.7","version-3.2.8","version-3.20.0","version-3.20.1","version-3.21.0","version-3.22.0","version-3.23.0","version-3.23.1","version-3.23.2","version-3.24.0","version-3.25.0","version-3.25.1","version-3.25.2","version-3.25.3","version-3.26.0","version-3.27.0","version-3.27.1","version-3.27.2","version-3.28.0","version-3.29.0","version-3.3.0","version-3.3.1","version-3.3.10","version-3.3.11","version-3.3.12","version-3.3.13","version-3.3.14","version-3.3.15","version-3.3.16","version-3.3.17","version-3.3.2","version-3.3.3","version-3.3.4","version-3.3.5","version-3.3.6","version-3.3.7","version-3.3.8","version-3.3.9","version-3.30.0","version-3.30.1","version-3.4.0","version-3.4.1","version-3.4.2","version-3.5.0","version-3.5.1","version-3.5.2","version-3.5.3","version-3.5.4","version-3.5.5","version-3.5.6","version-3.5.7","version-3.5.8","version-3.5.9","version-3.6.0","version-3.6.1","version-3.6.10","version-3.6.11","version-3.6.12","version-3.6.13","version-3.6.14","version-3.6.14.1","version-3.6.14.2","version-3.6.15","version-3.6.16","version-3.6.16.1","version-3.6.17","version-3.6.18","version-3.6.19","version-3.6.2","version-3.6.20","version-3.6.21","version-3.6.22","version-3.6.23","version-3.6.23.1","version-3.6.3","version-3.6.4","version-3.6.5","version-3.6.6","version-3.6.6.1","version-3.6.6.2","version-3.6.7","version-3.6.8","version-3.6.9","version-3.7.0","version-3.7.0.1","version-3.7.1","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.14.1","version-3.7.15","version-3.7.15.1","version-3.7.15.2","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.3","version-3.7.4","version-3.7.5","version-3.7.6","version-3.7.6.1","version-3.7.6.2","version-3.7.6.3","version-3.7.7","version-3.7.7.1","version-3.7.8","version-3.7.9","version-3.8.0","version-3.8.0.1","version-3.8.0.2","version-3.8.1","version-3.8.10","version-3.8.10.1","version-3.8.10.2","version-3.8.11","version-3.8.11.1","version-3.8.2","version-3.8.3","version-3.8.3.1","version-3.8.4","version-3.8.4.1","version-3.8.4.2","version-3.8.4.3","version-3.8.5","version-3.8.6","version-3.8.6.1","version-3.8.7","version-3.8.7.1","version-3.8.7.2","version-3.8.7.3","version-3.8.7.4","version-3.8.8","version-3.8.8.1","version-3.8.8.2","version-3.8.8.3","version-3.8.9","version-3.9.0","version-3.9.1","version-3.9.2","version-3.9.3"],"database_specific":{"unresolved_ranges":[{"events":[{"introduced":"0"},{"last_affected":"8.0.19"}]},{"events":[{"introduced":"0"},{"fixed":"5.19.0"}]},{"events":[{"introduced":"0"},{"fixed":"1.0.1.1"}]}],"source":"https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2019-19645.json","vanir_signatures":[{"target":{"file":"src/alter.c","function":"renameTableSelectCb"},"source":"https://github.com/sqlite/sqlite/commit/38096961c7cd109110ac21d3ed7dad7e0cb0ae06","signature_type":"Function","deprecated":false,"signature_version":"v1","id":"CVE-2019-19645-1e814208","digest":{"length":454,"function_hash":"137652159006488488378910093598965854534"}},{"target":{"file":"src/alter.c"},"source":"https://github.com/sqlite/sqlite/commit/38096961c7cd109110ac21d3ed7dad7e0cb0ae06","signature_type":"Line","deprecated":false,"signature_version":"v1","id":"CVE-2019-19645-2db4d23f","digest":{"line_hashes":["84153097897314073783446734741620510663","300128482327856352769144142899536607852","280836776554425541356387555498740863786","87572003988691013708980340956445185010","2402286542967935199782441531963033675","45523987690108909918468187931970987239","187212862065278774525882424080241152925","185437734776018729155396413130449398692","119701641238499030755385993798746950687","138113395892859978685831277949717252364","54683795308948637861214879832576879225","13248069018947833808656382929838188386","143803117638380997211620097305247215597","172682879787505921628871160852026479684","238324319244480529393229375272998128109","300473735985943637457597754735302112691","225688196722464126384200843985473787618","333796622313076281615450693534734425681","141124616088076072798002107720775481660","298329940819526999798811753397387390315","237954374854095881156168339816261223227","44568218082248568283035041945453833900","48589095152064312847023529691666820110","101397759593390508557016886148173471352","124113290576384056309053365293329990859"],"threshold":0.9}},{"target":{"file":"src/alter.c","function":"renameTableFunc"},"source":"https://github.com/sqlite/sqlite/commit/38096961c7cd109110ac21d3ed7dad7e0cb0ae06","signature_type":"Function","deprecated":false,"signature_version":"v1","id":"CVE-2019-19645-58aad15a","digest":{"length":2878,"function_hash":"160866700809429897225184230543174284876"}},{"target":{"file":"src/build.c"},"source":"https://github.com/sqlite/sqlite/commit/38096961c7cd109110ac21d3ed7dad7e0cb0ae06","signature_type":"Line","deprecated":false,"signature_version":"v1","id":"CVE-2019-19645-7d04ffc4","digest":{"line_hashes":["124115708789229995526430467552401850331","152938386665619062968147848889038017217","316879319588565393617932425664001686455"],"threshold":0.9}},{"target":{"file":"src/build.c","function":"sqlite3CreateView"},"source":"https://github.com/sqlite/sqlite/commit/38096961c7cd109110ac21d3ed7dad7e0cb0ae06","signature_type":"Function","deprecated":false,"signature_version":"v1","id":"CVE-2019-19645-8d32bd66","digest":{"length":1497,"function_hash":"18964607448530675386471108975362876526"}},{"target":{"file":"src/alter.c","function":"renameUnmapSelectCb"},"source":"https://github.com/sqlite/sqlite/commit/38096961c7cd109110ac21d3ed7dad7e0cb0ae06","signature_type":"Function","deprecated":false,"signature_version":"v1","id":"CVE-2019-19645-96d63033","digest":{"length":586,"function_hash":"312683813736850985888155503723164784975"}},{"target":{"file":"src/alter.c","function":"renameColumnFunc"},"source":"https://github.com/sqlite/sqlite/commit/38096961c7cd109110ac21d3ed7dad7e0cb0ae06","signature_type":"Function","deprecated":false,"signature_version":"v1","id":"CVE-2019-19645-d899fbf2","digest":{"length":4127,"function_hash":"33795226083652506874767072485610160884"}},{"target":{"file":"src/alter.c","function":"renameColumnSelectCb"},"source":"https://github.com/sqlite/sqlite/commit/38096961c7cd109110ac21d3ed7dad7e0cb0ae06","signature_type":"Function","deprecated":false,"signature_version":"v1","id":"CVE-2019-19645-da0f6a86","digest":{"length":110,"function_hash":"158823728060461890669991676313923939636"}}]}}],"schema_version":"1.7.5","severity":[{"type":"CVSS_V3","score":"CVSS:3.1/AV:L/AC:L/PR:L/UI:N/S:U/C:N/I:N/A:H"}]}