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

Searchablity check is too broad

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major 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.

      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.

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

                Created:
                Updated:
                Resolved: