Firebird 4: Support for increased precision of NUMERIC and DECIMAL (DEC_FIXED) [JDBC516] #552
Comments
Modified by: @mrotteveelFix Version: Jaybird 4 [ 10441 ] Component: JDBC driver [ 10053 ] description: Firebird 4 adds increased precision up to 34 digits for NUMERIC and DECIMAL, internally called DEC_FIXED which utilizes a Decimal128 internally. Jaybird needs to add support for type DEC_FIXED, and type information should be updated (when connected to Firebird 4 or higher) to indicate the increased precision available. Open issues: how does DEC_FIXED work with scale (eg is the Decimal128 only used to represent the integral value, or is the Decimal128 value itself scaled, and how (if at all) is the precision limited (ie does a NUMERIC(20,2) also accept a precision 34 number, or not). |
Modified by: @mrotteveelassignee: Mark Rotteveel [ avalanche1979 ] |
|
Commented by: @mrotteveel Implemented |
|
Commented by: @mrotteveel Reopened: DatabaseMetaData.getTypeInfo() needs to be modified for the larger precision supported with DEC_FIXED |
|
Commented by: @mrotteveel Fixed getTypeInfo |
Modified by: @mrotteveel |
Modified by: @mrotteveelstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: @mrotteveel
Jira_subtask_inward JDBC466
Is replaced by JDBC595
Firebird 4 adds increased precision up to 34 digits for NUMERIC and DECIMAL, internally called DEC_FIXED which utilizes a Decimal128 internally. Jaybird needs to add support for type DEC_FIXED, and type information should be updated (when connected to Firebird 4 or higher) to indicate the increased precision available.
Open issues: how does DEC_FIXED work with scale (eg is the Decimal128 only used to represent the integral value, or is the Decimal128 value itself scaled, and how (if at all) is the precision limited (ie does a NUMERIC(20,2) also accept a precision 34 number, or not).
Commits: 6edfc7b 1ca24ab
The text was updated successfully, but these errors were encountered: