You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Stanislav Mironov (JIRA)" <ji...@apache.org> on 2011/05/14 13:41:47 UTC

[jira] [Created] (OPENJPA-2000) Wrong PostgreSQL data type for REAL - "float8", must be "float4"

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

                 Key: OPENJPA-2000
                 URL: https://issues.apache.org/jira/browse/OPENJPA-2000
             Project: OpenJPA
          Issue Type: Bug
          Components: jdbc, sql
    Affects Versions: 2.1.0
         Environment: PostgreSQL
            Reporter: Stanislav Mironov


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".

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (OPENJPA-2000) Wrong PostgreSQL data type for REAL - "float8", must be "float4"

Posted by "Jacob Nowosatka (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-2000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacob Nowosatka updated OPENJPA-2000:
-------------------------------------

    Attachment: OPENJPA-2000.patch

realTypeName changed to FLOAT4

> Wrong PostgreSQL data type for REAL - "float8", must be "float4"
> ----------------------------------------------------------------
>
>                 Key: OPENJPA-2000
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2000
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jdbc, sql
>    Affects Versions: 2.1.0
>         Environment: PostgreSQL
>            Reporter: Stanislav Mironov
>         Attachments: OPENJPA-2000.patch
>
>   Original Estimate: 5m
>  Remaining Estimate: 5m
>
> 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".

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Issue Comment Edited] (OPENJPA-2000) Wrong PostgreSQL data type for REAL - "float8", must be "float4"

Posted by "Jacob Nowosatka (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/OPENJPA-2000?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13069024#comment-13069024 ] 

Jacob Nowosatka edited comment on OPENJPA-2000 at 7/21/11 3:24 PM:
-------------------------------------------------------------------

Attached patch changes realTypeName to FLOAT4

      was (Author: jtnowosatka):
    realTypeName changed to FLOAT4
  
> Wrong PostgreSQL data type for REAL - "float8", must be "float4"
> ----------------------------------------------------------------
>
>                 Key: OPENJPA-2000
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2000
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jdbc, sql
>    Affects Versions: 2.1.0
>         Environment: PostgreSQL
>            Reporter: Stanislav Mironov
>         Attachments: OPENJPA-2000.patch
>
>   Original Estimate: 5m
>  Remaining Estimate: 5m
>
> 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".

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Resolved] (OPENJPA-2000) Wrong PostgreSQL data type for REAL - "float8", must be "float4"

Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-2000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Michael Dick resolved OPENJPA-2000.
-----------------------------------

       Resolution: Fixed
    Fix Version/s: 2.2.0
         Assignee: Jacob Nowosatka

Thanks for the patch. 

> Wrong PostgreSQL data type for REAL - "float8", must be "float4"
> ----------------------------------------------------------------
>
>                 Key: OPENJPA-2000
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2000
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jdbc, sql
>    Affects Versions: 2.1.0
>         Environment: PostgreSQL
>            Reporter: Stanislav Mironov
>            Assignee: Jacob Nowosatka
>             Fix For: 2.2.0
>
>         Attachments: OPENJPA-2000.patch
>
>   Original Estimate: 5m
>  Remaining Estimate: 5m
>
> 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".

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Closed] (OPENJPA-2000) Wrong PostgreSQL data type for REAL - "float8", must be "float4"

Posted by "Albert Lee (Closed) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-2000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Albert Lee closed OPENJPA-2000.
-------------------------------


Close issue in preparation for 2.2.0 release.
                
> Wrong PostgreSQL data type for REAL - "float8", must be "float4"
> ----------------------------------------------------------------
>
>                 Key: OPENJPA-2000
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2000
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jdbc, sql
>    Affects Versions: 2.1.0
>         Environment: PostgreSQL
>            Reporter: Stanislav Mironov
>            Assignee: Jacob Nowosatka
>             Fix For: 2.2.0
>
>         Attachments: OPENJPA-2000.patch
>
>   Original Estimate: 5m
>  Remaining Estimate: 5m
>
> 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".

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira