appsmithorg / appsmithorg/appsmith

[Bug]-[700]:For numeric datatype in postgresql, field automatically truncates after 18 digits

Open
#8,484 1 comment 0 reactions 0 assignees View on GitHub
Bug Datatype issue Integrations Product Medium Needs Triaging Postgres Production Query & JS Pod Query Widgets & IDE Pod
Dominant language
TypeScript
Stars
40.9k
Forks
4.8k
Avg merge
1d 22h
Merged PRs (30d)
45

Description

### Is there an existing issue for this?

- [X] I have searched the existing issues

### Current Behavior

When the datatype for postgres is numeric with more than 18 digits Appsmith truncates the number to 18 digits only. User on discord reported this issue :
`we have a postgresql as a database where we query on of the table. There is one field (numeric(19) ) when we query it, somehow appsmith truncates this value to 18 digits automatically.
There are some other fields of type numeric where values are not very long and for those fields it works fine.`

### Steps To Reproduce

```markdown
1. Create postgres table with Numeric(18) as one of the field
2. Try select query on the table with numeric value greater than 18 digits
3. Query fails
```

### Environment

Production

### Version

Cloud

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.