Oracle number issue

Note: please leave bug reports and feature requests on

Oracle number issue

Postby wsc0918 » Thu Jul 12, 2012 1:04 pm

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.
wsc0918
 
Posts: 39
Joined: Thu Jul 12, 2012 12:59 pm

Re: Oracle number issue

Postby Serge » Mon Jul 16, 2012 9:37 pm

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!
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Oracle number issue

Postby wsc0918 » Wed Jul 18, 2012 6:18 am

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.
wsc0918
 
Posts: 39
Joined: Thu Jul 12, 2012 12:59 pm

Re: Oracle number issue

Postby Serge » Mon Jul 23, 2012 11:04 am

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

Thanks for report!
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Oracle number issue

Postby wsc0918 » Tue Jul 24, 2012 7:01 am

Really thanks for your great effort~
wsc0918
 
Posts: 39
Joined: Thu Jul 12, 2012 12:59 pm


Return to Support



Who is online

Users browsing this forum: No registered users and 24 guests