Youngkyong Ko created TAJO-1793:
-----------------------------------

             Summary: result row count unmatched for UNION ALL 
                 Key: TAJO-1793
                 URL: https://issues.apache.org/jira/browse/TAJO-1793
             Project: Tajo
          Issue Type: Bug
    Affects Versions: 0.11.0
         Environment: single node on Macbook
            Reporter: Youngkyong Ko
            Priority: Minor


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)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to