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

result row count unmatched for UNION ALL

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Critical
    • Resolution: Fixed
    • 0.11.0
    • 0.12.0, 0.11.2
    • QueryMaster
    • None
    • 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

            blrunner JaeHwa Jung
            ykko Youngkyong Ko
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: