Artifact
f550c0f0179a89552df5905e36ef0b96c4bda5438709fded13d0985929207cb8:
Ticket change
[f550c0f0]
- New ticket
[dd6bffbf] CAST to NUMERIC no longer converts to INTEGER.
by
mrigger
2019-06-08 21:31:57.
D 2019-06-08T21:31:57.902
J icomment Consider\sthe\sfollowing\sexample:\r\n\r\n<pre>\r\nCREATE\sTABLE\st0\s(c0\sTEXT);\r\nINSERT\sINTO\st0(c0)\sVALUES\s('1.0');\r\nSELECT\sCAST(c0\sAS\sNUMERIC)\sFROM\st0;\s--\sexpected:\s1,\sactual:\s1.0\r\n</pre>\r\n\r\nFrom\sthe\sfollowing\spart\sof\sthe\sdocumentation,\sI\swould\sexpect\sthat\sthe\sthe\svalue\s'1.0'\sis\sconverted\sto\s1:\r\n\r\n<pre>\r\nCasting\sa\sTEXT\sor\sBLOB\svalue\sinto\sNUMERIC\sfirst\sdoes\sa\sforced\sconversion\sinto\sREAL\sbut\sthen\sfurther\sconverts\sthe\sresult\sinto\sINTEGER\sif\sand\sonly\sif\sthe\sconversion\sfrom\sREAL\sto\sINTEGER\sis\slossless\sand\sreversible.\r\n</pre>\r\n\r\nI\sremember\sthat\sthis\spreviously\sworked\sas\sI\swould\sexpect.\sCould\sthis\sbe\sa\sregression\scaused\sby\s[67a68af5578f08d2]?
J login mrigger
J mimetype text/x-fossil-wiki
J severity Critical
J status Open
J title CAST\sto\sNUMERIC\sno\slonger\sconverts\sto\sINTEGER
J type Code_Defect
K dd6bffbfb6e61db9ecc9ea833d586427961ccc9d
U mrigger
Z 309ed960debd80ef3d3f8cce807879fc