Issue - Data Modeling MIN/MAX Integer Precision Loss
Specifying the MIN and MAX constraint for int
is limited to -2^53
and 2^53 -1
, which is less than FeatureBase can actually handle (-2^63
and 2^63 -1
) respectively
Cause
This error can be caused when specifying integers for the MIN and MAX constraints that are outside of the range between -2^53
and 2^53 -1
Precision loss due to Jacascript and Go integer limitations at scale.
Solution
Specify int as the column name with no constraints to apply default values internally.
Further information
INT Data Type Contact FeatureBase support to discuss upgrading your account.
© 2022 Molecula Corp. (DBA FeatureBase). All rights reserved.