[DERBY-2260] DatabaseMetaData.getTypeInfo() returns incorrect precision for VARCHAR FOR BIT DATA

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• 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, 10.3.1.4
• Fix Version/s: 10.3.1.4
• Component/s: JDBC
• Assignee: Saurabh Vyas
• Reporter: Daniel John Debrunner
• Created: 19/Jan/07 19:39
• Updated: 21/Jan/11 17:49
• Resolved: 07/Feb/07 03:59

Description

PRECISION column for VARCHAR FOR BIT DATA is returned as 32762, but maximum precision is 32672 (6 & 7 swapped).

ij> create table z (a varchar(32672) for bit data);
0 rows inserted/updated/deleted
ij> create table z2(a varchar(32673) for bit data);
ERROR 42611: The length, precision, or scale attribute for column, or type mapping 'VARCHAR (32673) FOR BIT DATA' is not valid.

Issue Links

• is part of: DERBY-2258 DatabaseMetaData.getTypeInfo() does not list supported Derby SQL types correctly.