Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-18842

Float values stored using DOUBLE PRECISION instead of REAL in PostgreSQL

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.7.0alpha1
    • Component/s: Database related
    • Labels:
      None

      Description

      In MySQL, all float values are using the FLOAT type which results (without an additional precision value which is never used in ezp) in a 4 bytes floating point number.
      In PostgreSQL, all float values are stored using "double precision" which corresponds to MySQL's DOUBLE [PRECISION]. Those are 8 bytes floating point numbers.
      The correct equivalent for FLOAT is "real" in PostgreSQL.

      http://www.postgresql.org/docs/8.1/static/datatype.html
      http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

      The "db upgrade check" feature also contains those confusions.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              pa@ez.no Patrick Allaert
              Reporter:
              pa@ez.no Patrick Allaert
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: