Hello, Inserting Nan values in a DOUBLE column seems to work when the insert/merge statement holds a ? placeholder and the NaN value is bound to the parameter, like:
INSERT INTO TABLE(ID,DOUBLE_COLUMN) values (?,?) setParameter 1 => 10 setParameter 2 => Nan (at least, that seems to have been the case at some time because I have tables with Nan values in them that where inserted in the time our application used parameters for all values), but INSERT INTO TABLE(ID,DOUBLE_COLUMN) values (10,NaN) throws an error. The application currently uses literals for (amongst others) DOUBLE typed values and is now no longer able to copy records from one table to the other if the source value is a Nan. Is there a way to do this or do we have to revert to using a parameter in this case? Cheers Silvio -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/f98d82cf-f769-4c51-af64-da3714600f67n%40googlegroups.com.