`SQL Error [HY000]: Multiple entries with same key: ...` when working on analysis with new drivers.

[paulius-kantautas]

Use case

When working with tables with lots of columns I tend to select few interesting columns (to easily see them on the left of displayed results on a client) as well as * to select everything whats left so I can inspect interesting record in more detail.

SELECT col1, col2, col3, *
FROM big_table;

It's tricky to know useful columns in advance for massive tables with hundreds of columns and it's annoying to create alias for every normal column I want to select. This used to work fine, but recent driver versions now throw SQL Error [HY000]: Multiple entries with same key: ...

Describe the solution you'd like

Would like some option for this to work with new drivers.

[chernser]

@paulius-kantautas thank you for reporting! I think we can fix this part.

[mshustov]

duplicate of https://github.com/ClickHouse/clickhouse-java/issues/2336