You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Kathey Marsden (JIRA)" <ji...@apache.org> on 2008/12/08 17:44:46 UTC

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

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

Kathey Marsden reassigned DERBY-195:
------------------------------------

    Assignee:     (was: Francois Orsini)

> 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
>
> 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.
-
You can reply to this email to add a comment to the issue online.