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: