Hacker News new | ask | show | jobs
by hprotagonist 1895 days ago
It sure does: https://0.30000000000000004.com/
2 comments

Their summary of Mysql 5.6 (https://0.30000000000000004.com/#mysql) isn't telling the whole story.

"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
Which feels odd to me.

http://sqlfiddle.com/#!9/2e75e/3

You're at 32-bit precision there.
God I love that the Internet does things like this. Thanks, this put a smile on my face today.