Trouble with DuckDB offset
2 posts from 2 people2d activeSteady, +1 this weekunverified
Posts per day
The posts behind it
Quack: timezone offset ignored
### What happens? cli handles timezone correctly: when connecting over quack, the timezone is ignored: ### To Reproduce CONNECT 'quack:127.0.0.1' (TOKEN 'secret'); set timezone = 'Europe/Berlin'; select now(); set timezone = 'America/New_York'; select now(); ### OS: Linux ###...
ManualVuln30 Unguarded Negation of INT64_MIN in LEAD/LAG Streaming Offset Computation
### What happens? `WindowLeadLagStreamingState::ComputeOffset()` in `src/function/window/window_value_function.cpp:377-379` negates the user-supplied offset for the `LEAD` window function without first checking whether the value is `INT64_MIN`: When the BIGINT offset evaluates...
Companies and products named
About this problem
Evidence
2 posts from 2 people in 1 place, about 1 a week over 46 days. Mostly on duckdb/duckdb.
Frustration Frustration 0 of 3· Seen on GitHub issues
How it was grouped
Posts about DuckDB with no known issue, sharing the word "offset". First post Oct 2, 2026, latest Nov 16, 2026. Unverified: fewer than 3 posts, or one person or place only. Method
Other DuckDB problems
DuckDB upgrades break working setups
55 posts from 42 people on GitHub issues.
Trouble with DuckDB join
Top post: "Wrong result: join_elimination drops a LEFT JOIN below a LIMIT/OFFSET under a DISTINCT", one of 12 posts from 11 people on GitHub issues.
Trouble with DuckDB returns
Top post: "Segfault in `dense_rank() OVER ()` over a RIGHT_ANTI hash join that returns its unmatched rows", one of 21 posts from 16 people on GitHub issues.
DuckDB feels slow and laggy
3 posts from 3 people on GitHub issues, Reddit.
DuckDB queries run too slowly and are hard to tune
3 posts from 3 people on GitHub issues.
Trouble with DuckDB cast
Top post: "TRY_CAST of an empty BLOB to BIT escapes a non-fallible __cast and invalidates the database", one of 11 posts from 9 people on GitHub issues.
Trouble with DuckDB internal
Top post: "duckdb 2.0.0 fails to launch on BE: `INTERNAL Error: The time zone data is corrupt`", one of 20 posts from 12 people on GitHub issues.
DuckDB error messages are cryptic
12 posts from 8 people on GitHub issues.
Experiments on DuckDB are hard to reproduce and track
11 posts from 7 people on GitHub issues.
DuckDB users keep filing bugs
Top post: "Support duckdb 2", one of 10 posts from 9 people on GitHub issues.
Trouble with DuckDB column
Top post: "2.0 alpha: comparing a CASE/split_part result to a constant fails with BindBuiltinScalarFunction did not", one of 8 posts from 5 people on GitHub issues.
Trouble with DuckDB null
Top post: "DuckDB: `HAVING` of `(φ IS TRUE) OR NOT (φ IS TRUE) AND …` is empty for a NULL `φ`, but the same boolean as", one of 7 posts from 7 people on GitHub issues.
History