[CALCITE-638] SQL standard REAL is 4 bytes, FLOAT is 8 bytes

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.2.0-incubating
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 20/Mar/15 22:15
• Updated: 16/Apr/15 08:35
• Resolved: 23/Mar/15 22:36

Description

Per the SQL standard,

• the SQL REAL type is a 4 byte floating point number (thus maps to Java float),
• FLOAT is up to 8 bytes (thus maps to Java double), and
• DOUBLE is 8 bytes (thus maps to Java double).

A number of places in Calcite map FLOAT to float values, and I think a few others map REAL to double.

Issue Links

• relates to: CALCITE-630 Flesh out AvaticaParameter#setObject