Value in Oracle DB is different with SQL query result in budibase

[fghhunter]

Checklist

• [ V] I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Self
  • Method: docker compose
  • Budibase Version: 2.29.1
  • App Version: 2.29.1
• Cloud
  • Tenant ID:

Describe the bug The number field in the result of Oracle SQL query shown in left side has a very small gap against the value stored in DB. Even if use Round method to keep 2 decimal places. Table component view: DB view:

To Reproduce Steps to reproduce the behavior:

1. Connect to Oracle DB
2. Make a query and test, result will show the gap
3. Add table component in the screen, set oracle query as data source, gap will show in the table.

Expected behavior The value of sql query result should be the same with DB.

Screenshots Show above.

App Export

Desktop (please complete the following information):

• OS:Windows10 22H2 [e.g. iOS]
• Browser Chrome 109.0.5414.25 [e.g. chrome, safari]
• Version [e.g. 22]

Additional context Budibase running on Ubuntu2404

[linear[bot]]

BUDI-8634 Value in Oracle DB is different with SQL query result in budibase

[mike12345567]

Hi @fghhunter - sadly this is the nature of numbers in JS - when converted to decimals there is a chance of inaccuracy like this occurring - it is best in these cases to use the query transformer https://docs.budibase.com/docs/transformers to round the JS numbers to get the result set you expect/desire.

[fghhunter]

@mike12345567 thank you, I know nothing about JS, just a non-it staff. but budibase is an amazing tool.