Same column names gives incorrect results

20 views
Skip to first unread message

divyan...@gmail.com

unread,
May 11, 2021, 10:51:00 PMMay 11
to ClickHouse
Hi Team, I am the result of a query with two (maybe also more ) same column name that gives incorrect results.

select count(CounterID) , max(VisitID) as `count(CounterID)` from datasets.visits_v1;
9223371028093169762
9223371028093169762

select count(CounterID) , max(VisitID) from datasets.visits_v1;
1676861
9223371028093169762

The value of max(VisitID) as `count(CounterID)`  is being copied from the value of column 'count(CounterID)' . 

Is this expected behaviour? 
Thanks




Denis Zhuravlev

unread,
May 11, 2021, 11:19:00 PMMay 11
to ClickHouse
I think it's a webui bug.
Reply all
Reply to author
Forward
0 new messages