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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.0
• Fix Version/s: 2.2.0
• Component/s: jdbc, sql
• Environment: PostgreSQL
• Assignee: Jacob Nowosatka
• Reporter: Stanislav Mironov
• Created: 14/May/11 11:40
• Updated: 02/Feb/12 17:09
• Resolved: 21/Jul/11 21:58

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