Uploaded image for project: 'Tajo (Retired)'
  1. Tajo (Retired)
  2. TAJO-831

Project wrong column in the case of having same alias in subquery.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Cannot Reproduce
    • None
    • 0.10.0
    • None
    • None

    Description

      The following query should return L_RECEIPTDATE column from lineitem table, but return O_ORDERKEY from orders table.

      select
          a.L_RECEIPTDATE as col1
      from
          (select * from lineitem) a
      join
          (select O_ORDERKEY col1 from orders) b
      on
          a.L_ORDERKEY = b.col1
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            hjkim Hyoungjun Kim
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: