Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <1733860798.1247262674895.JavaMail.jira@brutus>
Date: Fri, 10 Jul 2009 14:51:14 -0700 (PDT)
From: "Mike Matrigali (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-195) isSearchable() returns true for a
 calculated field
In-Reply-To: <1635295710.1112573776881.JavaMail.jira@ajax.apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Mike Matrigali updated DERBY-195:
---------------------------------

               Urgency: Normal
    Bug behavior facts: [Deviation from standard]

Triaged July 10, 2009: assigned normal urgency. 
marked deviation from standard, work on the issue needs to figure out what the right
behavior is, and if it is indeed a standard issue.

> 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.