Artifact f849f83fc8076fc64561b6bc43f719810289f9c8:

Ticket change [f849f83fc8] - New ticket [f386e46e1f] fossil sqlite3 OPTIONS not properly evaluated. by anonymous 2010-11-17 12:31:48.

---

D 2010-11-17T12:31:48
J comment It\sseem\sthat\sOPTIONS\sin\s"fossil\ssqlite3\s?DATABASE?\s?OPTIONS?"\scommands\sare\snot\sproperly\sevaluated.\sBelow\sis\sevidence\sof\sattempts\sto\sset\sseparator\sto\s'X'\svalue.\s\r\n\r\nI\sam\sin\sopen\scheckout,\sso\sI\scan\sselect\sstuff\sfrom\sfossil\srepo\sby\sbuilt-in\ssqlite3\scommand(with\sor\swithout\sexplicitly\snaming\sfossil\srepo\sfile):\r\n<verbatim>\r\nc:\\soft\\msys\\home\\user\\fossil>fossil\s\ssqlite3\r\nSQLite\sversion\s3.7.4\r\nEnter\s".help"\sfor\sinstructions\r\nEnter\sSQL\sstatements\sterminated\swith\sa\s";"\r\nsqlite>\sselect\s*\sfrom\sblob\swhere\srid\s=\s1;\r\n1|1|127|a28c83647dfa805f05f3204a7e146eb1f0d90505|\r\nsqlite>\s.qui\r\n\r\nc:\\soft\\msys\\home\\user\\fossil>\r\n</verbatim>\r\n\r\nIf\sI\stry\sto\suse\sOPTIONS\s(both\swith\sexplicit\snaming\sof\srepo\sfile\sor\swithout\snaming\sof\srepo\sfile,\swhile\sinvoking\sbuild-in\ssqlite3\sin\sopen\scheck\sout\sdirectory),\sI\sget\seither:\r\n\r\nerror\s"Error:\sno\ssuch\stable:\sblob",\sso\soptions\sare\snot\shonored,\sperhaps\sinterpreted\sas\sa\sname\sof(non\sexistent)\srepo\sfile:\r\n\r\n<verbatim>\r\nc:\\soft\\msys\\home\\user\\fossil>fossil\s\ssqlite3\s\s--separator\s'X'\r\nSQLite\sversion\s3.7.4\r\nEnter\s".help"\sfor\sinstructions\r\nEnter\sSQL\sstatements\sterminated\swith\sa\s";"\r\nsqlite>\sselect\srid,content\sfrom\sblob\swhere\srid\s=\s1;\r\nError:\sno\ssuch\stable:\sblob\r\nsqlite>\s.qui\r\n\r\nc:\\soft\\msys\\home\\user\\fossil>\r\n</verbatim>\r\n\r\nOR\serror\sabout\stoo\smany\soptions\s"sqlite3:\sError:\stoo\smany\soptions:\s"'X'""\swith\sexit\sto\scmd\sshell:\r\n<verbatim>\r\nc:\\soft\\msys\\home\\user\\fossil>fossil\s\ssqlite3\sc:\\soft\\bin\\myfossilclone.fossil\s--\r\nseparator\s'X'\r\nsqlite3:\sError:\stoo\smany\soptions:\s"'X'"\r\nUse\s-help\sfor\sa\slist\sof\soptions.\r\n\r\nc:\\soft\\msys\\home\\user\\fossil>\r\n</verbatim>
J private_contact 24b67375dd2ec6c7381a5ad34cfcf006f0b9c260
J severity Important
J status Open
J title fossil\ssqlite3\sOPTIONS\snot\sproperly\sevaluated
J type Code_Defect
K f386e46e1f177c2890b3ddc0b8f9c7487e1f9b91
U anonymous
Z d2dca21e6c7c7a77f689efd8e7913271