ClickHouse v 1.1.54284 is working fine
Example
CREATE TABLE union_bug (
Event String,
Datetime DateTime
) Engine = Memory;
INSERT INTO union_bug VALUES ('A', now()), ('B', now());
SELECT * FROM union_bug WHERE Event = 'A'
UNION ALL
SELECT * FROM union_bug WHERE Event = 'B'
result
ββEventββ¬ββββββββββββDatetimeββ
β A β 2017-11-03 07:45:15 β
βββββββββ΄ββββββββββββββββββββββ
ββEventββ¬ββββββββββββDatetimeββ
β B β 2017-11-03 07:45:15 β
βββββββββ΄ββββββββββββββββββββββ
1.1.54304/1.1.54310
SELECT *
FROM union_bug
WHERE Event = 'A'
UNION ALL
SELECT *
FROM union_bug
WHERE Event = 'B'
Received exception from server:
Code: 258. DB::Exception: Received from localhost:9000, 127.0.0.1. DB::Exception: Size mismatch in UNION ALL chain.
It's work
SELECT Event, Datetime FROM union_bug WHERE Event = 'A'
UNION ALL
SELECT * FROM union_bug WHERE Event = 'B'
It doesn't work
SELECT * FROM union_bug WHERE Event = 'A'
UNION ALL
SELECT Event, Datetime FROM union_bug WHERE Event = 'B'
Confirmed, thanks for a simple and reproducible test case!
Most helpful comment
Confirmed, thanks for a simple and reproducible test case!