SQLite

Artifact [e0c5eb96]
Login

Artifact e0c5eb961e23da448f554f2c00ed2b3d8e7fca0056905f8e4bd2ff4266474f10:

Ticket change [e0c5eb96] - Ticket [674385ae] CAST('-0.0' AS NUMERIC) computes 0.0 rather than 0 status still Open with 3 other changes by mrigger 2019-06-12 14:12:25.
D 2019-06-12T14:12:25.058
J icomment I\sthink\sthat\swhat\s"lossless"\smean\sin\sthis\scontext\sis\sup\sto\sinterpretation.\sIn\ssome\ssense,\sall\sconversions\sare\slossful.\sFor\sexample,\sboth\s'1.0'\sand\s'1'\sare\sconverted\sto\s1\sand\sit\sis\snot\spossible\sto\sdetermine\swhether\sthe\soriginal\sstring\swas\s'1.0'\sor\s'1'.\r\n\r\n<pre>\r\nSELECT\sCAST('1.0'\sAS\sNUMERIC);\s--\s1\r\nSELECT\sCAST('1'\sAS\sNUMERIC);\s--\s1\r\n</pre>
J login mrigger
J mimetype text/x-fossil-wiki
K 674385aeba91c774d47736f1aefd259b074dc5d3
U mrigger
Z bda16cf6e1a87ab374b354b783391e24