/ Artifact Content
Login

Artifact 253e38a485bf06453f3bd871bcda9c3933c260faaf5b53564702498da02b16c2:

Ticket change [253e38a4] - New ticket [f1580ba1] Row is not fetched in WITHOUT ROWID table and a composite primary key. by mrigger 2019-06-14 11:03:06.
D 2019-06-14T11:03:06.180
J icomment Consider\sthe\sfollowing\sstatements:\r\n\r\n<pre>\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</pre>\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