D 2019-10-07T19:25:09.925
J foundin 3.30.0
J icomment Consider\sthe\sfollowing\stest\scase:\r\n\r\n<pre>\r\nCREATE\sVIRTUAL\sTABLE\svt0\sUSING\sfts5(a);\r\nPRAGMA\sreverse_unordered_selects\s=\strue;\r\nINSERT\sINTO\svt0\sVALUES('365062398'),\s(0),\s(0);\r\nINSERT\sINTO\svt0(vt0,\srank)\sVALUES('pgsz',\s'3');\r\nUPDATE\svt0\sSET\sa\s=\s399905135;\s--\sunexpected:\sdatabase\sdisk\simage\sis\smalformed\r\nINSERT\sINTO\svt1(vt1)\sVALUES('integrity-check');\r\n</pre>\r\n\r\nThe\sintegrity-check\sindicates\sthat\sthe\sdatabase\sdisk\simage\sis\smalformed,\swhich\sis\sunexpected.\sI\ssuspect\sthe\sreason\sto\sbe\san\sissue\swith\sthe\spgsz\soption.\sIf,\sfor\sexample,\sthe\spgsz\svalue\sis\sset\sto\s3,\sthen\sthe\sUPDATE\snever\sterminates.
J login mrigger
J mimetype text/x-fossil-wiki
J severity Critical
J status Open
J title FTS\spgsz\soption\sresults\sin\s"database\sdisk\simage\sis\smalformed"\serror
J type Code_Defect
K 265e935b26afe80fcceaff6c216484aa88d6c65e
U mrigger
Z a4200502558f75b1ffb14406f7728797