[DERBY-2259] DatabaseMetaData.getTypeInfo() SEARCHABLE column returns incorrect information for types that cannot be searched.

• 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: Test
• Assignee: Saurabh Vyas
• Reporter: Daniel John Debrunner
• Created: 19/Jan/07 18:38
• Updated: 21/Jan/11 17:49
• Resolved: 07/Feb/07 03:58

Description

These types cannot be searched (I think) and should have the value DatabaseMetaData.typePredNone

Types.LONGVARBINARY returns DatabaseMetaData.typePredBasic
Types.LONGVARCHAR returns DatabaseMetaData.typeSearchable
Types.BLOB returns DatabaseMetaData.typePredChar;
Types.CLOB returns DatabaseMetaData.typePredChar;

Issue Links

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