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

["Knut Anders Hatlen (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DERBY-195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Knut Anders Hatlen closed DERBY-195.
------------------------------------

    Resolution: Not A Problem

Closing this bug report with resolution Not A Problem on the assumption that returning true is OK in this situation. If we find information that suggests otherwise, it should be reopened.
                
> isSearchable() returns true for a calculated field
> --------------------------------------------------
>
>                 Key: DERBY-195
>                 URL: https://issues.apache.org/jira/browse/DERBY-195
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.0.2.0
>         Environment: Windows XP SP1 Professional
>            Reporter: George Baklarz
>              Labels: derby_triage10_5_2
>
> 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. 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira