D 2011-06-26T23:07:10.627
J comment The\sfollowing\stest\sprogram\sreports\sthat\sthe\sPRAGMA\sfails:\r\n\r\n<blockquote><verbatim>\r\n#include\s<stdio.h>\r\n#include\s"sqlite3.h"\r\n\r\nint\smain(void){\r\n\s\ssqlite3\s*db3;\r\n\s\schar\s*errmsg;\r\n\s\sint\serr;\r\n\r\n\s\ssqlite3_open("test.db",\s&db3);\r\n\s\serr\s=\ssqlite3_exec(db3,\s"PRAGMA\scase_sensitive_like=1;",\s0,\s0,\s&errmsg);\r\n\s\sif\s(err\s!=\sSQLITE_OK){\r\n\s\s\s\sprintf("Error\s%d:\s%s\\n",\serr,\serrmsg);\r\n\s\s\s\ssqlite3_free(errmsg);\r\n\s\s}\r\n\s\sreturn\s0;\r\n}\r\n</verbatim></blockquote>\r\n\r\nThis\sproblem\swas\sreported\son\sthe\smailing\slist\sby\sGreg\sStein.\s\sInvestigation\r\nshows\sthat\sthe\sPRAGMA\sactually\sworks;\sit\ssimply\sreturns\san\sSQLITE_SCHEMA\r\nerror\scode\sinstead\sof\sSQLITE_OK.\s\sThe\sproblem\swas\sintroduced\sby\r\ncheck-in\s[957b2ab67c61]\sby\sthe\sremoval\sof\s"p->expired\s=\s0;"\sfrom\s\r\nthe\ssqlite3VdbeAddOp3().\s\sThe\scase_sensitive_like\sfunction\scauses\r\na\snew\sLIKE\sfunction\sto\sbe\sregistered,\swhich\ssets\s"p->expired\s=\s1",\r\nleading\sto\sthe\serror.\s\sIt\sis\sunclear\s(yet)\swhy\sthis\sproblem\swas\snot\r\npicked\sup\sby\stests.
J detected Application_Fault
J foundin 3.7.7
J severity Important
J status Open
J subsystem Unknown
J title PRAGMA\scase_sensitive_like=1\sfails
J type Code_Defect
K 25ee81271091ec27a8c5e00eeffc02949a712cb7
U drh
Z e923b806b8902448a8e7f8b5e7f80cb6