Hello!
I am working since years on a Mac (M1) with VM-Tool Parallels within a Windows ARM version.
Recently I have a problem with updating any float values in the database.
It's really strange.
If I want to update 1 field with type "float", "double", "real", ... it writes them "wrong".
Examples:
update table1 set float_value = 1; -> 1
update table1 set float_value = 1.0; -> 0
update table1 set float_value = 1.01; -> 0
update table1 set float_value = 1.001; -> 1.024
update table1 set float_value = 1.535; -> 1.024
update table1 set float_value = 1.536; -> 2.048
update table1 set float_value = 1.5371; -> 1.536
update table1 set float_value = 1.53711; -> 1.536
update table1 set float_value = 1.537111; -> 1.537024
update table1 set float_value = 1.5371111; -> 1.5371264
Can someone see any logic???
Other SQL-Tools like (SQLite Expert) works just fine with the same database and SQL-Update command.