SQLite

Artifact [c51da103]
Login

Artifact c51da1032cd4b9d2e65de2eea986a1570311f8f6c9260fc48671300282e92fbb:

Ticket change [c51da103] - New ticket [a55ab6d9] Incorrect result for TEXT comparison on rtree table. by mrigger 2019-12-04 22:53:14.
D 2019-12-04T22:53:14.563
J foundin 3.29.0
J icomment Consider\sthe\sfollowing\stest\scase:\r\n\r\n<pre>\r\nCREATE\sVIRTUAL\sTABLE\srt0\sUSING\srtree(c0,\sc1,\sc2);\r\nINSERT\sINTO\srt0(c2)\sVALUES(NULL);\r\nSELECT\s*\sFROM\srt0\sWHERE\srt0.c2\s>=\s'a';\s--\sunexpected:\sfetches\srow\r\n</pre>\r\n\r\nUnexpectedly,\sthe\sinserted\srow\sis\sfetched,\seven\sthough\sthe\spredicate\sshould\sevaluate\sto\sFALSE:\r\n\r\n<pre>\r\nSELECT\srt0.c2\s>=\s'a'\sFROM\srt0;\s--\s0\r\n</pre>
J login mrigger
J mimetype text/x-fossil-wiki
J severity Critical
J status Open
J title Incorrect\sresult\sfor\sTEXT\scomparison\son\srtree\stable
J type Code_Defect
K a55ab6d97d01ecbcf058a36ac3ccc7c7d887a1d7
U mrigger
Z bdb800a8f11712ad0c0000300032523d