jaybird icon indicating copy to clipboard operation
jaybird copied to clipboard

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

Open firebird-automations opened this issue 7 years ago • 1 comments

Submitted by: @mrotteveel

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)

firebird-automations avatar Jan 17 '18 17:01 firebird-automations

Modified by: @mrotteveel

priority: Major [ 3 ] => Minor [ 4 ]

firebird-automations avatar Jan 17 '18 17:01 firebird-automations