Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

quantilesExact(percentile) defined in the WITH clause cannot be utilized in the subsequent query in version 23.10.2.13 #60403

Closed
ztyntix opened this issue Feb 26, 2024 · 1 comment

Comments

@ztyntix
Copy link

ztyntix commented Feb 26, 2024

Describe the unexpected behaviour
The query functions correctly in version 23.1.2.9 but encounters issues in version 23.10.2.13.

WITH tmp AS (
  SELECT 1 AS col
  UNION ALL
  SELECT 2
),

(SELECT 1.0 / count(0) FROM tmp) AS percentile,
t1 AS (SELECT quantilesExact(percentile)(col) FROM tmp)
SELECT * FROM t1

How to reproduce
ClickHouse Version: 23.10.2.13

Error message and/or stacktrace
clickhouse error: Orig exception: Code: 134. DB::Exception: Parameters to aggregate functions must be literals. Got parameter 'identity(_CAST(0., 'Nullable(Float64)')) AS percentile'. (PARAMETERS_TO_AGGREGATE_FUNCTIONS_MUST_BE_LITERALS) (version 23.10.2.13 (official build))

@UnamedRus
Copy link
Contributor

Duplicate #59154

@nickitat nickitat closed this as not planned Won't fix, can't repro, duplicate, stale Feb 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants