D 2015-04-11T11:06:13.101
J foundin trunk
J icomment The\sfollowing\sscript:\r\n\r\n<verbatim>\r\n\s\screate\stable\st(x,\sy,\sunique(x,\sy));\r\n\s\sinsert\sinto\st\svalues(null,\s1);\r\n\s\sinsert\sinto\st\svalues(null,\s1);\r\n\s\sselect\s*\sfrom\st\swhere\sx\sis\snull\sand\sy\s=\s1;\r\n</verbatim>\r\n\r\nis\sreturning\sone\srow\sinstead\sof\stwo.\r\n\r\nIntroduced\shere:\s[90e36676476e8db0]\r\n\r\nFirst\sappeared\sin\sversion\s3.8.5\r\n\r\nIsolated\son\sthe\smailing\slist\shere:\s[http://osdir.com/ml/general/2015-04/msg13265.html]
J login dan
J mimetype text/x-fossil-wiki
J severity Critical
J status Open
J title Expressions\slike\s(a\sIS\sNULL\sAND\sb\s=\s?)\soptimized\sby\sa\sUNIQUE\sindex\smatching\sa\ssingle\srow\sonly
J type Code_Defect
K 7b4fee9f6c20b6341b27432dc91c52b0d2ecf53c
U dan
Z 076678209f4f5b118bf3c509879a10af