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

Queries fail against SYS.Datatypes with predicates on columns other than name

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 9.2
    • None
    • Query Engine
    • None

      The datatiermanager logic is incorrect for datatypes. Any sargable predicate on a column other than the pk name, for exampl:

      select * from SYS.DataTypes where isStandard = true

      will fail with an index out of bounds exception as we're allowing the predicate to be used effectively against the name index.

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

                Created:
                Updated:
                Resolved: