Details
-
Bug
-
Status: Resolved
-
Critical
-
Resolution: Fixed
-
0.11.0
-
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)