D 2016-07-14T18:46:40.027
J foundin 3.13.0
J icomment The\schange\sto\sALTER\sTABLE\sin\s[e1d8ec85546c]\scan\scause\sindexes\sto\sgo\scorrupt.\r\nSample\scode:\r\n\r\n<blockquote><verbatim>\r\nPRAGMA\slegacy_file_format=ON;\r\nCREATE\sTABLE\st1(a,b,c);\r\nCREATE\sINDEX\st1a\sON\st1(a\sDESC);\r\nINSERT\sINTO\st1\sVALUES(1,2,3);\r\nINSERT\sINTO\st1\sVALUES(2,3,4);\r\nALTER\sTABLE\st1\sADD\sCOLUMN\sd;\r\nPRAGMA\sintegrity_check;\r\n</verbatim></blockquote>\r\n\r\nIf\sthe\sschema\sversion\sis\sinitially\sless\sthan\s4,\sthen\sthe\sDESC\skeyword\son\s\r\nindexes\sis\signored.\s\sIf\sALTER\sTABLE\sthen\schanges\sthe\sschema\sversion\sto\s4\sfrom\r\na\ssmaller\svalue,\sthen\spreexisting\sDESC\sindexes\swill\sbe\sin\sthe\swrong\sorder.\r\n\r\nCorruption\scaused\sby\sthis\sbug\scan\sbe\sfixed\sby\srunning\sthe\sREINDEX\scommand.
J login drh
J mimetype text/x-fossil-wiki
J severity Severe
J status Open
J title ALTER\sTABLE\scorrupts\sDESC\sindexes
J type Code_Defect
K f68bf68513a1c15ff405c54e39e637a9f8156f7b
U drh
Z 1148e4467c8e1a58a122a93f8934e5c7