duckdb version history

- Fixed various bugs including memory leaks, crashes, and JSON handling - Improved window functions, MERGE operations, and query execution - Added experimental ATTACH option for vacuum_rebuild_indexes - Enhanced ADBC support and fixed extension compatibility issues

This is a bug fix release for various issues discovered after we released v1.4.4. Please also refer to the announcement blog post: https://duckdb.org/2026/06/17/announcing-duckdb-145.html ## What's Changed * Internal #7212: FILL Empty Chunk by @hawkfish in https://github.com/duckdb/duckdb/pull/20657 * Secret Manager: Ensure secrets are created exactly once by @Mytherin in https://github.com/duckdb/duckdb/pull/20686 * Use FileSystem APIs in QueryProfiler::Write by @Mytherin in https://github.com/duckdb/duckdb/pull/20727 * Fix escape handling in AddEscapes function by @llukito in https://github.com/duckdb/duckdb/pull/20760 * Fixup test/extension/update_extensions_ci.test [v1.4-andium] by @carlopi in https://github.com/duckdb/duckdb/pull/20777 * Backport various race condition fixes to v1.4 by @Mytherin in https://github.com/duckdb/duckdb/pull/20804 * bump ref to azure for v1.4.4 (rebuild) by @benfleis in https://github.com/duckdb/duckdb/pull/20888 * Internal #7584: AsOf Simple Joins by @hawkfish in https://github.com/duckdb/duckdb/pull/21090 * Do not write ccache to github cache for v1.4-andium by @smvv in https://github.com/duckdb/duckdb/pull/21109 * Disable extensio

This is a bugfix release for various issues discovered after we released v1.5.2. Please also refer to the announcement blog post: https://duckdb.org/2026/05/20/announcing-duckdb-153 ## What's Changed * Use DB serialization compatibility for json_serialize_sql by @kryonix in https://github.com/duckdb/duckdb/pull/22004 * DuckLake Bump by @pdet in https://github.com/duckdb/duckdb/pull/22014 * fix: resolve current catalog in ADBC Ingest to avoid temp table shadowing by @eitsupi in https://github.com/duckdb/duckdb/pull/22020 * Fix TIMESTAMPFORMAT being ignored for TIMESTAMPTZ columns in copy to json by @DinosL in https://github.com/duckdb/duckdb/pull/21992 * Provide BWC support for join filter pushdowns by @ywelsch in https://github.com/duckdb/duckdb/pull/22029 * Add iceberg copy function autoload by @NiclasHaderer in https://github.com/duckdb/duckdb/pull/22037 * Fix DISABLE_EXTENSION_LOAD by @mlafeldt in https://github.com/duckdb/duckdb/pull/22019 * Fix `INSERT OR REPLACE BY NAME` regression by excluding conflict columns from `SET` list by @DinosL in https://github.com/duckdb/duckdb/pull/22049 * Git-ignore generated extension loader by @mlafeldt in https://github.com/duc

This is a bug fix release for various issues discovered after we released v1.5.1 ## What's Changed * Backport various race condition fixes to v1.4 by @Mytherin in https://github.com/duckdb/duckdb/pull/20804 * bump ref to azure for v1.4.4 (rebuild) by @benfleis in https://github.com/duckdb/duckdb/pull/20888 * Internal #7584: AsOf Simple Joins by @hawkfish in https://github.com/duckdb/duckdb/pull/21090 * Do not write ccache to github cache for v1.4-andium by @smvv in https://github.com/duckdb/duckdb/pull/21109 * Disable extension caching for v1.4 to free github cache space by @smvv in https://github.com/duckdb/duckdb/pull/21150 * Disable save_cache for v1.4-andium by @smvv in https://github.com/duckdb/duckdb/pull/21167 * Backport #19232: allow * Not similar to 'pattern' by @Dtenwolde in https://github.com/duckdb/duckdb/pull/21177 * backport zstd PR to 1.4 by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/21178 * Fix unbounded row group growth for indexed tables on repeated load+insert cycles by @abramk in https://github.com/duckdb/duckdb/pull/21316 * Backport #21271 by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/21326 * [lance] Add for v1.4-andium b

This is a bug fix release for various issues discovered after we released v1.5.0. Please also refer to the announcement blog post: https://duckdb.org/2026/03/23/announcing-duckdb-151 ## What's Changed * [Extensions] Preserve `require` order in `InterpretedBenchmark` by @Tishj in https://github.com/duckdb/duckdb/pull/21214 * CLI: Make help entry uppercase by @szarnyasg in https://github.com/duckdb/duckdb/pull/21224 * Restore view's bind_state when binding fails by @jeewonhh in https://github.com/duckdb/duckdb/pull/21193 * [Regression v1.5] Fix INTERNAL Error in UnnestRewriter for deeply nested struct UNNEST by @guizmaii in https://github.com/duckdb/duckdb/pull/21209 * fix(storage): prevent TrimFreeBlocks from zeroing concurrently alloca… by @llersch in https://github.com/duckdb/duckdb/pull/21146 * Windows shell: UTF-8 mode when writing to pager by @staticlibs in https://github.com/duckdb/duckdb/pull/21202 * [Dev] Add internal exception for misuse of `MultiFileReader` method by @Tishj in https://github.com/duckdb/duckdb/pull/21046 * Before loading libraries in TryAutoLoadExtension check AutoloadKnownExtensions Setting by @pdet in https://github.com/duckdb/duckdb/pull/21

This release of DuckDB is named "Variegata" after the paradise shelduck Tadorna Variegata, also known as the paradise duck, a species of Shelduck (a group of goose-like ducks), endemic to New Zealand. Please also refer to the announcement blog post: https://duckdb.org/2026/03/09/announcing-duckdb-150.html ## What's Changed * Optimize LAST aggregate to iterate backward within batches by @xe-nvdk * Allow user type with schema defined to have array bounds by @Dtenwolde in https://github.com/duckdb/duckdb/pull/18342 * Remove case-insensitive character from grammar files by @Dtenwolde in https://github.com/duckdb/duckdb/pull/18948 * Fix query() function error message for PIVOT statements without explicit IN clauses by @shivampr in https://github.com/duckdb/duckdb/pull/18900 * Merge v1.4-andium into main by @c-herrewijn in https://github.com/duckdb/duckdb/pull/18952 * [Dev] Some light code cleanup in `RemoveUnusedColumns::VisitOperator` by @Tishj in https://github.com/duckdb/duckdb/pull/18964 * Support renaming a database - ALTER DATABASE <> RENAME TO <> by @abramk in https://github.com/duckdb/duckdb/pull/18970 * V1.4 andium by @Mytherin in https://github.com/duckdb/duckdb/

This is a bug fix release for various issues discovered after we released 1.4.3. Please excuse the erroneous release earlier. ## What's Changed * Cast Fix: Correctly handle negative exponent with a number with a decimal in VARCHAR -> INTEGER cast by @Mytherin in https://github.com/duckdb/duckdb/pull/20098 * [Storage] Fix NULL filter check for constant segments by @Tishj in https://github.com/duckdb/duckdb/pull/20103 * fixing staged upload for install.duckdb.org - hopefully by @hannes in https://github.com/duckdb/duckdb/pull/20104 * Remove undefined loop by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/20105 * [Test] Adjust concurrent attach-detach test to expect write-write conflict by @taniabogatsch in https://github.com/duckdb/duckdb/pull/20108 * Fix ALIAS function in filter pushdown to preserve column aliases(#20008) by @henry8128 in https://github.com/duckdb/duckdb/pull/20106 * Headers missing from http logs by @samansmink in https://github.com/duckdb/duckdb/pull/20030 * Bumping httpfs to include https://github.com/duckdb/duckdb-httpfs/pull/174 by @carlopi in https://github.com/duckdb/duckdb/pull/20145 * Issue #20136: Secondary IGNORE NULLS by @hawkfish in

This is a bug fix release for various issues discovered after we released 1.4.2. ## What's Changed * implement proper equals for table functions by @Maxxen in https://github.com/duckdb/duckdb/pull/19722 * Fix behavior for HAVING clause without a GROUP BY by @Tishj in https://github.com/duckdb/duckdb/pull/19739 * Remove httpfs patches and bump by @carlopi in https://github.com/duckdb/duckdb/pull/19763 * Correctly use a lock when accessing the EncryptionKeyManager by @Mytherin in https://github.com/duckdb/duckdb/pull/19772 * Bump iceberg to now default available extension by @carlopi in https://github.com/duckdb/duckdb/pull/19764 * Extract all column bindings of json each function by @Tmonster in https://github.com/duckdb/duckdb/pull/19766 * constraint violation bug fix by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/19776 * Avoid binding macro arguments for untyped macros by @lnkuiper in https://github.com/duckdb/duckdb/pull/19779 * It should probably be `${EXTENSION_CONFIG_BUILD}` instead of `EXTENSION_CONFIG_BUILD` by @hannes in https://github.com/duckdb/duckdb/pull/19694 * Fix #19575: Fix illegal utf8 character by @flashmouse in https://github.com/duckdb/d

This is a bug fix release for various issues discovered after we released 1.4.1. PR #19716 addresses the issues raised in [CVE-2025-64429]( https://github.com/duckdb/duckdb/security/advisories/GHSA-vmp8-hg63-v2hp). Users of the DuckDB encryption feature are encouraged to update. ## What's Changed * bump duckdb-azure ref for 1.4.1 by @benfleis in https://github.com/duckdb/duckdb/pull/19275 * Fix regex optimization to remove flags when converting to contains by @mlafeldt in https://github.com/duckdb/duckdb/pull/19290 * feat: Fix length of sort keys by @krlmlr in https://github.com/duckdb/duckdb/pull/19260 * Pass lambda bindings to next binder by @Dtenwolde in https://github.com/duckdb/duckdb/pull/19144 * bump Julia to v1.4.1 by @c-herrewijn in https://github.com/duckdb/duckdb/pull/19306 * Use cross-compilation for static libs on OSX by @hannes in https://github.com/duckdb/duckdb/pull/19304 * Allow multiple read-only attaches to the same database across database instances by @Mytherin in https://github.com/duckdb/duckdb/pull/19319 * hugeint_t fixes by @carlopi in https://github.com/duckdb/duckdb/pull/19318 * Use CMAKE_<LANG>_COMPILER_LAUNCHER by @evertlammerts in https:/

This is a bug fix release for various issues discovered after we released 1.4.0. ## What's Changed * Fix attach to right DB when using DuckLake by @pdet in https://github.com/duckdb/duckdb/pull/19011 * set default value of MAIN_BRANCH_VERSIONING to false by @c-herrewijn in https://github.com/duckdb/duckdb/pull/19014 * ComplexJSON: parse all valid JSON correctly by @Mytherin in https://github.com/duckdb/duckdb/pull/19024 * Issue #19016: ICU Offset Parsing by @hawkfish in https://github.com/duckdb/duckdb/pull/19029 * Throw if we detect a quoted new line with the null padding set in parallel mode by @pdet in https://github.com/duckdb/duckdb/pull/19012 * Bump iceberg & ducklake by @carlopi in https://github.com/duckdb/duckdb/pull/19037 * Build Fix: `unordered_map<enum class` is not supported in all compilers, use `map<` instead by @Mytherin in https://github.com/duckdb/duckdb/pull/19046 * Disable emitting versioned libraries by default by @Mytherin in https://github.com/duckdb/duckdb/pull/19047 * Re-add aliased settings to duckdb_settings() view, and some fixes for aliased settings by @Mytherin in https://github.com/duckdb/duckdb/pull/19050 * Fix threading issues in metad