[Bug]: Postgres | Unable to retrieve Money datatype table records if value contains more than 3 digits (before decimal)

[Aishwarya-U-R]

Is there an existing issue for this?

• [X] I have searched the existing issues

Description

Until 3 digits - the select query runs fine:

Insert a new record with 4 digits - example starting from 1000 & encounter the issue:

Steps To Reproduce

1. Connect to a Postgres DS
2. Create a table with money datatype create table moneyType(id serial primary key, cash money not null)
3. Insert records until 3 digits: eg : 999.99 & observe data retrieval is as expected -INSERT INTO public."moneyType" ("cash") VALUES ('999.98996998');
4. Now Insert another record with cash value 1000 or more
5. Try retrieval & observe the error in Select
6. Expected: money datatype should support the full range [-92233720368547758.08 to +92233720368547758.07] & allow user to insert & retrieve any value within this range just fine

Public Sample App

No response

Version

Prod/Release v1.7.2

[rohan-arthur]

can replicate this even with simpler data