ClickHouse / ClickHouse/clickhouse-java
totals don't work with new Clickhouse server versions
- Dominant language
- Java
- Stars
- 1.6k
- Forks
- 636
- Avg merge
- 2d 23h
- Merged PRs (30d)
- 29
Description
```sql
select sum(number), greater
from (select number, number > 5 as greater from numbers(10))
group by greater with totals
```
ClickHouse 22.8.19.10 / ClickHouse JDBC Driver 0.4.6 (revision: dd91e17) -- totals OK
ClickHouse 23.3.5.9 / ClickHouse JDBC Driver 0.4.6 (revision: dd91e17) -- totals NOT OK
Contributor guide
Research direction
Start by reproducing the SQL example against ClickHouse 22.8.19.10 and 23.3.5.9 with ClickHouse JDBC Driver 0.4.6, comparing the totals result. Trace the JDBC client's handling of grouped queries with WITH TOTALS and identify what changed between server versions. Done means the example returns totals correctly on the newer server without breaking the older version.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100