cockroachdb / cockroachdb/cockroach

Unexpected error of MAX(NULL) in prepared statement `ERROR: no builtin aggregate for MAX on [unknown]`

Open
#153,664 2 comments 0 reactions 0 assignees View on GitHub
C-bug O-community T-sql-queries X-blathers-triaged
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

**Describe the problem**

Please describe the issue you observed, and any steps we can take to reproduce it:

**To Reproduce**

Hi,

The following test case triggers an unexpected error:

```
SET plan_cache_mode = force_generic_plan;
CREATE TABLE t33 (c0 FLOAT);
INSERT INTO t33 (c0) VALUES(1);
SET SESSION VECTORIZE=off;
PREPARE prepare_query (FLOAT) AS SELECT VARIANCE(9.4834975E7), MAX($1) FROM t33;
EXECUTE prepare_query(NULL::FLOAT);
DEALLOCATE prepare_query;
```

This is the output:
```
> EXECUTE prepare_query(NULL::FLOAT);
ERROR: no builtin aggregate for MAX on [unknown]
```
If I remove one of `SET plan_cache_mode = force_generic_plan;`, `SET SESSION VECTORIZE=off;`, `VARIANCE(9.4834975E7)`, there will be no error.

**Expected behavior**
No error.

**Additional data / screenshots**
If the problem is SQL-related, include a copy of the SQL query and the schema
of the supporting tables.

If a node in your cluster encountered a fatal error, supply the contents of the
log directories (at minimum of the affected node(s), but preferably all nodes).

Note that log files can contain confidential information. Please continue
creating this issue, but contact support@cockroachlabs.com to submit the log
files in private.

If applicable, add screenshots to help explain your problem.

**Environment:**
- CockroachDB version [CockroachDB CCL v25.1.6 (x86_64-pc-linux-gnu, built 2025/05/09 15:48:03, go1.22.8 X:nocoverageredesign)]
- Server OS: [Ubuntu 24.04]
- Client app [`cockroach sql`, JDBC]

**Additional context**
What was the impact?

Add any other context about the problem here.

Jira issue: CRDB-54543

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.