Issue Details (XML | Word | Printable)

Key: JDBC-516
Type: Sub-task Sub-task
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Mark Rotteveel
Reporter: Mark Rotteveel
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
Jaybird JDBC Driver

Firebird 4: Support for increased precision of NUMERIC and DECIMAL (DEC_FIXED)

Created: 17/Jan/18 04:33 PM   Updated: 14/Mar/20 02:20 PM
Component/s: JDBC driver
Affects Version/s: None
Fix Version/s: Jaybird 4

Issue Links:

 Description  « Hide
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).

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Rotteveel added a comment - 31/Mar/18 12:25 PM

Mark Rotteveel added a comment - 29/Sep/18 03:04 PM
Reopened: DatabaseMetaData.getTypeInfo() needs to be modified for the larger precision supported with DEC_FIXED

Mark Rotteveel added a comment - 03/Nov/18 05:18 PM
Fixed getTypeInfo