SQLite

Artifact [81eff856]
Login

Artifact 81eff856130d83cc737fbfa1bc737154e9c26bc07ae52fb8a31141e203b8d6e4:

Ticket change [81eff856] - New ticket [ce8717f0] LIKE malfunctions for UNIQUE COLLATE NOCASE column. by mrigger 2019-06-14 10:01:47.
D 2019-06-14T10:01:47.445
J icomment Consider\sthis\sexample:\r\n\r\n<pre>\r\nCREATE\sTABLE\st0(c0\sINT\sUNIQUE\sCOLLATE\sNOCASE);\r\nINSERT\sINTO\st0(c0)\sVALUES\s('.1%');\r\nSELECT\s*\sFROM\st0\sWHERE\st0.c0\sLIKE\s'.1%';\s--\sexpected:\s'.1%',\sactual:\sno\srow\sis\sfetched\r\n</pre>\r\n\r\nAlthough\sthe\sLIKE\sexpression\sshould\syield\s1\s(see\sbelow),\sno\srow\sis\sfetched:\r\n\r\n<pre>\r\nSELECT\st0.c0\sLIKE\s'.1%'\sFROM\st0;\s--\s1\r\n</pre>\r\n\r\nIt\sseems\sthat\sthis\sproblem\sonly\sapplies\sto\sCOLLATE\sNOCASE\sas\swell\sas\sto\snumeric\scolumns\s(INT,\sREAL,\sand\sNUMERIC).
J login mrigger
J mimetype text/x-fossil-wiki
J severity Critical
J status Open
J title LIKE\smalfunctions\sfor\sUNIQUE\sCOLLATE\sNOCASE\scolumn
J type Code_Defect
K ce8717f0885af975dbdce9cedb342d5822901a12
U mrigger
Z f68b566c086594c20de7c4f042b94c77