SQL Floating Point Datatypes misrepresented [DB2]

Note: please leave bug reports and feature requests on

SQL Floating Point Datatypes misrepresented [DB2]

Postby northw » Fri Jun 24, 2011 8:34 pm

Not sure if this affects other drivers, but for the floating point I see:
(note that this appears both in the tabular view and the edit tuple view

DataType: Actual Value: Displayed Value:

DOUBLE -82.926759 -82
REAL 2.1 2

I'm using version 1.2.0

Posts: 3
Joined: Fri Jun 24, 2011 7:54 pm

Re: SQL Floating Point Datatypes misrepresented [DB2]

Postby Support » Sun Jun 26, 2011 10:57 am

Yes, you are right. Sometimes DBeaver incorrectly handles DOUBLE and REAL numbers (it treats them as big integers). Float, decimal and numeri types are handled ok.
This was just fixed, and new version will contain this bug fix. New release planned on early July.

For now you may get EA version (). It is quite stable in general but contains new plugin (with new Oracle driver) - and it is not yet finished and not well-tested. Anyway, DB2 driver works as before (plus this new bugfix)

Note: this problem appeared in DB2 driver and, probably, in other drivers which provides incorrect information about scale/precision of numeric types. Right now we can't reproduce this issue on any database except DB2 UDB.

Thank you for this report!
Posts: 49
Joined: Thu Mar 17, 2011 10:11 am

Return to Support

Who is online

Users browsing this forum: Google [Bot] and 20 guests