D 2019-06-14T10:01:47.445 J icomment Consider\sthis\sexample:\r\n\r\n
\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
\r\n\r\nAlthough\sthe\sLIKE\sexpression\sshould\syield\s1\s(see\sbelow),\sno\srow\sis\sfetched:\r\n\r\n
\r\nSELECT\st0.c0\sLIKE\s'.1%'\sFROM\st0;\s--\s1\r\n
\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