/ Artifact Content
Login

Artifact 7c7394890ca323c0989e4f72fc64a892b85ddccf08d8578114dd934f1ad133d9:

Ticket change [7c739489] - New ticket [f4ec2509] Malformed image when using no journal mode, zero cache size, and failing when creating an index.. by mrigger 2019-05-17 12:48:17.
D 2019-05-17T12:48:17.204
J foundin 3.28
J icomment Consider\sthe\sfollowing\sexample:\r\n\r\n<pre>\r\nPRAGMA\sjournal_mode=OFF;\r\nPRAGMA\smain.cache_size=0;\r\nCREATE\sTABLE\sIF\sNOT\sEXISTS\st0\s(c0);\r\nCREATE\sINDEX\si0\sON\st0(1);\r\nDROP\sINDEX\s"i0";\r\nINSERT\sOR\sIGNORE\sINTO\st0(c0)\sVALUES\s(1),\s(2);\r\nCREATE\sUNIQUE\sINDEX\si0\sON\st0(1);\s--\sUNIQUE\sconstraint\sfailed:\sindex\s'i0'\r\nCREATE\sUNIQUE\sINDEX\si0\sON\st0(1);\s--\sdatabase\sdisk\simage\sis\smalformed\r\n</pre>\r\n\r\nIs\sthis\sexpected?\sThe\sdocumentation\smentions\sthat\sthe\s<i>ROLLBACK</i>\sstatement\scannot\sbe\sused\swith\s<i>journal_mode=OFF</i>,\sbut\sit\sdoes\snot\smention\sfailed\sindex\screation.
J login mrigger
J mimetype text/x-fossil-wiki
J severity Minor
J status Open
J title Malformed\simage\swhen\susing\sno\sjournal\smode,\szero\scache\ssize,\sand\sfailing\swhen\screating\san\sindex.
J type Code_Defect
K f4ec250930342e0c146bade2571c10f43085be34
U mrigger
Z 31c6c8dae3e81224922e72ad6795445a