DuckDB v1.5.6 Bugfix Release

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 35ce409e298dc1a8e9dad1b1f83a138a0d12d087 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 291316938c4ab06dc9fec5b92820f496662ef24a by @carlopi in https://github.com/duckdb/duckdb/pull/26203 * Bump vortex to b86c6ab223b53b445ec4c96e74f26dcb616d9c4f 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