When using the decimal dynamic attribute the decimal places aren’t being persisted. It’s simply rounding to the integer. I looked at the DOUBLE_VALUE data type in the SYS_ATTR_VALUE table of my SQL Server and it looks like it is using numeric(18,0) which obviously won’t be able to store any decimal places. Is this something I can configure? Is this a bug?
Thank you for reporting the problem. We are going to fix it.
As a workaround, you can manually adjust format of the column in your DB.
Change type of the following columns to “double precision”:
- double_value in sys_attr_value
- default_double in sys_category_attr
Thanks for looking into this. I think for our implementation we were still hoping to use the numeric type to maintain pure precision instead of using a double. We’ve adjusted the numeric type to control how many decimal places that we would like to store. Do you see any issue with this? Thanks.
See the following issue in our bug tracker: