appsmithorg / appsmithorg/appsmith
[Bug]-[700]:For numeric datatype in postgresql, field automatically truncates after 18 digits
- Vorherrschende Sprache
- TypeScript
- Sterne
- 40.9k
- Forks
- 4.8k
- Ø Merge
- 1 T. 22 Std.
- Gemergte PRs (30 T.)
- 45
Beschreibung
### 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
Beitragsleitfaden
Bewertung
Dieses Issue wurde noch nicht bewertet.