Hi Team, I am very frustated with this decimal datatype related issue. Can someone from team solve or atleast clear if it is a denodo server behaviour. I am creating a table something like below,
**Table I created using the below syntax:**
create materialized table testdecimal(decimalCol : decimal);
**After this I am inserting the following values:**
insert into testdecimal values('1234.12345');
insert into testdecimal values('123456789123456.1111111111');
insert into testdecimal values('1234567891234567.111111111');
insert inot testdecimal values('12345678912345678.11111111111');
insert inot testdecimal values('12345678912345678.11');
**Result**
I am seeing as 4 rows got updated but in reality if I perform select on that particular table by using** select * from testdecimal**, I was seeing only two values(i.e., 1234.12345, 123456789123456.1111111111) and the remaining three values I was unable to see. After carefully analysing I was able to find that, if the number of digits before decimal point is greater than 15 then whatever be the scale, the value is not getting inserted into the database. **Is this a known problem or is there any workaround that we could try?**
**Note**: I am seeing decimal types **(precision,scale) = (38,20)** in getColumns() metadata call.
