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?
Hi,
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.