SQLite

Artifact [b3016558c5]
Login

Artifact b3016558c5282cc79787674cb650e0dfd127105f:

Ticket change [b3016558c5] - New ticket [80369eddd5] Incorrect case folding in the LIKE operator. by drh 2016-01-20 14:07:10.
D 2016-01-20T14:07:10.451
J foundin 3.10.0
J icomment The\sfollowing\s(equivalent)\squeries\sreturn\strue,\swhen\sthe\scorrect\sanswer\sis\sfalse:\r\n\r\n<blockquote><verbatim>\r\nSELECT\s'き'\sLIKE\s'ね';\r\nSELECT\schar(0x304d)\sLIKE\schar(0x306d);\r\n</verbatim></blockquote>\r\n\r\nThe\sculprit\sseems\sto\sbe\scheck-in\s[0a99a8c4facf]\son\s[2015-12-30\s14:06:22].\s\sCase\scomparison\sis\sonly\slooking\sat\sthe\slower\s8\sbytes\sof\sunicode\svalues.
J login drh
J mimetype text/x-fossil-wiki
J severity Critical
J status Open
J title Incorrect\scase\sfolding\sin\sthe\sLIKE\soperator
J type Code_Defect
K 80369eddd5c94d49f7fbbcf5d442bac618549aa7
U drh
Z f3ade9422130b1bc3d5b894540a0ba02