Dynamic Attribute data type of Double not persisting decimal places

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”:

  1. double_value in sys_attr_value
  2. 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.

:ticket: See the following issue in our bug tracker:

https://youtrack.cuba-platform.com/issue/PL-9036