#459 Local format on numeric rounds float values

2.3final
closed
Rob Manning
Unknown (89)
5
2007-04-09
2006-12-04
Turb
No

OS : Windows XP Pro
Java : 5.0 release 8
Version : 2.3 final
I18n : fr
DB : PostgreSQL 8.1-405

A numeric column is displayed "0.66666" when Squirrel uses default format (for SQL types 6, 7, 8, 2, 3) and that's correct according to the database.

When this parameter is changed to "local format", the same value is displayed "1", that is incorrect.

Thanks for all work !

Discussion

  • Rob Manning
    Rob Manning
    2007-03-25

    Logged In: YES
    user_id=1287991
    Originator: NO

    Try the latest snapshot and let us know if this is still an issue. I tried to reproduce using this script:

    CREATE TABLE decimal_type_table
    (
    decimal_column numeric(19,2)
    );

    insert into decimal_type_table values (0.666666)

    select * from decimal_type_table

    And the output is 0.67

    Rob

     
  • Rob Manning
    Rob Manning
    2007-03-25

    • status: open --> pending
     
  • Logged In: YES
    user_id=1312539
    Originator: NO

    This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 14 days (the time period specified by
    the administrator of this Tracker).

     
    • status: pending --> closed