appsmithorg / appsmithorg/appsmith

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

Offen
#8,484 1 Kommentar 0 Reaktionen 0 zugewiesene Personen Auf GitHub ansehen
Bug Datatype issue Integrations Product Medium Needs Triaging Postgres Production Query & JS Pod Query Widgets & IDE Pod
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

Beitragsleitfaden öffnen

Bewertung

Dieses Issue wurde noch nicht bewertet.

Neue Issues direkt in Ihr Postfach

Eine kurze Übersicht über anfängerfreundliche GitHub-Issues.