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

Allow the optional join hint to work with non-ansi joins

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Major Major
    • 7.4
    • 7.4
    • Query Engine
    • Documentation (Ref Guide, User Guide, etc.)
    • Low

      The optional join hint currently works only in ansi joins, and then only if the table(s) are not used in where predicates forcing unnatural on clauses.

      e.g. select b.* from /*+optional*/ a, b where a.x = b.x

      should still allow a to be optional.

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

              Created:
              Updated:
              Resolved: