MySql does not seem appreciate infinity values from a Java application.
From a Mysql command line, an infinite value may be placed in the database.
mysql> CREATE TABLE Result
-> value DOUBLE
-> ) TYPE = InnoDB;
Query OK, 0 rows affected (0.23 sec)
mysql> insert into result values(1e500);
Query OK, 1 row affected (0.06 sec)
mysql> select * from result;
| value |
| 1.#INF |
1 row in set (0.02 sec)
But from a Java application the following does not work.
String query = "insert into result values(1e500)";
Statement stmt = null;
stmt = getConnection().createStatement();
stmt.execute( query );
results in the following error message:
"Unknown column 'Infinity' in 'field list'"
I have also tried this as a PreparedStatement with the same results.