SQLite

Artifact [131ac5b2]
Login

Artifact 131ac5b2324808bc65fe8be687b9c893eb68558ffb58ce103bfe8a0c89ee07ae:

Ticket change [131ac5b2] - Ticket [79cad5e4] UPSERT results in a corrupt database status still Open with 3 other changes by drh 2018-07-11 12:50:58.
D 2018-07-11T12:50:58.658
J icomment Here\sis\sa\ssimplified\sscript\sto\sdemonstrate\sthe\sproblem:\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\st1(b\sUNIQUE,\sa\sINT\sPRIMARY\sKEY)\sWITHOUT\sROWID;\r\nINSERT\sINTO\st1(a)\sVALUES('1'),(1)\sON\sCONFLICT(a)\sDO\sNOTHING;\r\nPRAGMA\sintegrity_check;\r\n</verbatim></blockquote>
J login drh
J mimetype text/x-fossil-wiki
K 79cad5e4b2e219dd197242e9e5f4ef950f554684
U drh
Z 4ecb407968c6d1ff935ac18f783264bf