D 2017-07-15T19:32:41.632
J foundin 3.19.3
J icomment The\sPRAGMA\sintegrity_check\sat\sthe\send\sof\sthe\sfollowing\ssequence\sof\scode\r\nreports\sa\s"wrong\s#\sof\sentries"\serror,\seven\sthough\sthe\sdatabase\sis\sintact\r\nand\scorrect.\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\sTable1\s(col\sTEXT\sNOT\sNULL\sPRIMARY\sKEY);\r\nATTACH\s':memory:'\sAS\sdb2;\r\nCREATE\sTABLE\sdb2.Table2(col1\sINTEGER,\scol2\sINTEGER,\scol3\sINTEGER,\scol4\sINTEGER);\r\nCREATE\sUNIQUE\sINDEX\sdb2.idx_col1_unique\sON\sTable2\s(col1);\r\nCREATE\sUNIQUE\sINDEX\sdb2.idx_col23_unique\sON\sTable2\s(col2,\scol3);\r\nCREATE\sINDEX\sdb2.idx_col2\sON\sTable2\s(col2);\r\nINSERT\sINTO\sTable2\sVALUES(1,2,3,4);\r\nPRAGMA\sintegrity_check;\r\n</verbatim></blockquote>\r\n\r\nBisecting\sshows\sthat\sthe\sproblem\sfirst\sappeared\swith\scheck-in\s[88439a866]\r\non\s2016-0319\sand\swas\sfirst\r\nreleased\swith\sSQLite\s3.12.0\son\s2016-03-29\r\n\r\nThis\sproblem\swas\sreported\son\sthe\ssqlite-users\smailing\slist\sby\r\nBrendan\sE.\sCoughlan.
J login drh
J mimetype text/x-fossil-wiki
J severity Important
J status Open
J title False-positive\sfrom\s"PRAGMA\sintegrity_check"
J type Code_Defect
K a4e06e75a9ab61a127088c4aaa85a6d7a1455f06
U drh
Z b6fe8a9b9eea468b0e87027b08f7ac9a