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

Full Changelog: v1.5.3...v1.5.4