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

Derby

DatabaseMetaData.getTypeInfo() SEARCHABLE column returns incorrect information for types that cannot be searched.

Created: 19/Jan/07 06:38 PM Updated: 25/Jul/08 05:35 PM

Return to search

Component/s:

Test

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

Time Tracking:

Not Specified

Issue Links:

Incorporates

This issue is part of:

~~DERBY-2258~~ DatabaseMetaData.getTypeInfo() does not list supported Derby SQL types correctly.

Resolution Date:

07/Feb/07 03:58 AM

Description

« Hide

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;

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

Saurabh Vyas made changes - 30/Jan/07 06:06 AM

Field	Original Value	New Value
Assignee		Saurabh Vyas [ sv204098 ]

Saurabh Vyas made changes - 30/Jan/07 01:46 PM

Link

This issue is part of ~~DERBY-2258~~ [ ~~DERBY-2258~~ ]

Saurabh Vyas made changes - 07/Feb/07 03:58 AM

Status	Open [ 1 ]	Resolved [ 5 ]
Resolution		Fixed [ 1 ]

Kathey Marsden made changes - 14/May/07 04:22 PM

Fix Version/s

10.3.0.0 [ 12310800 ]

Kathey Marsden made changes - 25/Jul/08 05:35 PM

Component/s

Test [ 11413 ]