Menu

#42 Incorrect double precision values in metadata

open
5
2005-09-02
2005-08-30
Neogetz
No

When trying to extract metadata with table data, the
double precision field contains incorrect value int the sql
file. For examle there's 333333333 in the field but the
SQL contains 333333344. And also the precision part is
not the same as in the DB.

Discussion

  • Ryan J. Mills

    Ryan J. Mills - 2005-09-02
    • assigned_to: nobody --> rjmills
     
  • Ryan J. Mills

    Ryan J. Mills - 2005-10-12

    Logged In: YES
    user_id=351844

    Please check the field type. I get the error your talking
    about only if I use a single precision field. When I use
    the double precision your talking about I don't see the
    error at all.

    Can you load up a sample script that will demonstrate the error?
    A script to create the table and populate it. I can work on
    the select from there.

     

Log in to post a comment.