Negative decimal number issue in Livelink

We are using Oracle 11g and CS 10. Livelink is behaving weird when I am storing a negative decimal number (-0.17) in a Number column in table and retrieving back to that using a simple select query, Livelink is returning (-0.17000000000000001). It’s weird because when I run the same query in PL/SQL developer its showing me -0.17. don't know why Livelink adding all these zeros.

Let me know if any one came across this or any similar issue before

Negative Decimal Number issue.png

Find more posts tagged with

Comments

David Templeton

What is the particular version of oracle client? 11.2.0.????? ( check the top of the connect log ) there have been issues with certain client libraries

David

gaurav_shukla

Below information is from connect log

09/29/2015 10:10:12 INFO [1877679702] 0000000067: KSqlOCI10::SubclassConnect() connect success. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning option

Keit Kivisild

Hello,

I am not sure if it is Oracle related problem.

I have found there is a problem with real data type in general. Real numbers calculations give unexpected results.

Try to create a script in builder and run it:

function RealTest()

   Real r = 1.2
   Real rr = 1.4
   Real rrr = 1.8

   Real result = rrr-r-rr
   echo( Str.Format( 'The result of "1.2 - 1.4 - 1.8 = %1"', result ) )

   echo('end')
end

The result in my case is

The result of "1.2 - 1.4 - 1.8 = -0.7999999999999998"
end

My work around has been to convert real nmbers to integers by pow function and after calculations convert to real again.

Regards,

keit

gaurav_shukla

Thanks Keit,

I also think this it is not an Oracle problem, it is something with Livelink floating number. Actually I am not doing any calculation; I am just getting back this number from table.

Carsten_Kulms

This is not an issue with the OScript data type "Real".These results are expected, indeed. It is inherent to floating-point numbers that arithmetic operations are not exact.btw: In your example (result==.8) holds (different to Java, for example, though "result" is -0.7999999999999998 with Java also)

Keit Kivisild

Hello,

Is there any improvements regarding negative real numbers handling?

Current situation is problematic, it is not possible to add negative real numbrs for category attributes for instance.

If you add value "-825.32" and after submit value will be "-825.3200000000001"

OT, any suggestions? not to use real datatype is not option for us.

Regards,

keit