[DERBY-195] isSearchable() returns true for a calculated field

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 10.0.2.0
• Component/s: JDBC
• Labels: derby_triage10_5_2
• Environment: Windows XP SP1 Professional
• Urgency: Normal
• Bug behavior facts: Deviation from standard
• Assignee: Unassigned
• Reporter: George Baklarz
• Created: 04/Apr/05 09:15
• Updated: 23/Jan/13 12:46
• Resolved: 23/Jan/13 12:46

Description

Issuing a ResultSetMetaData isSearchable() against a computing column returns a TRUE value. i.e. SELECT NAME, ADDRESS, 1 FROM EMPLOYEE .... will return a value of TRUE for isSearchable against the computed value (1) in the SELECT list. Is that what is supposed to be returned for a computed column?

It may be that I misunderstood the semantics for what isSearchable() is supposed to do. I thought that a column with isSearchable()=true can be used in a subsequent WHERE clause.