Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-2000

Wrong PostgreSQL data type for REAL - "float8", must be "float4"

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.1.0
    • 2.2.0
    • jdbc, sql
    • None
    • PostgreSQL

    Description

      In PostgresDictionary type names for SQL REAL and DOUBLE types are specified as:
      realTypeName = "FLOAT8";
      doubleTypeName = "DOUBLE PRECISION";
      From PostgreSQL manual:
      double precision: float8, double precision floating-point number (8 bytes)
      real: float4, single precision floating-point number (4 bytes)

      realTypeName must be "FLOAT4".

      Attachments

        1. OPENJPA-2000.patch
          0.5 kB
          Jacob Nowosatka

        Activity

          People

            jtnowosatka Jacob Nowosatka
            s.mironov Stanislav Mironov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 5m
                5m
                Remaining:
                Remaining Estimate - 5m
                5m
                Logged:
                Time Spent - Not Specified
                Not Specified