SQL Floating Point Datatypes misrepresented [DB2]
Posted:
Fri Jun 24, 2011 8:34 pmby northw
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
Thanks!
Re: SQL Floating Point Datatypes misrepresented [DB2]
Posted:
Sun Jun 26, 2011 10:57 amby Support
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!