DuckDB error messages are cryptic

11 posts from 7 people8d activeFading, +0 this week

Posts per day11 posts, Sep 14 to Nov 10

The posts behind it

GitHub issuesduckdb/duckdb · aldahamOct 28

Equality filter on BIGINT column returns no rows on database file created with an older version (1.5.3/1.5.6 → 1.5.6/2.0.0)

### What happens? I install 3 versions of DuckDB: 1.5.3 1.5.6 2.0.0 I build database with version 1.5.3 and use it on version 1.5.6 and 2.0.0 then build it with version 1.5.6 and use it on version 1.5.6 and 2.0.0 then build it with version 2.0.0 and use it with version 2.0.0...

1 replies

GitHub issuesduckdb/duckdb · rustyconoverOct 27

Transaction callback exceptions skip commit notifications and finalization

### What happens? When a `ClientContextState::TransactionCommit` callback throws, DuckDB skips the remaining commit callbacks even though the transaction has already committed. For example, two extensions may both need a commit notification to clear their transaction-local...

GitHub issuesduckdb/duckdb · hanke580Oct 22

Arrow import: `fixed_size_binary` field of a NULL struct is read as a value; `COPY ... TO parquet` then shifts the column's values by one row

### What happens? Take an Arrow struct column with a NULL row whose `fixed_size_binary` child has its own validity bitmap (the child contains a NULL somewhere). DuckDB imports the child at the NULL struct's position as a value: Arrow's placeholder bytes. The Arrow format allows...

GitHub issuesduckdb/duckdb · happycollisionOct 20

2.0 alpha drops NULL rows from 1.5-written tables under `OR ... IS NULL` filters

## Background #3844 and #3873 (2022) noted that a column's value-segment statistics report `has_null = false` even when the column contains NULLs, and #3844 raised the concern that NULL filters using those statistics could skip segments. Both were closed with the explanation...

1 replies

GitHub issuesduckdb/duckdb · hanke580Oct 20

`INSERT … ON CONFLICT DO UPDATE` / `INSERT OR REPLACE` with a repeated key in the input silently applies only the first row (since 1.4)

...can not update the same row twice in the same command", or a duplicate-key constraint error when the key was not in the table yet). - 1.2.2 and 1.3.2 applied the rows of small inputs in input order (the last row wins, the increments accumulate), but larger inputs already lost...

1 replies

GitHub issuesduckdb/duckdb · bobjansenOct 3

ADBC: bulk ingest that violates a constraint reports success and writes nothing

### What happens? Disclaimers: 1) I didn't spot ADBC under clients or extensions in the report ticket so I hope posting this here is appropriate, 2) my agent found this, but the repro is sensible. ## What happens `adbc_ingest(..., mode="append")` of a batch containing a...

GitHub issuesduckdb/duckdb · ylwango613Oct 2

ManualVuln21 Correlated Subquery LIMIT+OFFSET Overflow Silently Returns Wrong Results

### What happens? In `FlattenDependentJoins::PushDownLimit()` (`src/planner/subquery/flatten_dependent_join.cpp`, line 1185), the code computes the upper bound for a row-number window filter that replaces a correlated subquery LIMIT/OFFSET clause: The return value of...

GitHub issuesduckdb/duckdb · ylwango613Oct 2

ManualVuln36 NaN Quantile Bypasses Range Guard in reservoir_quantile and Triggers Internal Assertion

### What happens? `CheckReservoirQuantile` in `extension/core_functions/aggregate/holistic/reservoir_quantile.cpp` (line 305) checks `if (quantile 1)` but omits a NaN guard before the comparison. Because all IEEE 754 comparisons with NaN return false, a NaN double passes both...

GitHub issuesduckdb/duckdb · ylwango613Oct 1

ManualVuln1 approx_quantile() Silently Discards DECIMAL Type and Precision

...and is **not** affected. Only the scalar overload is broken. This bug shares an identical root cause with the previously fixed `reservoir_quantile` DECIMAL precision loss (GitHub issue #24189, fixed in PR #24488). In both cases `ReplaceImplementation` is handed a function whose...

GitHub issuesduckdb/duckdb · ottawa-danSep 14

HTTP logging prints Authorization and x-amz-security-token in cleartext; on v2.0 the same rows never reach duckdb_logs() and enable_http_logging is silently inert

### What happens? Two related defects in HTTP logging. (A) Credentials are printed in cleartext. Enabling HTTP logging emits every request header, including `Authorization: AWS4-HMAC-SHA256 Credential=..., Signature=...` and the full `x-amz-security-token` STS session token....

GitHub issuesduckdb/duckdb · hanke580Sep 14

Incorrect results: hash join silently drops rows when the build side spills to disk

### What happens? A hash join whose build side spills to disk silently returns a strict subset of its rows. With a 60 MB memory limit, a semi join that must return 3,000,000 rows returns 480,000 - no error, no warning. The join key values that survive are exactly those whose...

Companies and products named

DuckDB

11 posts

AWS

2 posts

GitHub

2 posts

IEEE

1 post

PostgreSQL

1 post

MySQL

1 post

About this problem

Evidence

11 posts from 7 people in 1 place, about 2 a week over 45 days. Mostly on duckdb/duckdb. Tools named alongside: AWS, GitHub, IEEE, PostgreSQL.

Frustration Frustration 1 of 3· Seen on GitHub issues

How it was grouped

Posts that state a pain and match the "errors-unclear" rule about DuckDB. First post Sep 14, 2026, latest Oct 28, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method

The same problem elsewhere

Momentum went from steady to fading.

Nov 4, 2026

Momentum went from fading to steady.

Nov 2, 2026

Momentum went from steady to fading.

Oct 29, 2026

Momentum went from rising to steady.

Oct 27, 2026

Momentum went from fading to rising.

Oct 23, 2026

Momentum went from rising to fading.

Oct 9, 2026

Corroborated: 3 or more posts from 2 or more people or places.

Oct 7, 2026

Momentum went from fading to rising.

Oct 7, 2026

First seen with 2 posts.

Sep 25, 2026