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)
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)