duckdb/duckdb v1.5.6

DuckDB v1.5.6 Bugfix Release

on GitHub

This is a bug fix release for various issues discovered after we released v1.5.5

What's Changed

• Use relative includes in unity build sources for cache reuse by @NiclasHaderer in #23972
• bump vortex by @samansmink in #24089
• [variegata] Remove Julia client in favor of duckdb/DuckDB.jl by @evertlammerts in #24127
• [variegata] Replace the C API spec and code generation by @evertlammerts in #24131
• TopNWindowElimination Fixes by @d-justen in #24080
• Fix active query race by @NiclasHaderer in #24123
• Fix UNNEST Pushdown by @d-justen in #24119
• [Parquet][Variant] Don't produce VARIANT metadata with sorted_strings set by @Tishj in #23591
• Fix LIMIT pushdown through a volatile projection with an OFFSET by @DinosL in #24240
• Don't push filters on volatile groups through aggregates by @DinosL in #24239
• fix(adbc): return a dense union from ConnectionGetInfo by @eitsupi in #24196
• Backport 24038 by @artjomPlaunov in #24326
• Unify C-API symbol versioning for clients/extensions, stabilize all v1 API's by @Maxxen in #24362
• backport 24332 by @DinosL in #24427
• Fix #24363: Preserve NULLs in Top-N window elimination when ORDER BY expression has no column references by @sdk011 in #24399
• backport 24260 by @artjomPlaunov in #24447
• Fix ICU strptime leaking time zone state between rows by @NiclasHaderer in #24438
• Moved thread-local work outside the global lock in PhysicalInsert::Combine by @sebastiaan-dev in #24516
• Bump httpfs by @mlafeldt in #24580
• bump vortex by @samansmink in #24650
• Fix 1.5 release by @smvv in #24687
• Allow duplicates in index in ReplayRowGroupData by @artjomPlaunov in #24744
• Dispatch Go nightly build by @mlafeldt in #24720
• Fix join projection map bug in TopNWindowElimination by @d-justen in #24592
• Fix Go nightly workflow dispatch by @mlafeldt in #24802
• Fix Top-N window elimination for nullable ordering expressions by @matthiasgoergens in #24551
• Backport 23964 & 24336 by @DinosL in #24791
• Fix off-by-one in union type by @Maxxen in #24843
• Fix inner join deduplication in TopNWindowElimination by @d-justen in #24586
• fix geometry row group pruning with nulls/empty (on v1.5) by @Maxxen in #24845
• Backport DuckDB 2.0 API spellings to 1.5 by @JelteF in #24852
• Reserve column_ids.size() in CollectionScanState::Initialize by @jeewonhh in #24888
• Fix pathological scan memory for NULLs trailing an overflow string (#24897) by @mdlavin in #24918
• Use absolute unity build includes on Windows to avoid MSVC MAX_PATH errors by @NiclasHaderer in #24978
• Fix mixed path separators for extension/loader in amalgamation (v1.5 backport) by @mlafeldt in #25026
• Backport #25101: Fix crash in Top-N with LIMIT 0 (#24794) by @RagamuffinCat in #25103
• Track and expose Pipeline's intra-MetaPipeline dependencies by @jeewonhh in #24494
• Bump httpfs by @DinosL in #25202
• Skip top-n window elimination when the limit exceeds the min/max n cap by @AbhinavMir in #24741
• Add v1.5.6 storage by @carlopi in #25208
• TryScanIndex fixes by @artjomPlaunov in #25209
• Backport #22678: avoid per-row DATE->TIMESTAMP casts in comparisons by @peterboncz in #25139
• Harden temp file reads by @carlopi in #25283
• Avoid deduplicating UNION twice by @ywelsch in #25261
• Backport #24878: Always quote identifiers in error messages by @JelteF in #25214
• Fixup TryFlushCachingOperators to avoid doubly emitted chunks by @carlopi in #25331
• Close the main WAL handle before renaming over it during WAL recovery by @carlopi in #25490
• [1.5] Report the real storage version when opening a v2.0+ database file by @DinosL in #25573
• Do not assert on a scan of a row group collection without committed row groups by @bleskes in #25668
• Backport dead node counting fixes to v1.5 by @artjomPlaunov in #25693
• Fix silent truncation of very long integer literals into HUGEINT by @DinosL in #25714
• Auto-rollback failed implicitly-wrapped multi-statements on all paths by @jraymakers in #24065
• Backport #25690: Fix MAX on hive partition column after file pruning by @avakili-voleon in #25766
• Bump scanners for 1.5 by @staticlibs in #25671
• Backport #23958 (Fix TIME_NS read/write with parquet) by @avakili-voleon in #25728
• Fix deprecated CLI highlighting dot commands suggesting .render_color by @DinosL in #25689
• Backport PR #25189: Reject invalid UTF8 from printf formatting by @artjomPlaunov in #25808
• Update vortex extension by @samansmink in #25791
• Backport fix for wrong results from common_subplan with UNION ALL arms sharing a join subtree (#25819) by @Kunal8954 in #25831
• Backport #25660: Use read-only transaction to bind indexes in Checkpoint by @Flogex in #25858
• Backport 22373 by @DinosL in #25844
• Internal #10791: v1.5.6 TimeZone 2026c by @hawkfish in #25745
• Keep the delete blocks of an unchanged table in use without rewriting them by @ywelsch in #25971
• Update MySQL and ODBC scanners in 1.5 by @staticlibs in #25945
• Internal #10927: v1.5.6 TimeZone 2026d by @hawkfish in #26039
• backport 25752 by @DinosL in #26027
• Bump DuckLake for v1.5.6 by @pdet in #26009
• Backport #24557: Resolve partition columns for non-pushdown table functions by @rustyconover in #25998
• Issue #25995: Streaming Window UNIONs by @hawkfish in #26104
• Bump multiple extensions by @maiadegraaf in #26072
• Backport 35ce409 to v1.5-variegata by @carlopi in #26137
• bump iceberg by @Tmonster in #25899
• Bump: ducklake by @maiadegraaf in #26151
• Backport #24194: Add enable_optimistic_write setting by @mbrobbel in #26102
• bump delta + unity_catalog extensions for v1.5.6 by @benfleis in #26204
• Bump lance to 291316938c4ab06dc9fec5b92820f496662ef24a by @carlopi in #26203
• Bump vortex to b86c6ab223b53b445ec4c96e74f26dcb616d9c4f by @carlopi in #26202
• [Parquet] Backport of #25891 by @Tishj in #26162

New Contributors

• @AbhinavMir made their first contribution in #24741
• @mbrobbel made their first contribution in #26102

Full Changelog: v1.5.5...v1.5.6