Output Window is rounding floats to integers

Shann Can
2008-11-20
2013-04-29
  • Shann Can
    Shann Can
    2008-11-20

    Hi,

    Has anyone come across this?

    Everytime I run a sql query against a table with float data types in it - the columns are rounded to integers.

    This is while running against a Sybase db.

    I haven't been able to test against other db servers.

    It is pretty annoying and I've gone through , what I think is, every option in the menus and don't see any reference to floats/decimals being rounded to integers.

    Any ideas?

    Thanks...

     
    • Shann Can
      Shann Can
      2008-11-21

      Anyone getting this issue?

      If it helps - I am using the Sybase Adaptive Server Anywhere driver - jconn3.jar.

       
    • Heiko Hilbert
      Heiko Hilbert
      2008-11-21

      I checked this with Adaptive Server 12.5 and jconn3.jar:

      create table t1(x float);
      insert into t1 values(1.345);
      select * from t1;
      drop table t1;

      Th output was:
      1.3449999999999999733546474089962430298328399658203125

      :-)

      Can you run this script against your db.
      I currently have no ASA installed.

       
  • riaan
    riaan
    2009-10-09

    Tested using the script given above, output was 1. This was with MSSQL 2005 and MS sqljdbc driver.

     
  • Heiko Hilbert
    Heiko Hilbert
    2009-10-18

    should be fixed with 3.5.1