Menu

#377 Float numeric field precision loss in output (DBMS:Oracle)

None
closed-fixed
5
2018-12-22
2006-04-17
Anonymous
No

When selecting whole floating number field, all is ok
(see attached picture 1). When selecting some
expression like devision (see attached picture 2),
function (round() etc), (see attached picture 3).

Discussion

  • Nobody/Anonymous

    Pictures embedded in MS Word file

     
  • lombart

    lombart - 2006-05-09

    Logged In: YES
    user_id=1519646

    Same problem with 2.2 final and Postgresql.
    Simple table tt with one column (x float) and one row (x = 1.5).

    select x from tt => displays 1.5 (columnType = 8, float8)
    select 1.5 from tt => displays 2 (columnType = 2, numeric)

    I am reverting back to 2.1, which did not exhibit this problem.

     
  • Rob Manning

    Rob Manning - 2007-04-01
    • assigned_to: nobody --> manningr
    • status: open --> closed-fixed
     
  • Rob Manning

    Rob Manning - 2007-04-01

    Logged In: YES
    user_id=1287991
    Originator: NO

    Fixed in CVS. I believe this was the same issue as 1635875 (Since Version 2.3 strange conversions take place). In any case, the test given by user lombart below passes now on both Oracle and PostgreSQL.

    Rob

     

Log in to post a comment.