Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-2793

Searchablity check is too broad

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 7.4
    • Fix Version/s: 8.7
    • Component/s: Query Engine
    • Labels:
      None
    • Affects:
      Release Notes, Compatibility/Configuration
    • Workaround:
      Workaround Exists
    • Workaround Description:
      Hide

      Alter the searchability metadata to make the column searchable. Or use a preserved inline view to project the value to be compared.

      Show
      Alter the searchability metadata to make the column searchable. Or use a preserved inline view to project the value to be compared.

      Description

      The check against searchabilty metadata gathers all column references in an expression, rather than checking just the expression itself. This was done probably to prevent comparisons such as convert(clob_col, string) = 'foo' - but this is inconsistent as we will happily push the same convert function in the select clause.

        Attachments

          Activity

            People

            Assignee:
            shawkins Steven Hawkins
            Reporter:
            shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: