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.

        Gliffy Diagrams

          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: