D 2019-05-16T17:52:14.703
J foundin 3.28
J icomment It\sseems\sthat\sdepending\son\sthe\sFROM\sclause,\sa\sdifferent\sfloating-point\srounding\sis\sperformed\sas\sdemonstrated\sin\sthe\sexample\sbelow.\sAlthough\sprogrammers\sshould\snot\scompare\sfloating-point\snumbers\susing\sequality\soperators,\sthe\sresult\sshould\snot\sdepend\son\sthe\sFROM\sclause\seither.\sIt\sis\snot\scertain\sthat\sthis\scan\sbe\sreproduced\son\sall\smachines.\r\n\r\nCREATE\sTABLE\st0\s(c0);\s<br\s/>\r\nCREATE\sTABLE\st1\s(c1\sREAL);\s<br\s/>\r\n\r\nINSERT\sINTO\st1(c1)\sVALUES\s(8366271098608253588);\s<br\s/>\r\nINSERT\sINTO\st0(c0)\sVALUES\s('a');\s<br\s/>\r\n\r\nSELECT\s*\sFROM\st1\sWHERE\s(t1.c1\s=\sCAST(8366271098608253588\sAS\sREAL));\s--\sfetches\srow\s<br\s/>\r\nSELECT\s*\sFROM\st0,\st1\sWHERE\s(t1.c1\s=\sCAST(8366271098608253588\sAS\sREAL));\s--\sfetches\sno\srow\s<br\s/>\r\nSELECT\s*\sFROM\st0,\st1\sWHERE\s(t1.c1\s>=\sCAST(8366271098608253588\sAS\sREAL)\sAND\st1.c1\s<=\sCAST(8366271098608253588\sAS\sREAL));\s--\sfetches\srow
J login mrigger
J mimetype text/x-fossil-wiki
J severity Critical
J status Open
J title REAL\srounding\sseems\sto\sdepend\son\sFROM\sclause
J type Code_Defect
K 3c27b97e319a263a607253b34270f4747ef8fac6
U mrigger
Z 767a157815bcda0c64164c196df263c4