D 2020-06-22T21:06:50.931
J foundin 1.0.108.0
J icomment Executing\sthe\sfollowing\scode\s(using\sDapper)\sresults\sin\sa\sconnection\swith\sthe\sBusyTimeout\sstill\sbeing\sthe\sdefault\sof\s0:\r\n\r\nusing\s(var\sconnection\s=\snew\sSQLiteConnection("pathToMyDb...")\r\n\t\t\s\s\s\s\s\s\s\s{\r\n\t\t\t\s\s\s\s\s\s\s\sconnection.BusyTimeout\s=\s5000;\r\n\t\t\t\s\s\s\s\s\s\s\sconnection.Open();\r\n\t\t\t\s\s\s\s\s\s\s\svar\sresult\s=\sconnection.QueryFirstOrDefault("PRAGMA\sbusy_timeout;");\r\n\t\t\s\s\s\s\s\s\s\s}\r\n\r\nI\swould\sexpect\sthe\sparameter\sto\sactually\sbe\sused\swhen\sopening\sthe\sconnection,\sbased\son\sits\scomment:\r\n\r\n///Gets/sets\sthe\sdefault\sbusy\stimeout\sto\suse\swith\sthe\sSQLite\score\slibrary.\s\sThis\sis\sonly\sused\swhen\r\n///opening\sa\sconnection.\r\n\r\nLooking\sat\sthe\ssource\scode\sfor\sthe\sConnection\sclass,\sit\sis\sthe\sOpen()\smethod\swhich\sis\sresetting\sthe\sBusyTimeout\sto\s0.\sIn\sthe\sOpen()\smethod,\sit\sappears\sthat\sthe\sproperty's\sbacking\svariable\sis\sset\sto\san\sexpected\sconnection\sstring\sparameter.\sIf\sthe\sconnection\sstring\sdoesn't\shave\sthe\sparameter\sfor\sBusyTimeout\sit\sis\sreset\sto\s0.\sThen,\sit\schecks\sto\ssee\sif\sthe\sparameter\sis\snot\szero\swhen\sdetermining\swhether\sor\snot\sto\sexecute\sthe\sPRAGMA\sfor\ssetting\sthe\sBusyTimeout.\sAny\svalue\sset\svia\sthe\sproperty\sis\soverwritten.
J login anonymous
J mimetype text/plain
J private_contact 9b7eeaf3d8aa5fbf8a2a538e8e8fb1b134cf69b6
J severity Important
J status Open
J title BusyTimeout\sproperty\sis\snot\sused
J type Code_Defect
K 15d3749655e12f15944e95ef6a026f3613fcdb8a
U anonymous
Z 7e336602084ff5cf95b6ac88a9af4f69
