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

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Medium Medium
    • 4.7.0alpha1
    • None
    • Database related
    • 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

        Activity

          People

            e8318ba6-e4ae-477c-9116-36c073bd11a3@accounts.ibexa.co Patrick Allaert
            e8318ba6-e4ae-477c-9116-36c073bd11a3@accounts.ibexa.co Patrick Allaert
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: