DuckDB v1.5.4 Bugfix Release

This is a bug fix release for various issues discovered after we released v1.5.3. Please also refer to the announcement blog post: https://duckdb.org/2026/06/17/announcing-duckdb-154.html ## What's Changed * backport 22094 by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/22136 * backport 21815 & 21427 by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/22137 * remove CleanupState destructor and remove noexcept on DuckCleanupInfo… by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/22186 * Backport revert append fix to v1.4 by @Mytherin in https://github.com/duckdb/duckdb/pull/22414 * Backport windows-32bit test fix to 1.4 by @staticlibs in https://github.com/duckdb/duckdb/pull/22639 * Fix `TemporaryFileManager` reported size to reflect live blocks by @DinosL in https://github.com/duckdb/duckdb/pull/22767 * Set query text on PIVOT MultiStatement sub-statements at construction by @bleskes in https://github.com/duckdb/duckdb/pull/22769 * Fix double free and memory leak in Arrow GeoArrow CRS serialization by @rustyconover in https://github.com/duckdb/duckdb/pull/21854 * Render MAP values as valid SQL in Value::ToSQLString() by @carlopi in https://github.com/duckdb/duckdb/pull/22815 * Remove time-out waiting for terminal background color by @Mytherin in https://github.com/duckdb/duckdb/pull/22838 * Fix `WindowSelfJoinOptimizer` ignore exception by @qsliu2017 in https://github.com/duckdb/duckdb/pull/22800 * fix progress bar output and crash when piping SQL by @DinosL in https://github.com/duckdb/duckdb/pull/22836 * Internal #9438: TopN Window Projections by @hawkfish in https://github.com/duckdb/duckdb/pull/22851 * Fix: check if `ParseFormatSpecifier` returns unrecognized format by @DinosL in https://github.com/duckdb/duckdb/pull/22850 * Issue #22791: Window Self-Join Limits by @hawkfish in https://github.com/duckdb/duckdb/pull/22844 * [Backport] Column-level metadata loading and serialization by @ywelsch in https://github.com/duckdb/duckdb/pull/22768 * Fix json_keys with wildcard paths by @feichai0017 in https://github.com/duckdb/duckdb/pull/22855 * Fix: JSON add list type check by @DinosL in https://github.com/duckdb/duckdb/pull/22862 * Use committed row count in `RowGroupReorderer` by @lnkuiper in https://github.com/duckdb/duckdb/pull/22884 * Fix geometry stats checkpointing when no changes are detected by @Maxxen in https://github.com/duckdb/duckdb/pull/22882 * Check for `nullptr` expressions in deserialized JSON by @lnkuiper in https://github.com/duckdb/duckdb/pull/22906 * Add vacuum_rebuild_indexes as an (experimental) ATTACH option by @evertlammerts in https://github.com/duckdb/duckdb/pull/22690 * Use non-deleted row count in `RowGroupReorderer` by @lnkuiper in https://github.com/duckdb/duckdb/pull/22911 * Validate width/scale in duckdb_create_decimal_type and duckdb_create_decimal by @mlafeldt in https://github.com/duckdb/duckdb/pull/22905 * Bump httpfs to fix CI by @sebastiaan-dev in https://github.com/duckdb/duckdb/pull/22817 * Update vortex extension by @samansmink in https://github.com/duckdb/duckdb/pull/22930 * Fix alias propagation when replacement scan is wrapped in SubqueryRef by @truffle-dev in https://github.com/duckdb/duckdb/pull/22852 * Rowgroup index append by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/22940 * Bump Julia to v1.5.3 by @carlopi in https://github.com/duckdb/duckdb/pull/22804 * Make url a value, not a const ref by @NiclasHaderer in https://github.com/duckdb/duckdb/pull/22953 * fix(adbc): support `StatementExecuteSchema` of ADBC 1.1.0 by @eitsupi in https://github.com/duckdb/duckdb/pull/22965 * Fix partial column metadata reuse bug by @ywelsch in https://github.com/duckdb/duckdb/pull/22994 * bump avro hash for 1.4.5 by @djouallah in https://github.com/duckdb/duckdb/pull/22952 * Add avro and unity_catalog to extension list by @d-justen in https://github.com/duckdb/duckdb/pull/22948 * Fix case-insensitive column match in INSERT ... SELECT ON CONFLICT by @remsky in https://github.com/duckdb/duckdb/pull/22825 * Normalize db_type to lowercase on ATTACH, apply extension aliases on compare by @carlopi in https://github.com/duckdb/duckdb/pull/22758 * MERGE INTO: only consider target table when binding `WHEN NOT MATCHED` and source table when binding `WHEN NOT MATCHED BY TARGET` by @Mytherin in https://github.com/duckdb/duckdb/pull/23014 * In the optimistic writer always start a new row group after merging by @Mytherin in https://github.com/duckdb/duckdb/pull/22997 * Merge Into: Avoid recursively binding in the ProjectionBinder by @Mytherin in https://github.com/duckdb/duckdb/pull/23022 * Rename emscripten action in v1.5 by @smvv in https://github.com/duckdb/duckdb/pull/23044 * Rename emscripten action in v1.4 by @smvv in https://github.com/duckdb/duckdb/pull/23045 * Fix VARIANT cast reading wrong rows under a filter by @mlafeldt in https://github.com/duckdb/duckdb/pull/23031 * fix(adbc): implement ADBC 1.1.0 Rich Error Metadata API by @eitsupi in https://github.com/duckdb/duckdb/pull/23073 * Add v1.4.5 to storage version map by @carlopi in https://github.com/duckdb/duckdb/pull/23081 * Merge v1.4-andium into v1.5-variegata, and add storage versions v1.4.5 and v1.5.4 by @carlopi in https://github.com/duckdb/duckdb/pull/23082 * Backport PR #22348 to andium by @carlopi in https://github.com/duckdb/duckdb/pull/23084 * Backport variegata bugfixes into andium by @carlopi in https://github.com/duckdb/duckdb/pull/23085 * Bump vortex in andium by @carlopi in https://github.com/duckdb/duckdb/pull/23091 * Bump lance in variegata by @carlopi in https://github.com/duckdb/duckdb/pull/23094 * Bump vortex in variegata by @carlopi in https://github.com/duckdb/duckdb/pull/23096 * Bump extensions to v1.4-andium by @carlopi in https://github.com/duckdb/duckdb/pull/23090 * v1.5-variegata: bump extensions by @carlopi in https://github.com/duckdb/duckdb/pull/23089 * Fix Parquet thrift byte order on windows + relax geometry stats pruning by @Maxxen in https://github.com/duckdb/duckdb/pull/23095 * fix(adbc): fill metadata of GetObjects by @eitsupi in https://github.com/duckdb/duckdb/pull/23110 * backport GetLocalFileSystem improvements to andium by @ccfelius in https://github.com/duckdb/duckdb/pull/23130 * Reject NULL json key by @dentiny in https://github.com/duckdb/duckdb/pull/23116 * Fix windows last modification timestamp by @dentiny in https://github.com/duckdb/duckdb/pull/23136 * Fix: ignore_errors silently accepting invalid json by @DinosL in https://github.com/duckdb/duckdb/pull/23137 * [v1.5] Backport external file cache fix by @dentiny in https://github.com/duckdb/duckdb/pull/23132 * Internal #9375: PRAGMA enum NULL by @hawkfish in https://github.com/duckdb/duckdb/pull/23146 * Clarify BIGNUM C API data is big endian by @mlafeldt in https://github.com/duckdb/duckdb/pull/23127 * Allow array type for array_to_json by @dentiny in https://github.com/duckdb/duckdb/pull/23129 * Fix json argument order affecting result by @DinosL in https://github.com/duckdb/duckdb/pull/23144 * Fix #21931: avoid trying to bind an expression that doesn't exist in `UNPIVOT` by @Mytherin in https://github.com/duckdb/duckdb/pull/23156 * Fix RowGroup assertion by @ywelsch in https://github.com/duckdb/duckdb/pull/23155 * Upgrade ducklake for release by @pdet in https://github.com/duckdb/duckdb/pull/23182 * Update Postgres, SQLite and ODBC in 1.5 by @staticlibs in https://github.com/duckdb/duckdb/pull/23172 * Fix native geometry parquet stats pruning and add `OPERATOR_ROW_GROUPS_SCANNED` to parquet reader by @Maxxen in https://github.com/duckdb/duckdb/pull/23140 * Expose bytes to parquet variant function by @Tmonster in https://github.com/duckdb/duckdb/pull/23057 * Minor fixes by @DinosL in https://github.com/duckdb/duckdb/pull/23162 * Bump aws extension by @ccfelius in https://github.com/duckdb/duckdb/pull/23170 * Merge v1.4-andium into v1.5-variegata by @carlopi in https://github.com/duckdb/duckdb/pull/23171 * Backport to variegata some isolated fixes by @carlopi in https://github.com/duckdb/duckdb/pull/23175 * Fix: guard againt null row group reorder stats by @DinosL in https://github.com/duckdb/duckdb/pull/23189 * bump iceberg by @Tmonster in https://github.com/duckdb/duckdb/pull/23192 * Replace ARTConflictType::TRANSACTION with fatal exception by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/23193 * [Dev] Fix variant shredding analysis logic discrepancy with shredded writing by @Tishj in https://github.com/duckdb/duckdb/pull/23194 * Initialize all `BaseStatistics` members and zero `stats_union` by @krlmlr in https://github.com/duckdb/duckdb/pull/23202 * Initialize `TransactionContext::invalidation_policy` and `auto_rollback` by @krlmlr in https://github.com/duckdb/duckdb/pull/23203 * Fix selection vector use in Arrow extension callbacks by @evertlammerts in https://github.com/duckdb/duckdb/pull/23190 * Add hardening to many DuckDB/Parquet decompression/deserializing paths by @Tishj in https://github.com/duckdb/duckdb/pull/23100 * Out-of-line `SelectionData` destructor to silence g++-16 `-Warray-bounds` by @krlmlr in https://github.com/duckdb/duckdb/pull/23204 * Bump quack to 9ac6521f712812cc6f2e58815ef0a6c85c5e06e0 by @carlopi in https://github.com/duckdb/duckdb/pull/23178 * Fix crash when storage path is not set by @guillesd in https://github.com/duckdb/duckdb/pull/23174 * Zero the inlined buffer in string_t's length-only constructor by @krlmlr in https://github.com/duckdb/duckdb/pull/23201 * [Dev] Fix "environment variable already defined" error in sqllogictest when `test_env` is used by @Tishj in https://github.com/duckdb/duckdb/pull/21305 * parquet: initialize `ParquetReader::rows_read` by @krlmlr in https://github.com/duckdb/duckdb/pull/23205 * Bump quack no patches by @carlopi in https://github.com/duckdb/duckdb/pull/23210 * bump delta & unity for 1.5.4 by @benfleis in https://github.com/duckdb/duckdb/pull/23212 * Bump DuckLake by @pdet in https://github.com/duckdb/duckdb/pull/23226 * Bump httpfs for variegata by @carlopi in https://github.com/duckdb/duckdb/pull/23215 * Hopefully fix timeouts on `v1.5-variegata` by @lnkuiper in https://github.com/duckdb/duckdb/pull/23224 * Variant fixes by @DinosL in https://github.com/duckdb/duckdb/pull/23195 * Fix VARIANT shredding, avoid including empty object keys by @Tishj in https://github.com/duckdb/duckdb/pull/23213 * Remove checked_array_iterator from fmt dep (1.5) by @staticlibs in https://github.com/duckdb/duckdb/pull/23238 * [Dev] Add missing `ORDER BY ALL` or `rowsort` to merge into tests by @Tishj in https://github.com/duckdb/duckdb/pull/23258 * Cherry picks on variegata by @carlopi in https://github.com/duckdb/duckdb/pull/23262 * Bump vortex to 275ac230e1d9afd08926b6989ec2467f92fae6e3 by @carlopi in https://github.com/duckdb/duckdb/pull/23263 * Add explicit `-dark-mode` and `-light-mode` options to the CLI, and improve terminal background color detection by @Mytherin in https://github.com/duckdb/duckdb/pull/23246 * Fix gzip compression write overflow by @dentiny in https://github.com/duckdb/duckdb/pull/23232 * Bump iceberg for v1.5.4 by @Tmonster in https://github.com/duckdb/duckdb/pull/23225 * Trim the system heap in the allocator flush path on jemalloc builds by @JelteF in https://github.com/duckdb/duckdb/pull/23253 * Backport loop in sleep_ms by @DinosL in https://github.com/duckdb/duckdb/pull/23245 * Fix NULL propagation for date parts of infinite dates by @DinosL in https://github.com/duckdb/duckdb/pull/23254 * [Dev][Parquet][VARIANT] Fix problem with re-use of cached transform data for differently shredded files by @Tishj in https://github.com/duckdb/duckdb/pull/23234 * bump iceberg by @Tmonster in https://github.com/duckdb/duckdb/pull/23277 * Fix more geom stats by @Maxxen in https://github.com/duckdb/duckdb/pull/23295 **Full Changelog**: https://github.com/duckdb/duckdb/compare/v1.5.3...v1.5.4