"SELECT .1 + .2;" does return 0.3
However,
CREATE TABLE t1 (f FLOAT); INSERT INTO t1 VALUES(0.1),(0.2); SELECT SUM(f) FROM t1; // returns 0.30000000447034836
http://sqlfiddle.com/#!9/2e75e/3
"SELECT .1 + .2;" does return 0.3
However,
Which feels odd to me.http://sqlfiddle.com/#!9/2e75e/3