Artifact 0acc8b258a4e123cc90f019b95be4470bf21ab9ac55177e1a8369a264f5afad3:

Ticket change [0acc8b258a] - New ticket [596d059af77f2493|596d059af7] <i>Committing a transaction with a failed ALTER TABLE may subtly corrupt schema</i>. by dan 2019-03-15 15:43:08.

---

D 2019-03-15T15:43:08.465
J icomment <verbatim>\r\n\s\sCREATE\sTABLE\st1(a,\sb);\r\n\s\sCREATE\sTABLE\st3(e,\sf);\r\n\s\sCREATE\sTRIGGER\str1\sAFTER\sINSERT\sON\st1\sBEGIN\r\n\s\s\s\sINSERT\sINTO\st2\sVALUES(new.a,\snew.b);\r\n\s\sEND;\r\n\s\sBEGIN;\r\n\s\s\s\sALTER\sTABLE\st3\sRENAME\sTO\st4;\r\n\s\sCOMMIT;\r\n\s\sSELECT\s*\sFROM\ssqlite_master\sWHERE\stype='table'\sAND\sname!='t1';\r\n</verbatim>\r\n\r\nThe\soutput\sof\sthe\sabove\sscript\sis:\r\n\r\n<verbatim>\r\n\s\stable|t3|t3|3|CREATE\sTABLE\s"t4"(e,\sf)\s\r\n</verbatim>\r\n\r\nThe\sschema\sis\snow\scorrupt\s-\sas\sthe\stable\sname\sin\sthe\sSQL\sdoes\snot\smatch\sthe\stable\snames\sin\sthe\s"name"\sand\s"tbl_name"\scolumns.
J login dan
J mimetype text/x-fossil-wiki
J severity Critical
J status Open
J title Committing\sa\stransaction\swith\sa\sfailed\sALTER\sTABLE\smay\ssubtly\scorrupt\sschema
J type Code_Defect
K 596d059af77f249314159d608e7449c899ea0764
U dan
Z 27d851fb48a685d2b6dc38fdb61c5a55