SQLite

Artifact [cc30ae32]
Login

Artifact cc30ae323765dcf9c32dcf2e32a781107a7a4a89:

Ticket change [cc30ae32] - New ticket [11d5aa45] sqlite3_trace() sometimes does not invoke its callback. by drh 2014-08-19 19:57:38.
D 2014-08-19T19:57:38.002
J foundin 3.8.6
J icomment The\scallback\sto\ssqlite3_trace()\sis\ssuppose\sto\sbe\sinvoked\sfor\severy\sSQL\sstatement\r\nthat\sis\srun\sby\sthe\sVDBE.\s\sBut\ssometimes\sthe\scallback\swill\sbe\ssuppressed.\s\sIf\r\nthe\sprepared\sstatement\sis\smarked\sas\sexpired\s(which\scan\shappen,\sfor\sexample,\r\nif\sthe\sRHS\sof\san\sexpression\slike\s"x\sGLOB\s?1"\sis\srebound\sand\sX\sis\san\sindexed\r\ntext\scolumn)\sthen\sthe\scallback\sis\snot\sinvoked.\s\sThis\scan\sbe\sseen\sin\sthe\sshell\r\nby\srunning:\r\n\r\n<blockquote><verbatim>\r\n.trace\sstderr\r\n.tables\r\n</verbatim></blockquote>\r\n\r\nThe\sSELECT\sstatement\sthat\simplements\sthe\s".tables"\scommand\sis\snot\straced.\r\n\r\nThis\sproblem\sappears\sto\shave\sexisted\ssince\s2012-10-03,\sversion\s3.7.15\sand\r\ncheck-in\s[39f763bfc04174ee0fe2cdf6a92].\s\sThe\sproblem\swas\sdiscovered\sduring\r\ninternal\stesting\sand\shas\snot\sbeen\sobserved\sin\sthe\swild.
J login drh
J mimetype text/x-fossil-wiki
J severity Minor
J status Open
J title sqlite3_trace()\ssometimes\sdoes\snot\sinvoke\sits\scallback
J type Code_Defect
K 11d5aa455e0d98f3c1e6a084a89309710458ee4d
U drh
Z 11838a5198d1f76e87d22547d766d808