D 2019-06-14T11:03:06.180 J icomment Consider\sthe\sfollowing\sstatements:\r\n\r\n
\r\nCREATE\sTABLE\st0(c0\sCOLLATE\sRTRIM,\sc1\sBLOB\sUNIQUE,\sPRIMARY\sKEY\s(c0,\sc1))\sWITHOUT\sROWID;\r\nINSERT\sINTO\st0\sVALUES\s(123,\s3),\s('\s',\s1),\s('\t',\s2),\s('',\s4);\r\nSELECT\s*\sFROM\st0\sWHERE\sc1\s=\s1;\s--\sexpected:\s'\s',\s1,\sactual:\sno\srow\sis\sfetched\r\n
\r\n\r\nI\swould\sexpect\sa\srow\sto\sbe\sfetched,\swhich\sis\snot\sthe\scase.\sNote\sthat\sthe\swhitespace\sseems\sto\sbe\ssignificant:\sthe\sfirst\sone\sis\sa\sspace,\sthe\ssecond\sone\sa\stab,\sand\sthe\sthird\sone\san\sempty\sstring. J login mrigger J mimetype text/x-fossil-wiki J severity Critical J status Open J title Row\sis\snot\sfetched\sin\sWITHOUT\sROWID\stable\sand\sa\scomposite\sprimary\skey J type Code_Defect K f1580ba1b574e9e92d0e6c3b9de519e398e0b10e U mrigger Z 671c8af5202e8a15da382f20d724dd5d