SQLite

Artifact [151ec237]
Login

Artifact 151ec2376572a55d7faa15df02e54c6928fcc0b53baa9a80e09f4a6cc1602e3d:

Ticket change [151ec237] - New ticket [79cad5e4] UPSERT results in a corrupt database. by drh 2018-07-11 12:11:13.
D 2018-07-11T12:11:13.846
J foundin 3.24.0
J icomment An\sUPSERT\sdiscovered\sby\sOSSFuzz\sresults\sin\sa\scorrupt\sdatabase\sfile:\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\st1(\r\n\s\sa\sINT,\r\n\s\sb\sINT,\r\n\s\sc\sINT\sUNIQUE,\r\n\s\sPRIMARY\sKEY(a,b)\r\n)\sWITHOUT\sROWID;\r\nINSERT\sINTO\st1(a,b)\sVALUES(json(3),4),(1,2)\sON\sCONFLICT(a,b)\sDO\sNOTHING;\r\nPRAGMA\sintegrity_check;\r\n</verbatim></blockquote>\r\n\r\nThe\scorruption\sis\sa\smissing\sentry\sfrom\sthe\sunique\sindex\sand\sis\seasily\r\nfixed\susing\sREINDEX.\s\sNevertheless,\sthis\sshould\snot\sbe\shappening.
J login drh
J mimetype text/x-fossil-wiki
J severity Severe
J status Open
J title UPSERT\sresults\sin\sa\scorrupt\sdatabase
J type Code_Defect
K 79cad5e4b2e219dd197242e9e5f4ef950f554684
U drh
Z 5c3d0cfb2ed6b7e1bdf7f1e69af90a4e