ClickHouse / ClickHouse/ClickHouse
kurtPop and float / decimal agruments
Open
comp-aggregate-functions
external
unexpected behaviour
- Dominant language
- C++
- Stars
- 49.9k
- Forks
- 9k
- Avg merge
- 21h 32m
- Merged PRs (30d)
- 515
Description
```
SELECT kurtPop(amount) AS kurt_spd_1y
FROM
(
SELECT 78878.1 AS amount
FROM numbers(5)
) AS t
┌───────kurt_spd_1y─┐
│ 33776997205278710 │
└───────────────────┘
SELECT kurtPop(amount) AS kurt_spd_1y
FROM
(
SELECT toDecimal64('78878.1',2) AS amount
FROM numbers(5)
) AS t
┌───────kurt_spd_1y─┐
│ 33776997205278710 │
└───────────────────┘
```
with round
```sql
SELECT kurtPop(round(amount)) AS kurt_spd_1y
FROM
(
SELECT 78878.1 AS amount
FROM numbers(5)
) AS t
┌─kurt_spd_1y─┐
│ nan │
└─────────────┘
```
Contributor guide
Assessment
This issue has not been assessed yet.