[DERBY-584] Mismatch between DatabaseMetaData and ResultSetMetaData for NUMERIC type

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.1.1.0
• Component/s: JDBC, Network Client
• Labels: derby_triage10_9
• Urgency: Normal
• Bug behavior facts: Embedded/Client difference
• Assignee: Unassigned
• Reporter: Richard N. Hillegas
• Created: 22/Sep/05 08:19
• Updated: 20/Feb/12 22:18

Description

The Derby Reference Manual says that NUMERIC is a synonyn for DECIMAL. If you create a NUMERIC column, the Derby client DatabaseMetaData reports that the type is java.sql.NUMERIC. However, if you select from the table, the ResultSetMetaData reports that the type is java.sql.DECIMAL.

I don't really care what type we report. I just think we should be consistent.

Issue Links

• relates to: DERBY-2285 Mismatch between network client DatabaseMetaData and ResultSetMetaData for BOOLEAN columns (in system tables)