Derby
  1. Derby
  2. DERBY-195

isSearchable() returns true for a calculated field

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Not a Problem
    • Affects Version/s: 10.0.2.0
    • Fix Version/s: None
    • Component/s: JDBC
    • Environment:
      Windows XP SP1 Professional
    • Urgency:
      Normal
    • Bug behavior facts:
      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.

        Activity

        Gavin made changes -
        Workflow jira [ 41394 ] Default workflow, editable Closed status [ 12796755 ]
        Knut Anders Hatlen made changes -
        Status Open [ 1 ] Closed [ 6 ]
        Resolution Not A Problem [ 8 ]
        Kathey Marsden made changes -
        Labels derby_triage10_5_2
        Mike Matrigali made changes -
        Bug behavior facts [Deviation from standard]
        Urgency Normal
        Kathey Marsden made changes -
        Assignee Francois Orsini [ forsini ]
        Francois Orsini made changes -
        Field Original Value New Value
        Assignee Francois Orsini [ forsini ]
        George Baklarz created issue -

          People

          • Assignee:
            Unassigned
            Reporter:
            George Baklarz
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development