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);

grid

text

About this issue

  • Original URL
  • State: closed
  • Created 5 years ago
  • Comments: 18 (9 by maintainers)

Commits related to this issue

Most upvoted comments

This is configurable in preferences (global or connection-specific). You can change minimum fraction digits: image

In plaintext mode DBeaver uses native numbers representation by default.