appsmithorg / appsmithorg/appsmith
[Bug]-[700]:For numeric datatype in postgresql, field automatically truncates after 18 digits
- Langage dominant
- TypeScript
- Étoiles
- 40.9k
- Forks
- 4.8k
- Merge moyen
- 1 j 22 h
- PR mergées (30 j)
- 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
Guide de contribution
Ouvrir le guide de contribution
Évaluation
Cette issue n'a pas encore été évaluée.