Query Entity rounds large decimal and removes decimal

Question

I've found a query entity in our system that seems to round large decimals and remove everything after the decimal if the overall character length is eight or greater. 
 
 Example: 
 If the value is 12345678.90 the query returns 12345679. 
 
 The DB structure has the field set to decimal(14,2), the CDT is set to a double with the annotation being decimal(14,2), and if the character length is less than eight then it returns the correct value. 
 
 How can I get the DB to return the correct value? 
 
 Thanks!

Mike Schmitt · Answer

You may want to double-check whether it's truly rounding - what I've found recently is that the *displayed result* will be rounded, i.e. when converted to text for displaying, but the inherent value is still correct. One way to check the full value is to take your result and wrap it in the text() function, i.e. text(local!value, "0.00"), to force it to render to 2 decimal places.

Dastagiri Dudekula · Answer

Its advisable that, if you want to retain the same form of the decimal field from db, always use text field with fixed(). Please find the attached screen to observe the value 12345678.90 variations at different fields.