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

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

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.1.0
    • Fix Version/s: 2.2.0
    • Component/s: jdbc, sql
    • Labels:
      None
    • Environment:
      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

            • Assignee:
              jtnowosatka Jacob Nowosatka
              Reporter:
              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