Issue Details (XML | Word | Printable)

Key: JDBC-515
Type: Bug Bug
Status: Open Open
Priority: Minor Minor
Assignee: Mark Rotteveel
Reporter: Mark Rotteveel
Votes: 0
Watchers: 0

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

DatabaseMetaData.getTypeInfo column FIXED_PREC_SCALE may have wrong value for some types

Created: 17/Jan/18 03:58 PM   Updated: 17/Jan/18 03:58 PM
Component/s: JDBC driver
Affects Version/s: Jaybird 2.2.12, Jaybird 2.2.13, Jaybird 3.0.0, Jaybird 3.0.1, Jaybird 3.0.2, Jaybird 3.0.3, Jaybird 2.2.14, Jaybird 3.0.4, Jaybird 2.2.15, Jaybird 4
Fix Version/s: None

 Description  « Hide
In DatabaseMetaData.getTypeInfo, column FIXED_PREC_SCALE we currently return true for all types that have a fixed precision and scale, the JDBC apidoc however says "FIXED_PREC_SCALE boolean => can it be a money value.", and for example BOOLEAN, all integral types, date/time types etc are not suitable for money values, and string and binary types are also debatable.

Change this to be conservative and only return true for NUMERIC and DECIMAL.

(and maybe check what other drivers do)

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.