DuckDB Files

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

New Contributors

• @AbhinavMir made their first contribution in https://github.com/duckdb/duckdb/pull/24741
• @mbrobbel made their first contribution in https://github.com/duckdb/duckdb/pull/26102

Full Changelog: https://github.com/duckdb/duckdb/compare/v1.5.5...v1.5.6