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

Rewrite of case with true condition is not correct

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Critical Critical
    • 8.4, 7.7.8
    • 6.0.0
    • Query Engine
    • None

      If a secondary searched case condition is always true, then the case will be inappropriately rewritten as just the then expression:

      case when ... when true then x else y end

      becomes just

      x

      However the prior cases should still be considered.

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

              Created:
              Updated:
              Resolved: