I've noticed that while creating UNIT tests with mock data that data columns which have the domain with Data type decimal do not show up in the mock tests.
In this example on the table “voorraad” i have a column named “voorraad_aantal”
When changing the datatype of the domain from decimal to numeric the column does show up.
when looking into the table “data_set_col_selection” which is what you see
then script shows during creation that it has the following when statement
it checks the table dttp if the .calulated is 0
when checking the dttp table with the following query
select
dt.prog_lang_id
,dt.dttp_id
,dt.calculated
from dttp dt
where dt.dttp_id in ('NUMERIC', 'DECIMAL') and dt. prog_lang_id = 'SQL'the result shows that for decimal the value is null and for numeric is 0
Is there a reason for this? it the use of numeric preferable?
In the current model that I'm working in the datatypes are all set to DECIMAL. Changing this to NUMERIC fixes the problem with being unable to create unit tests.
