Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-195

isSearchable() returns true for a calculated field

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Not A Problem
    • 10.0.2.0
    • None
    • JDBC
    • Windows XP SP1 Professional
    • Normal
    • Deviation from standard

    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.

      Attachments

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            baklarz George Baklarz
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment