Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-884

complex join conditions should be supported in ON clause

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.9.0
    • Component/s: Planner/Optimizer
    • Labels:
      None

      Description

      join condition can be complex expressions instead of simple equi-join condition of fields.

      See the example where t3.id is INT4 and t4.id INT8. In this case, t3.id and t4.id are different but compatible to each other. In this case, current planner handles the expression incorrectly.

      select * from table3 t3 join table4 t4 on t3.id = t4.id;
      

      Also, please see the following example. Currently, the following join condition does not work.

      select * from table3 t3 join table4 t4 on substr(t3.key, 1, 4) = t4.key;
      

        Attachments

          Activity

            People

            • Assignee:
              hyunsik Hyunsik Choi
              Reporter:
              hyunsik Hyunsik Choi
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: