cockroachdb / cockroachdb/cockroach

unknown signature: percentile_cont_impl(decimal, decimal)

Open
#106,366 4 comments 1 reaction 0 assignees View on GitHub
C-bug O-community T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

```
> show columns from transactions;
column_name | data_type | is_nullable | column_default | generation_expression | indices | is_hidden
--------------+-------------+-------------+----------------+-----------------------+---------------------+------------
id | INT8 | f | unique_rowid() | | {transactions_pkey} | f
amount | DECIMAL | t | NULL | | {transactions_pkey} | f
created_at | TIMESTAMPTZ | t | now() | | {transactions_pkey} | f
(3 rows)
```

```
> SELECT PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY amount ASC) FROM transactions;
ERROR: unknown signature: percentile_cont_impl(decimal, decimal)
SQLSTATE: 42883
```

**Environment:**
- CockroachDB Cloud Serverless

Jira issue: CRDB-29532

Epic CRDB-2474

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.