Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-9521

Number custom field precision is 6 in db but only 3 in view

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Resolved Locally
    • Icon: Medium Medium
    • None
    • 3.5.1
    • None
    • Jira 3.5.1 Enterprise standalone with mysql db on linux

      It is possible to input float values into a custom field of type Number with any precision.
      A maximum precision of 6 digits after decimal point is stored into the database.
      I can recover the complete value if I ask for the XML view of the issue.
      Any other view (Issue page, Navigation page, Word, Excel) show only a maximum of 3 digits
      to the right of the decimal point. The number is rounded up.

      I have a big problem with this because I used a custom Number Field to store a revision number
      containing a dot. I would like to change this number to a text field, but this means I'll lost all values
      stored in the database, because I see no other way than deleting the field and creating it anew.
      When I noticed that every number is rounded up to 3 digits after the decimal point it was too late.
      3 digits is quite a little precision! Why this limit? Is there any workaround?

      Regards Bettina Zucker

              Unassigned Unassigned
              22a146e1ed05 Bettina Zucker
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: