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

Searchablity check is too broad

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.7
    • 7.4
    • Query Engine
    • None
    • Release Notes, Compatibility/Configuration
    • Workaround Exists
    • 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

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: