[DERBY-2285] Mismatch between network client DatabaseMetaData and ResultSetMetaData for BOOLEAN columns (in system tables)

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6, 10.2.2.0
• Component/s: JDBC, Network Client
• Labels: derby_triage10_9
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Daniel John Debrunner
• Created: 02/Feb/07 04:30
• Updated: 20/Feb/12 22:18

Description

For BOOLEAN columns (which are only supported as system table columns) DatabaseMetaData.getColumns() returns the column as BOOLEAN while ResultSetMetaData returns the column as a SMALLINT.

Issue Links

• is related to: DERBY-584 Mismatch between DatabaseMetaData and ResultSetMetaData for NUMERIC type