Re: Solution for numeric types in direct table

[shmuel]

Solution for numeric types in direct table

I was having an issue where due to performance reasons I created a corteza module with a direct table mapping (not using json, mapping to colums). This made the bulk insert of records much faster, however, values were being rounded up to nearest whole number. Not sure if this happened because I created the table and did not select right precision, but the fix was easy. Enter the database and change the numeric field type from (3,0) to (5,2) or whatever precision you need. Then inserts from c…

This post was closed by an admin, but I had something relevant to add.

There is a github issue to track this bug:

The precision UI is misleading