Oracle number issue

[wsc0918]

Dear, I occur some problem.
In Oracle column type defined as 'Number' and I can save 0.987 into it.
But when I use dbeaver to do this, it save as 0.
Does there any body occurs such situation?
Or is there any miss setting in my dbeaver or DB?
Thanks.

[Serge]

Hi!

Could you say how exacly this column datatype was declared? Even better if you'd send table's DDL. Also please specify Oracle server version.
We had similar problem a time ago but it was fixed. Probably some very specific datatypes are still not handled properly..

Thanks for report!

[wsc0918]

Oracle version: 10g 10.2.0.5.0 - 64bit
and table ddl as follow:
create table TO_DO(
ID number;
H_ID number
,L_ID number
,D_ID number
,O_C varchar2(50)
,HOURS number;
);
and 3 index as follow:
(H_ID, L_ID)
(D_ID)
(L_ID, O_C)
When I edit HOURS with [Content Editor], then digit number 0.88 will be saved as 0.
I hope you can understand.
Anyway thanks for your effort.

[Serge]

Yep, it is a bug in DBeaver.
It will be fixed in next version (planned on next week)

Thanks for report!

[wsc0918]

Really thanks for your great effort~