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_stringsset 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::Combineby @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_writesetting 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