D 2018-09-16T20:03:33.349
J foundin 3.25.0
J icomment The\snewly\senhanced\sALTER\sTABLE\sin\sSQLite\s3.25.0\shits\san\sassertion\sfault\swhen\r\nthere\sare\soperations\son\san\srtree\svirtual\stable\sin\sthe\sbody\sof\sthe\strigger.\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\st1(a\sINTEGER\sPRIMARY\sKEY,\sb);\r\nCREATE\sVIRTUAL\sTABLE\st2\sUSING\srtree(id,x0,x1);\r\nCREATE\sTRIGGER\sr1\sAFTER\sUPDATE\sON\st1\sBEGIN\r\n\s\s\sDELETE\sFROM\st2\sWHERE\sid\s=\sOLD.a;\r\nEND;\r\nALTER\sTABLE\st1\sRENAME\sTO\st3;\r\n</verbatim></blockquote>
J login drh
J mimetype text/x-fossil-wiki
J severity Severe
J status Open
J title Assertion\sfault\son\sALTER\sTABLE
J type Code_Defect
K b41031ea2b5372378cb3d2d43cf9fe2a4a5c2510
U drh
Z 6e96a737b8fceac905ded8e9f505f46c