What data type to use so that 1 and 1.0 are both valid in Datomic?

Question

{
  :db/id #db/id[:db.part/db]
  :db/ident :outcome/weighting
  :db/valueType :db.type/float
  :db/cardinality :db.cardinality/one
  :db.install/_attribute :db.part/db 
}

I get an error when I try and add 1 to the entity.

:message "java.lang.IllegalArgumentException: :db.error/wrong-type-for-attribute Value 1 is not a valid :float for attribute :outcome/weighting"

It works fine if I pass in 1.0.

I appreciate that (= (float? 1) false) but is there any other way I can avoid this via Datomic settings without parsing the incoming EDN and adjusting from 1 to 1.0?

Answer 1

You can't store both ints and floats in the same schema attribute in Datomic. So you'll need to coerce the value to whatever type you pick (probably float or double here) appropriately before transacting it. You can do this in the code performing the transaction, or could even do it in a transaction function.