Export to GitHub

sqlite-jdbc - issue #12

ResultSetMetaData is inconsistent for decimal columns

Posted on Oct 5, 2011 by Grumpy Dog

If a table contains a decimal column, the ResultSetMetaData returned for the query gives different type information for that column depending upon the order of the results. If the first row is an integer value, the ResultSetMetaData returns Types.INTEGER instead of Types.FLOAT or Types.DECIMAL as would be expected.

The attached patch demonstrates the issue.

 Attachments

Comment #1

Posted on Nov 7, 2012 by Swift Horse

for REAL columns too.

Status: New

Labels:
Type-Defect Priority-Medium AffectedVersion-3.7.x FixedVersion-NA