Hey Mathieu,
This is not actually a bug, but a feature :)
MonetDB encodes null values of numeric columns by a specific value. This is
typically the lowest possible value in that column, or close to the lowest
possible value for that column. For doubles, the null value is encoded
as -1.7976931348623157e308,
thus if you insert this value into the database it will be interpreted as
null.
Is there any specific reason you need this value in the database?
Regards,
Mark
On Fri, Nov 27, 2015 at 4:37 PM, Mathieu Raillard
Hi all,
We found a strange case this week when testing some insert.
We tried to insert -1.7976931348623157e308 in a double value and we get a null in the column.
Data to reproduce the case :
create table test.testdouble ( id int, testdouble double, primary key (id) )
insert into test.testdouble (id,testdouble) values (1, -1.7976931348623157e308)
select * from test.testdouble
Regards
Mathieu
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list