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

result row count unmatched for UNION ALL

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 0.11.0
    • Fix Version/s: 0.12.0, 0.11.2
    • Component/s: QueryMaster
    • Labels:
      None
    • Environment:

      single node on Macbook

      Description

      In UNION ALL, result record count is presented wrong.

      default> select * from test1;
      c1
      -------------------------------
      1
      2
      (2 rows, 0.027 sec, 4 B selected)

      default> select * from test2;
      c1
      -------------------------------
      2
      3
      4
      (3 rows, 0.011 sec, 6 B selected)

      default> select c1 from test1 union all select c1 from test2;
      Progress: 100%, response time: 0.458 sec
      c1
      -------------------------------
      1
      2
      2
      3
      4
      (2 rows, 0.458 sec, 10 B selected)

      ==> SHOULD BE "5 rows"

      BTW, it is OK in case of UNION .

      default> select c1 from test1 union select c1 from test2;
      Progress: 100%, response time: 0.241 sec
      c1
      -------------------------------
      2
      1
      3
      4
      (4 rows, 0.241 sec, 8 B selected)

        Attachments

          Activity

            People

            • Assignee:
              blrunner Jaehwa Jung
              Reporter:
              ykko Youngkyong Ko
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: