appsmithorg / appsmithorg/appsmith

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

Ouverte
#8,484 1 commentaire 0 réactions 0 personnes assignées Voir sur GitHub
Bug Datatype issue Integrations Product Medium Needs Triaging Postgres Production Query & JS Pod Query Widgets & IDE Pod
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.

Recevez les nouvelles issues par e-mail

Un résumé court des issues GitHub adaptées aux débutants.