dbeaver: Wrong precision visible for numeric datatype (result grid) with Postgres
System information:
- Operating system Win 10
- DBeaver version 5.3.3
- Java version
Description
When using the grid view for results, numeric datatypes are truncated for display. When double clicking into the result cell, it shows the correct precision. Text result view also shows the correct precision.
This can lead to user confusion 😉 Not sure if locale settings also play a role here.
Steps to reproduce:
SELECT 123.4::numeric(9,6);


About this issue
- Original URL
- State: closed
- Created 5 years ago
- Comments: 18 (9 by maintainers)
Commits related to this issue
- #5077 Numbers formatter - type scale limit fix — committed to dbeaver/dbeaver by serge-rider 5 years ago
This is configurable in preferences (global or connection-specific). You can change minimum fraction digits:
In plaintext mode DBeaver uses native numbers representation by default.