DuckDB

This is a bug fix release for various issues discovered after we released v1.5.4.

What's Changed

• backport the out-of-bounds security fixes made in #23100 by @Tishj in https://github.com/duckdb/duckdb/pull/23197
• Remove checked_array_iterator from fmt dep (1.4) by @carlopi in https://github.com/duckdb/duckdb/pull/23261
• Remove checked_array_iterator from fmt dep (1.4) by @staticlibs in https://github.com/duckdb/duckdb/pull/23239
• [Dev] Add LLDB scripts to help with debugging by @Tishj in https://github.com/duckdb/duckdb/pull/23297
• Add support for test config extending by @NiclasHaderer in https://github.com/duckdb/duckdb/pull/23145
• bump iceberg again by @Tmonster in https://github.com/duckdb/duckdb/pull/23311
• Correctly get typed value stats for fully shredded variants by @Mytherin in https://github.com/duckdb/duckdb/pull/23325
• bump unity to include backfill fix by @benfleis in https://github.com/duckdb/duckdb/pull/23326
• Add request body length to http logs by @DinosL in https://github.com/duckdb/duckdb/pull/23316
• Show transport errors in HTTP log by @DinosL in https://github.com/duckdb/duckdb/pull/23327
• Dispatch Rust nightly build by @mlafeldt in https://github.com/duckdb/duckdb/pull/23352
• parquet: reject DATA_PAGE_V2 pages with inconsistent compressed_page_size by @benfleis in https://github.com/duckdb/duckdb/pull/23279
• Fix deadlock in TemporaryMemoryManager by @lnkuiper in https://github.com/duckdb/duckdb/pull/23351
• Register oid of dependencies in the DependencyManager so that we can track if an object was re-created with the same name by @Mytherin in https://github.com/duckdb/duckdb/pull/23348
• [Dev] Fix recursion issue with scripts/lldb/pointer_print by @Tishj in https://github.com/duckdb/duckdb/pull/23362
• [MultiFileReader] Prevent NULL MAP keys because of (likely missing) default value by @Tishj in https://github.com/duckdb/duckdb/pull/23354
• Propagate lambda bindings into try operator by @Mytherin in https://github.com/duckdb/duckdb/pull/23375
• Bump Julia to v1.5.4 by @carlopi in https://github.com/duckdb/duckdb/pull/23398
• Add additional guards to DICT_FSST to prevent exception during compression with small block size by @sebastiaan-dev in https://github.com/duckdb/duckdb/pull/23341
• fix out-of-bounds read in json path ReadKey lookahead by @jmestwa-coder in https://github.com/duckdb/duckdb/pull/23371
• fix out-of-bounds read in string to struct cast by @jmestwa-coder in https://github.com/duckdb/duckdb/pull/23384
• Issue #23383: Common Aggregate CTEs by @hawkfish in https://github.com/duckdb/duckdb/pull/23409
• Use correct start time when verifying dependencies by @Mytherin in https://github.com/duckdb/duckdb/pull/23430
• Fix false RLE corruption error by @DinosL in https://github.com/duckdb/duckdb/pull/23458
• [v1.5] No cache if file doesn't contain version information by @dentiny in https://github.com/duckdb/duckdb/pull/23434
• Improve rle corruption error messages by @DinosL in https://github.com/duckdb/duckdb/pull/23480
• Issue #23457: Ordered FIRST_VALUE Framing by @hawkfish in https://github.com/duckdb/duckdb/pull/23499
• Enabled ALP and ALP_RD for storage version v1.5.0 and up when using smaller block sizes by @sebastiaan-dev in https://github.com/duckdb/duckdb/pull/23483
• [v1.5] Backport PR #23444: fix eviction node memleak when external fi… by @dentiny in https://github.com/duckdb/duckdb/pull/23479
• [v1.5] Fix min/max aggregate stats when row groups filtered by @dentiny in https://github.com/duckdb/duckdb/pull/23517
• Backport #23468 and #23510 by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/23529
• Fix arrow type extension bugs by @evertlammerts in https://github.com/duckdb/duckdb/pull/23534
• Issue #23500: JSON TIMESTAMP_TZ Formatting by @hawkfish in https://github.com/duckdb/duckdb/pull/23513
• fix out-of-bounds read in dictionary string decompression by @jmestwa-coder in https://github.com/duckdb/duckdb/pull/23549
• Merge v1.4 into v1.5 by @carlopi in https://github.com/duckdb/duckdb/pull/23560
• [ADBC] Add support for duckdb:// URI scheme in URI option by @amoeba in https://github.com/duckdb/duckdb/pull/21293
• Fix/capi scalar bind subquery crash by @krleonid in https://github.com/duckdb/duckdb/pull/23566
• [variegata] Bump extensions by @carlopi in https://github.com/duckdb/duckdb/pull/23562
• Fix filter combiner not pruning unsatisfiable bounds by @DinosL in https://github.com/duckdb/duckdb/pull/23563
• fix out-of-bounds read on empty byte array decimals by @jmestwa-coder in https://github.com/duckdb/duckdb/pull/23567
• [v1.5] Quickfix ALTER TABLE ADD COLUMN IF NOT EXISTS ... DEFAULT regression by @yan-alex in https://github.com/duckdb/duckdb/pull/23507
• Bump version map to include v1.5.5 by @carlopi in https://github.com/duckdb/duckdb/pull/23629
• backport #23548 to v1.5 by @myrrc in https://github.com/duckdb/duckdb/pull/23587
• Issue #23641: CUME_DIST Underflow by @hawkfish in https://github.com/duckdb/duckdb/pull/23651
• Fixed unsafe iteration when parent is NULL in string cast by @sebastiaan-dev in https://github.com/duckdb/duckdb/pull/23593
• Bump HTTPFS by @lnkuiper in https://github.com/duckdb/duckdb/pull/23648
• backport #23573 by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/23672
• fix(adbc): support the ADBC Statistics API by @eitsupi in https://github.com/duckdb/duckdb/pull/23230
• Issue #23664: RANGE ZERO by @hawkfish in https://github.com/duckdb/duckdb/pull/23710
• Fix DROP COLUMN corrupting per-column metadata block bookkeeping by @ywelsch in https://github.com/duckdb/duckdb/pull/23714
• Include extension header in libduckdb archives by @mlafeldt in https://github.com/duckdb/duckdb/pull/23752
• Correctly promote SUGGEST_NEW to REQUIRE_NEW for variant / geometry columns by @Mytherin in https://github.com/duckdb/duckdb/pull/23763
• Fix lance build on Rust 1.97: patch its Cargo.lock to ethnum 1.5.3 by @carlopi in https://github.com/duckdb/duckdb/pull/23770
• Bump Postgres, MySQL and SQLite in 1.5 by @staticlibs in https://github.com/duckdb/duckdb/pull/23780
• Fix segfault in external hash aggregate when radix bits grow after going external by @carlopi in https://github.com/duckdb/duckdb/pull/23757
• Add HTTPUtil::ShouldRetry(request, response) retry-classification hook by @carlopi in https://github.com/duckdb/duckdb/pull/23793
• Bump azure, unity_catalog extensions to v1.5-variegata HEAD by @benfleis in https://github.com/duckdb/duckdb/pull/23800
• Bump extensions in preparation for v1.5.5 by @carlopi in https://github.com/duckdb/duckdb/pull/23794
• bump iceberg by @lnkuiper in https://github.com/duckdb/duckdb/pull/23735
• Fix for malformed JSON when rendering via duckbox by @sebastiaan-dev in https://github.com/duckdb/duckdb/pull/23803
• [v1.5] Backport a few fix PRs for v1.5.5 release by @dentiny in https://github.com/duckdb/duckdb/pull/23804
• bound alp/alprd exception positions to vector size by @jmestwa-coder in https://github.com/duckdb/duckdb/pull/23778
• Fix swapped min/max for multi-row-group 128-bit DECIMAL in RETURN_STATS by @sfc-gh-okalaci in https://github.com/duckdb/duckdb/pull/23693
• [variegata] Bump quack to 8e715ebb by @carlopi in https://github.com/duckdb/duckdb/pull/23820
• backport #22198 by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/23810
• [v1.5] Backport two more fixes by @dentiny in https://github.com/duckdb/duckdb/pull/23841
• [DependencyManager] Fix ALTER dependency preservation by @Tishj in https://github.com/duckdb/duckdb/pull/23808
• TryLookupEntry now uses default schema as fallback by @okruitho in https://github.com/duckdb/duckdb/pull/23790
• Fix concurrent ALTER and INSERT crash by @Tishj in https://github.com/duckdb/duckdb/pull/23861
• Bump Postgres extension for 1.5 by @staticlibs in https://github.com/duckdb/duckdb/pull/23930
• [v1.5 backport] Fix: reset empty_range in the TIMESTAMP range() table function by @wmTJc9IK0Q in https://github.com/duckdb/duckdb/pull/23879
• Bump extensions for v1.5.5: quack, httpfs and aws by @carlopi in https://github.com/duckdb/duckdb/pull/23892
• Expose destructors, so they are callable module boundaries by @carlopi in https://github.com/duckdb/duckdb/pull/23953
• Bump DuckLake by @pdet in https://github.com/duckdb/duckdb/pull/23962
• Fix OSX ci by @Tmonster in https://github.com/duckdb/duckdb/pull/23963
• Bump lance pin to upstream ethnum fix, drop local patch by @carlopi in https://github.com/duckdb/duckdb/pull/23969
• Add missing statement types to capi by @hrl20 in https://github.com/duckdb/duckdb/pull/23407
• Bump httpfs by @lnkuiper in https://github.com/duckdb/duckdb/pull/24003

Full Changelog: https://github.com/duckdb/duckdb/compare/v1.5.4...v1.5.5

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

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 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 by @carlopi in https://github.com/duckdb/duckdb/pull/21410
• add lance for v1.4 by @samansmink in https://github.com/duckdb/duckdb/pull/21113
• Correctly detect overflows when decoding integers from storage by @Mytherin in https://github.com/duckdb/duckdb/pull/21482
• Bump Julia to v1.4.4 on v1.4-andium by @taniabogatsch in https://github.com/duckdb/duckdb/pull/21589
• Fix for CSV reader buffer-boundary value read by @Mytherin in https://github.com/duckdb/duckdb/pull/21577
• Backport __EMSCRIPTEN__ fix by @Mytherin in https://github.com/duckdb/duckdb/pull/21581
• counting fix by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/21733
• 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
• Bump httpfs to fix CI by @sebastiaan-dev in https://github.com/duckdb/duckdb/pull/22817
• bump avro hash for 1.4.5 by @djouallah in https://github.com/duckdb/duckdb/pull/22952
• Rename emscripten action in v1.4 by @smvv in https://github.com/duckdb/duckdb/pull/23045
• Add v1.4.5 to storage version map by @carlopi in https://github.com/duckdb/duckdb/pull/23081
• 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 extensions to v1.4-andium by @carlopi in https://github.com/duckdb/duckdb/pull/23090
• backport GetLocalFileSystem improvements to andium by @ccfelius in https://github.com/duckdb/duckdb/pull/23130
• backport the out-of-bounds security fixes made in #23100 by @Tishj in https://github.com/duckdb/duckdb/pull/23197
• Remove checked_array_iterator from fmt dep (1.4) by @carlopi in https://github.com/duckdb/duckdb/pull/23261
• Remove checked_array_iterator from fmt dep (1.4) by @staticlibs in https://github.com/duckdb/duckdb/pull/23239

Full Changelog: https://github.com/duckdb/duckdb/compare/v1.4.4...v1.4.5

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/duckdb/duckdb/pull/22056
• Fix constant struct args in lateral table in-out functions by @AlfieJones in https://github.com/duckdb/duckdb/pull/21827
• Avoid handling Ctrl+C during shutdown (state might be already gone) by @carlopi in https://github.com/duckdb/duckdb/pull/22059
• Add DISABLE_BUILTIN_HTTPLIB option by @carlopi in https://github.com/duckdb/duckdb/pull/22054
• Set query field for statements in ALTER TABLE ... ADD COLUMN ... DEFAULT ... workaround by @yan-alex in https://github.com/duckdb/duckdb/pull/22057
• Coorporative tasks might lead to busy spinning in TaskExecutor::WorkOnTasks by @NiclasHaderer in https://github.com/duckdb/duckdb/pull/22092
• Row group append by @evertlammerts in https://github.com/duckdb/duckdb/pull/22060
• Fix empty parquet child schema by @dentiny in https://github.com/duckdb/duckdb/pull/22105
• Issue #22096: TopN Window Casts by @hawkfish in https://github.com/duckdb/duckdb/pull/22098
• Add support for reading VARIANT using C API by @Dtenwolde in https://github.com/duckdb/duckdb/pull/22065
• Bump Julia to v1.5.2 by @taniabogatsch in https://github.com/duckdb/duckdb/pull/22121
• fix commit iteration offset bug + relax RemoveFromIndexes assertion by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/22094
• Internal #8812: From TIMESTAMPTZ Casts by @hawkfish in https://github.com/duckdb/duckdb/pull/22000
• Only build plan_serializer when building the main DuckDB library by @rustyconover in https://github.com/duckdb/duckdb/pull/22100
• Fix Row Group Pruner Distinct Bug by @d-justen in https://github.com/duckdb/duckdb/pull/22132
• Correctly skip preprocessing PIVOT MultiStatements by @yan-alex in https://github.com/duckdb/duckdb/pull/22141
• fix(adbc): report the table name if the table doesn't exist when appending by @eitsupi in https://github.com/duckdb/duckdb/pull/22146
• [v1.5 patch] Attempt to fix cache read by @dentiny in https://github.com/duckdb/duckdb/pull/22126
• Also execute auto-rollback on CLI ClientContext::Query() query by @yan-alex in https://github.com/duckdb/duckdb/pull/22159
• Fix window self join optimizer by @kryonix in https://github.com/duckdb/duckdb/pull/22164
• Account for ROW_GROUP_SIZE when deciding whether to append to an existing row group by @evertlammerts in https://github.com/duckdb/duckdb/pull/22109
• Use the latest storage version for temp storage by @Mytherin in https://github.com/duckdb/duckdb/pull/22169
• Fix: Add pg_catalog.pg_collation compatibility view for SQLAlchemy 2.0.45 reflection by @alonfaraj in https://github.com/duckdb/duckdb/pull/22160
• Fix CSV escape by @dentiny in https://github.com/duckdb/duckdb/pull/22176
• Fix union_by_name remap for non-nested parquet columns by @feichai0017 in https://github.com/duckdb/duckdb/pull/22177
• User-facing enable_caching_operators setting by @lnkuiper in https://github.com/duckdb/duckdb/pull/22191
• Fix bignum sum Combine to correctly take over memory ownership of state by @Mytherin in https://github.com/duckdb/duckdb/pull/22209
• CompressedFile::Close -> calls Close on its child_handle by @benfleis in https://github.com/duckdb/duckdb/pull/22149
• ISSUE-22061: Fix JSON shell output: emit BOOLEAN as true/false, not strings by @herbenderbler in https://github.com/duckdb/duckdb/pull/22073
• [Bugfix] Reset pg_err_pos in pg_parser_init to prevent stale error position leaking by @p1p1bear in https://github.com/duckdb/duckdb/pull/22239
• Bump httpfs to 3139e40a by @carlopi in https://github.com/duckdb/duckdb/pull/22248
• Correctly use new row group when checkpointing, and avoid incorrectly re-using metadata when targeting older storage versions and row ids have changed by @Mytherin in https://github.com/duckdb/duckdb/pull/22253
• Fix: release ParquetReader when a file is marked SKIPPED in multi-file scan by @J-Meyers in https://github.com/duckdb/duckdb/pull/22261
• Fix UTC±NN00 cannot be parsed in SQL by @tianjq16 in https://github.com/duckdb/duckdb/pull/22244
• Defer Bloom Filter Pushdown until it's done by @lnkuiper in https://github.com/duckdb/duckdb/pull/22218
• [v1.5] Backport ADBC memleak fix on error path by @dentiny in https://github.com/duckdb/duckdb/pull/22216
• Allow package builds to choose linked extensions by @mlafeldt in https://github.com/duckdb/duckdb/pull/22305
• Fix UTC+HHMM time zone was parsed incorrectly by @tianjq16 in https://github.com/duckdb/duckdb/pull/22297
• Bump httpfs by @carlopi in https://github.com/duckdb/duckdb/pull/22312
• Exception format: accept string literals by @carlopi in https://github.com/duckdb/duckdb/pull/22314
• Skip schema analysis even if no shredding for rowgroup by @rgernhardt in https://github.com/duckdb/duckdb/pull/21937
• Use batch limit for table scans with filters by @Mytherin in https://github.com/duckdb/duckdb/pull/22315
• Also redacting bearer token for HTTP secrets by @hannes in https://github.com/duckdb/duckdb/pull/22323
• First initialize system, then load extensions (to peek at file to be opened) by @carlopi in https://github.com/duckdb/duckdb/pull/22341
• Node Handle Scoping fix by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/22344
• Enable windows_amd64 for lance extension by @carlopi in https://github.com/duckdb/duckdb/pull/22367
• Internal #9003: TIMETZ Parsing Limit by @hawkfish in https://github.com/duckdb/duckdb/pull/22378
• Downcasting decimal fix incorrect out of range error by @Dtenwolde in https://github.com/duckdb/duckdb/pull/22386
• GetLocalFileSystem improvements by @carlopi in https://github.com/duckdb/duckdb/pull/21983
• Fix double decrement of evicted_data_per_tag in .block read-back by @krleonid in https://github.com/duckdb/duckdb/pull/22394
• RowGroup Operator metrics: sequentially scanned row groups + total row groups + cumulative counterparts by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/22339
• PostgreSQL compatability: in pg_catalog.pg_database simulate columns datallowconn, datistemplate by @muayyad-alsadi in https://github.com/duckdb/duckdb/pull/22302
• Fix eviction size metrics report by @dentiny in https://github.com/duckdb/duckdb/pull/22452
• Fix enable_logging() silently resetting logging_storage by @guillesd in https://github.com/duckdb/duckdb/pull/22475
• Avoid 3 instances of idx_t - idx_t > 0, and avoid unnecessary check on zLine by @carlopi in https://github.com/duckdb/duckdb/pull/22518
• Fix RESET my_global_extension_setting to actually be GLOBAL by @carlopi in https://github.com/duckdb/duckdb/pull/22520
• Fix BlockAllocator invalid memory access by @dentiny in https://github.com/duckdb/duckdb/pull/22503
• Patch httplib by making ThreadPool constructor more solid on pthread_create failures by @carlopi in https://github.com/duckdb/duckdb/pull/22516
• Fix duck fuzz #4430 by @dentiny in https://github.com/duckdb/duckdb/pull/22435
• Test runner: avoid running clean-up routine if there is no database to run it in by @Mytherin in https://github.com/duckdb/duckdb/pull/22540
• Fix bare numeric interval parsing at end of string on v1.5 by @M1llerF in https://github.com/duckdb/duckdb/pull/22534
• Fix parquet metadata cache validation by @dentiny in https://github.com/duckdb/duckdb/pull/22547
• ExtensionInstall: Remove use of IsHTTP to IsRemoteFile by @carlopi in https://github.com/duckdb/duckdb/pull/21900
• Fix variant write small decimal by @dentiny in https://github.com/duckdb/duckdb/pull/22544
• Move http_proxy setting to global setting, and use GetEnvVariable('HTTP_PROXY') as default by @carlopi in https://github.com/duckdb/duckdb/pull/22541
• Bump httpfs and remove patches by @carlopi in https://github.com/duckdb/duckdb/pull/22556
• Bump Postgres, MySQL and ODBC by @staticlibs in https://github.com/duckdb/duckdb/pull/22579
• Bump avro, azure, delta, ducklake, spatial, unity_catalog and vortex by @carlopi in https://github.com/duckdb/duckdb/pull/22554
• Fix variant selection vector index by @dentiny in https://github.com/duckdb/duckdb/pull/22573
• Fix for SIGABRT in setting size on zero-capacity vector by @ccfelius in https://github.com/duckdb/duckdb/pull/22571
• Fix incorrect profiling results when using LIMIT by @sebastiaan-dev in https://github.com/duckdb/duckdb/pull/22561
• Move Jemalloc into core by @Maxxen in https://github.com/duckdb/duckdb/pull/22558
• Allow json ts format variation across columns - issue 22103 by @benfleis in https://github.com/duckdb/duckdb/pull/22559
• Limit parallel linker jobs to avoid out-of-memory errors by @smvv in https://github.com/duckdb/duckdb/pull/22588
• ARTOperator::Delete return false if rowid not found in nested ART leaf by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/22591
• Enable/disable jemalloc linking through BUILD/SKIP_EXTENSIONS by @Maxxen in https://github.com/duckdb/duckdb/pull/22594
• Bump AWS extension by @staticlibs in https://github.com/duckdb/duckdb/pull/22600
• bump spatial again by @Maxxen in https://github.com/duckdb/duckdb/pull/22602
• Jemalloc is not an extension anymore by @carlopi in https://github.com/duckdb/duckdb/pull/22603
• bump iceberg by @Tmonster in https://github.com/duckdb/duckdb/pull/22608
• CUMULATIVE_VACUUM_TIME metric by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/22425
• parser_tools is apparently now a dependency for postgres by @carlopi in https://github.com/duckdb/duckdb/pull/22619
• Bump DuckLake for release by @pdet in https://github.com/duckdb/duckdb/pull/22651
• Bump lance to 533e0ee6cf419e4be2af3af56182fb04b87978e1 by @carlopi in https://github.com/duckdb/duckdb/pull/22640
• Add storage informations for v1.5.3 by @carlopi in https://github.com/duckdb/duckdb/pull/22638
• Add quack autoloading by @carlopi in https://github.com/duckdb/duckdb/pull/22631
• Add quack extension by @carlopi in https://github.com/duckdb/duckdb/pull/22614
• bump aws extension by @samansmink in https://github.com/duckdb/duckdb/pull/22623
• bump avro+iceberg+vcpkg-duckdb-ports by @Tishj in https://github.com/duckdb/duckdb/pull/22621
• optimizer: don't return truncated VARCHAR MIN/MAX from statistics by @nahomar in https://github.com/duckdb/duckdb/pull/22538
• Bump excel / remove patch by @carlopi in https://github.com/duckdb/duckdb/pull/22633
• Bump sqlsmith, remove patch by @carlopi in https://github.com/duckdb/duckdb/pull/22622
• Fix free block for temporary file manageer by @dentiny in https://github.com/duckdb/duckdb/pull/22616
• Add dummy cmake target for jemalloc by @evertlammerts in https://github.com/duckdb/duckdb/pull/22632
• Bump quack by @carlopi in https://github.com/duckdb/duckdb/pull/22659
• Fix invalid access for file row number by @dentiny in https://github.com/duckdb/duckdb/pull/22662
• Fix enum type write to parquet by @dentiny in https://github.com/duckdb/duckdb/pull/22677
• Add write_buffer_row_group_memory_limit setting which controls when to flush row groups based on memory instead of only based on row group count by @Mytherin in https://github.com/duckdb/duckdb/pull/22666
• Fix max file row number by @dentiny in https://github.com/duckdb/duckdb/pull/22688
• Fix new jemalloc plumbing by @mlafeldt in https://github.com/duckdb/duckdb/pull/22628
• Bump DuckLake by @pdet in https://github.com/duckdb/duckdb/pull/22698
• Fix timer lifetime/timing issues by @taniabogatsch in https://github.com/duckdb/duckdb/pull/22697
• Enable jemalloc heap profiling with the libgcc unwinder by @mlafeldt in https://github.com/duckdb/duckdb/pull/22630
• Fix jemalloc thread flush threshold check by @xuke-hat in https://github.com/duckdb/duckdb/pull/22670
• Make several storage internals public by @samansmink in https://github.com/duckdb/duckdb/pull/22718
• Fix GCC jemalloc symbol leakage CI failure by @lnkuiper in https://github.com/duckdb/duckdb/pull/22729
• Fix iterator invalidation in ConnectionManager::GetConnectionList by @bleskes in https://github.com/duckdb/duckdb/pull/22719
• Bump quack, fixes quack_serve on wasm by @carlopi in https://github.com/duckdb/duckdb/pull/22722
• bump iceberg again by @Tmonster in https://github.com/duckdb/duckdb/pull/22723
• fix: list_zip SEGFAULT with empty / NULL argument by @carlopi in https://github.com/duckdb/duckdb/pull/22726
• Fix .sanitizer-thread-suppressions.txt jemalloc ref by @carlopi in https://github.com/duckdb/duckdb/pull/22736
• Revert "Enable jemalloc heap profiling with the libgcc unwinder" by @carlopi in https://github.com/duckdb/duckdb/pull/22740
• RowGroupPruner: treat UNSET LIMIT as unbounded by @ColtenOuO in https://github.com/duckdb/duckdb/pull/22744
• Return an error if a negative number is passed to the factorial function by @DinosL in https://github.com/duckdb/duckdb/pull/22731

Full Changelog: https://github.com/duckdb/duckdb/compare/v1.5.2...v1.5.3

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 by @carlopi in https://github.com/duckdb/duckdb/pull/21410
• add lance for v1.4 by @samansmink in https://github.com/duckdb/duckdb/pull/21113
• Correctly detect overflows when decoding integers from storage by @Mytherin in https://github.com/duckdb/duckdb/pull/21482
• Correctly revert dictionary size when reverting string appends by @Mytherin in https://github.com/duckdb/duckdb/pull/21489
• Add descriptions for vortex and lance by @carlopi in https://github.com/duckdb/duckdb/pull/21500
• Fixup Write bytes are counted as BYTES_WRITTEN by @carlopi in https://github.com/duckdb/duckdb/pull/21501
• Fix memory leak when reusing PreparedStatement (#21089) by @wzharies in https://github.com/duckdb/duckdb/pull/21104
• Make some MultiStatements and PRAGMAs Transactional by @yan-alex in https://github.com/duckdb/duckdb/pull/21171
• Reduce concurrent thread count in test by @Mytherin in https://github.com/duckdb/duckdb/pull/21511
• Fixing integer overflow in list_resize by @hannes in https://github.com/duckdb/duckdb/pull/21515
• Fix #21512: correctly render empty results in .mode json by @Mytherin in https://github.com/duckdb/duckdb/pull/21517
• Fix parsing test path to skip by @jeewonhh in https://github.com/duckdb/duckdb/pull/21495
• Add setting for limiting the number of threads launched concurrently in the test runner (max_test_threads) by @Mytherin in https://github.com/duckdb/duckdb/pull/21520
• Unify adding suffixes to path in Path:: AddSuffixToPath - fix temp directory split bug by @Mytherin in https://github.com/duckdb/duckdb/pull/21527
• Correctly deal with negative values in GetPosixVersionTag, and fix constant NULL struct scans after recent fix by @Mytherin in https://github.com/duckdb/duckdb/pull/21549
• Fix missing extension static libs in Windows MinGW bundle by @mlafeldt in https://github.com/duckdb/duckdb/pull/21559
• PEG grammar fixes: Update extension and allow numeric struct keys by @Dtenwolde in https://github.com/duckdb/duckdb/pull/21331
• [v1.5-variegata] Fix #21514: ASOF join empty right by @Pieczasz in https://github.com/duckdb/duckdb/pull/21553
• Fix data path in test/sql/copy/parquet/parquet_no_stats.test by @jeewonhh in https://github.com/duckdb/duckdb/pull/21561
• TopNWindowElimination Column Binding Fix by @d-justen in https://github.com/duckdb/duckdb/pull/21564
• lance: bump lance-duckdb to 4d9ecab by @Xuanwo in https://github.com/duckdb/duckdb/pull/21572
• Bump Julia to v1.5.0 by @taniabogatsch in https://github.com/duckdb/duckdb/pull/21588
• Bump Julia to v1.4.4 on v1.4-andium by @taniabogatsch in https://github.com/duckdb/duckdb/pull/21589
• Simplify the way we determine which row groups to checkpoint during checkpoints by @Mytherin in https://github.com/duckdb/duckdb/pull/21574
• Fix for CSV reader buffer-boundary value read by @Mytherin in https://github.com/duckdb/duckdb/pull/21577
• CLI: Avoid division by zero when formatting a large result with a non-wide shell by @Mytherin in https://github.com/duckdb/duckdb/pull/21591
• Backport __EMSCRIPTEN__ fix by @Mytherin in https://github.com/duckdb/duckdb/pull/21581
• Fix missing SetSizeAndFinalize in BIGNUM Add for zero result case by @pdet in https://github.com/duckdb/duckdb/pull/21465
• Segfault due to unchecked malloc/realloc, proposed fix to #21593 by @wasade in https://github.com/duckdb/duckdb/pull/21594
• Reduce arg_min_max_n heap preallocation by @feichai0017 in https://github.com/duckdb/duckdb/pull/21467
• Fixed an issue where the describe statement did not work correctly in markdown output mode(ISSUE:#21579) by @ArNine in https://github.com/duckdb/duckdb/pull/21611
• fix unpivot serialization by @Maxxen in https://github.com/duckdb/duckdb/pull/21595
• Windows shell: enable VT100 processing on startup by @staticlibs in https://github.com/duckdb/duckdb/pull/21615
• Make PEG Parser use strict mode in CI by @Dtenwolde in https://github.com/duckdb/duckdb/pull/21590
• Fix #21623: flatten input chunk in TopNHeap::CheckBoundaryValues by @Mytherin in https://github.com/duckdb/duckdb/pull/21629
• Issue #21592: Window Self-Join Framing by @hawkfish in https://github.com/duckdb/duckdb/pull/21628
• Bump Julia to v1.5.1 by @taniabogatsch in https://github.com/duckdb/duckdb/pull/21637
• Merge v1.4-andium into v1.5-variegata by @Mytherin in https://github.com/duckdb/duckdb/pull/21639
• Bump storage version to v1.5.2 by @taniabogatsch in https://github.com/duckdb/duckdb/pull/21638
• bump delta and unity_catalog ext refs in v1.5-variegata by @benfleis in https://github.com/duckdb/duckdb/pull/21640
• Fix cancellation order between pipelines and tasks in CancelTasks by @carlopi in https://github.com/duckdb/duckdb/pull/21642
• Fix shell completion enter handling by @atulagrwl in https://github.com/duckdb/duckdb/pull/21552
• fix(adbc): err use after free by @gishor in https://github.com/duckdb/duckdb/pull/21605
• Fix some Parquet fuzzer issues by @lnkuiper in https://github.com/duckdb/duckdb/pull/21635
• Re-organize WAL replay slightly, and correctly deal with empty checkpoint WAL files in WAL recovery by @Mytherin in https://github.com/duckdb/duckdb/pull/21645
• Warn instead of error when trying to persist geometry columns with CRS in old storage format by @Maxxen in https://github.com/duckdb/duckdb/pull/21649
• Avoid throwing an error when failing to bind views in duckdb_columns by @Mytherin in https://github.com/duckdb/duckdb/pull/21658
• Infer timestamps with timezone in read_json_auto by @leo-altertable in https://github.com/duckdb/duckdb/pull/21660
• Windows: remove prefix from canonical paths by @staticlibs in https://github.com/duckdb/duckdb/pull/21652
• CLI: Add .help shortcuts by @carlopi in https://github.com/duckdb/duckdb/pull/21662
• Internal #8553: Window TopN Except by @hawkfish in https://github.com/duckdb/duckdb/pull/21671
• Fix issue with struct filter on missing structs by @Mytherin in https://github.com/duckdb/duckdb/pull/21676
• Internal #7568: ASOF SEMI Test by @hawkfish in https://github.com/duckdb/duckdb/pull/21683
• Fix type check in st_crs by @Maxxen in https://github.com/duckdb/duckdb/pull/21688
• Disable regular updates for geometry by @Maxxen in https://github.com/duckdb/duckdb/pull/21641
• Fix stoi crash in Arrow format string parsing for w: and +w: types by @yharby in https://github.com/duckdb/duckdb/pull/21692
• Test runner: Support replacement without dollar ({i} instead of ${i}) in loop iterators by @Mytherin in https://github.com/duckdb/duckdb/pull/21708
• Internal #8657: IEJoin Filter Sides by @hawkfish in https://github.com/duckdb/duckdb/pull/21721
• Add missing test for delta byte array by @ccfelius in https://github.com/duckdb/duckdb/pull/21714
• Fix variant shredding consistency issue by @Tishj in https://github.com/duckdb/duckdb/pull/21715
• TopNWindowElimination fixes by @d-justen in https://github.com/duckdb/duckdb/pull/21663
• Ignore NULL/__HIVE_DEFAULT_PARTITION__ when detecting types by @lnkuiper in https://github.com/duckdb/duckdb/pull/21731
• fix path test warnings by @benfleis in https://github.com/duckdb/duckdb/pull/21711
• Allow SET DEFAULT / DROP DEFAULT for tables that have dependencies by @Mytherin in https://github.com/duckdb/duckdb/pull/21729
• Add clickbench by @c-herrewijn in https://github.com/duckdb/duckdb/pull/21730
• Fix prepared temp-table INSERT invalidation after DROP by @wordhardqi in https://github.com/duckdb/duckdb/pull/21712
• Allow join filter pushdown through integral up/down casts by @lnkuiper in https://github.com/duckdb/duckdb/pull/21743
• Allow join filter pushdown for NOP collations by @lnkuiper in https://github.com/duckdb/duckdb/pull/21742
• counting fix by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/21733
• [Variant] Re-add the removed variant_legacy_encoding setting by @Tishj in https://github.com/duckdb/duckdb/pull/21710
• Fix update plans when deserializing if type no longer supports regular updates by @Maxxen in https://github.com/duckdb/duckdb/pull/21718
• Re-instantiate dependencies of tables for ALTER TABLE ... DROP COLUMN and ALTER TABLE .. SET DEFAULT by @Mytherin in https://github.com/duckdb/duckdb/pull/21752
• Use correct error message for name conflicts between table and views by @JelteF in https://github.com/duckdb/duckdb/pull/21760
• Bump spatial by @taniabogatsch in https://github.com/duckdb/duckdb/pull/21781
• PEG parser strict mode: followup fixes and improvements by @Dtenwolde in https://github.com/duckdb/duckdb/pull/21709
• Fix DELETE RETURNING for rows inserted in the same transaction by @rustyconover in https://github.com/duckdb/duckdb/pull/21541
• Disable bloom filter pushdown through casts by @lnkuiper in https://github.com/duckdb/duckdb/pull/21792
• Bugfixes by @lnkuiper in https://github.com/duckdb/duckdb/pull/21793
• Bump test utils by @taniabogatsch in https://github.com/duckdb/duckdb/pull/21795
• Expose HIDDEN as an ATTACH option by @utay in https://github.com/duckdb/duckdb/pull/21764
• Fix TopN window elimination with external CTE refs by @feichai0017 in https://github.com/duckdb/duckdb/pull/21686
• Issue #21682: TopN Window Sets by @hawkfish in https://github.com/duckdb/duckdb/pull/21775
• Add support for reading geometry type to the C-API by @Maxxen in https://github.com/duckdb/duckdb/pull/21763
• Fix ADBC data race by @dentiny in https://github.com/duckdb/duckdb/pull/21800
• Fix Arrow REE INT64 run_ends using wrong template parameter by @rustyconover in https://github.com/duckdb/duckdb/pull/21847
• Fix integer overflow crash in list repeat function by @rustyconover in https://github.com/duckdb/duckdb/pull/21873
• [minor] Fix CreateViewInfo::Copy() not copying names by @LucaSoato in https://github.com/duckdb/duckdb/pull/21819
• Fix case-sensitive default database check allowing detach of default database by @rustyconover in https://github.com/duckdb/duckdb/pull/21863
• Fix geometry TextWriter corrupting coordinates in scientific notation by @rustyconover in https://github.com/duckdb/duckdb/pull/21893
• Issue #21820: TopN Window Projections by @hawkfish in https://github.com/duckdb/duckdb/pull/21902
• Bump Postgres, MySQL and SQLite by @staticlibs in https://github.com/duckdb/duckdb/pull/21899
• AddToBeRescheduled: Avoid UB in assigning vs move by @carlopi in https://github.com/duckdb/duckdb/pull/21912
• vacuum_rebuild_indexes threshold setting by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/21769
• Fix CSV process over buffer out-of-bound access by @dentiny in https://github.com/duckdb/duckdb/pull/21840
• Fix is_histogram_other_bin handle null by @dentiny in https://github.com/duckdb/duckdb/pull/21841
• Merge v1.4-andium into v1.5-variegata by @Mytherin in https://github.com/duckdb/duckdb/pull/21919
• Fix in-place update to look only at updated columns by @jeewonhh in https://github.com/duckdb/duckdb/pull/21922
• Issue #21905: AGO Overflow Check by @hawkfish in https://github.com/duckdb/duckdb/pull/21936
• Fix common subplan optimizer bug by @kryonix in https://github.com/duckdb/duckdb/pull/21932
• Issue #21907: Invalid Window Macros by @hawkfish in https://github.com/duckdb/duckdb/pull/21929
• [ART] Fix information loss on index build cast by @taniabogatsch in https://github.com/duckdb/duckdb/pull/21815
• Improve geometry WKT parsing and add geometry to test_all_types v2 by @taniabogatsch in https://github.com/duckdb/duckdb/pull/21805
• Run ArrowConverter::ToArrowSchema in a transaction by @evertlammerts in https://github.com/duckdb/duckdb/pull/21927
• Fix invalid memory access when CSV columns less than expected by @dentiny in https://github.com/duckdb/duckdb/pull/21822
• Use BLOB, not VARCHAR for row group pruning by @lnkuiper in https://github.com/duckdb/duckdb/pull/21946
• Add HTTPUtil::CloseClient(...) with trivial no-op implementation, and base_url field to HTTPClient by @carlopi in https://github.com/duckdb/duckdb/pull/21924
• Fix incorrect results when using try within if by @jankramer in https://github.com/duckdb/duckdb/pull/21943
• lance: bump lance-duckdb to 1b4ef68 by @Xuanwo in https://github.com/duckdb/duckdb/pull/21944
• Fix Arrow union type_ids buffer ignoring chunk_offset by @rustyconover in https://github.com/duckdb/duckdb/pull/21848
• Make parser override work with parser extensions by @Dtenwolde in https://github.com/duckdb/duckdb/pull/21761
• [Dev] Bump the merge_vcpkg_deps script to bump the baseline of the registry by @Tishj in https://github.com/duckdb/duckdb/pull/21950
• Bump httpfs to include recent fixes, also adding new no-op setting by @carlopi in https://github.com/duckdb/duckdb/pull/21949
• Parquet writer: allow partial variant shredding in Parquet, instead of bailing out when a single struct field does not match by @Mytherin in https://github.com/duckdb/duckdb/pull/21959
• Bump Postgres by @staticlibs in https://github.com/duckdb/duckdb/pull/21958
• bump iceberg by @Tmonster in https://github.com/duckdb/duckdb/pull/21967
• [Parquet][VARIANT] Add support for Snowflake-produced shredded VARIANT Parquet files by @Tishj in https://github.com/duckdb/duckdb/pull/21814
• Make Oids start at 20k to avoid unintended collisions by @JelteF in https://github.com/duckdb/duckdb/pull/20979
• Unlock transaction lock during fallback WAL write by @Mytherin in https://github.com/duckdb/duckdb/pull/21969
• bump avro hash by @Tishj in https://github.com/duckdb/duckdb/pull/21974
• Shred unsigned types in VARIANT when writing to Parquet by @Mytherin in https://github.com/duckdb/duckdb/pull/21973
• Fix "make clangd" by @JelteF in https://github.com/duckdb/duckdb/pull/21981
• MERGE INTO - no need to extract logical get, we already know where it is by @Mytherin in https://github.com/duckdb/duckdb/pull/21984
• Attempt to fix invalid memory access by @dentiny in https://github.com/duckdb/duckdb/pull/21985
• Json function should be set CanThrow by @tianjq16 in https://github.com/duckdb/duckdb/pull/21972
• bump azure and delta for v1.5.2 by @benfleis in https://github.com/duckdb/duckdb/pull/21979
• Bumping DuckLake by @pdet in https://github.com/duckdb/duckdb/pull/21989
• Bump httpfs, now with implemented httpfs_connection_caching (opt-in) by @carlopi in https://github.com/duckdb/duckdb/pull/21982
• Revert "Run ArrowConverter::ToArrowSchema in a transaction" by @evertlammerts in https://github.com/duckdb/duckdb/pull/22007

Full Changelog: https://github.com/duckdb/duckdb/compare/v1.5.1...v1.5.2

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/21051
• fix: buffer overread in Arrow dictionary conversion with NULLs - fixes crash. by @rustyconover in https://github.com/duckdb/duckdb/pull/21083
• Avoid misleading GetRequestInfo constructor that takes endpoint + path by @carlopi in https://github.com/duckdb/duckdb/pull/21151
• Enable column pruning for MATERIALIZED CTEs by @kryonix in https://github.com/duckdb/duckdb/pull/21169
• Add framework to test two DuckDB versions by @Y-- in https://github.com/duckdb/duckdb/pull/21184
• Internal #7691: 2026a Time Zones by @hawkfish in https://github.com/duckdb/duckdb/pull/21204
• Fix DuckFuzz #4325 by @kryonix in https://github.com/duckdb/duckdb/pull/21215
• Fix decorrelation delim index bug by @kryonix in https://github.com/duckdb/duckdb/pull/21233
• Fix two minor shell bugs: Avoid mutating rendered strings and avoid p… by @carlopi in https://github.com/duckdb/duckdb/pull/21234
• Fix wrong cast in RecursiveDependentJoinPlanner by @kryonix in https://github.com/duckdb/duckdb/pull/21235
• Use atomic load in bloom filter look-up by @Mytherin in https://github.com/duckdb/duckdb/pull/21238
• Move BWC tests to nightly for now by @Mytherin in https://github.com/duckdb/duckdb/pull/21266
• Internal #7740: AsOf Tidy Fix by @hawkfish in https://github.com/duckdb/duckdb/pull/21255
• Re-add accidentally removed -jsonlines command line parameter by @Mytherin in https://github.com/duckdb/duckdb/pull/21263
• Switch MAIN_BRANCH_VERSIONING to False for v1.5-variegata branch by @carlopi in https://github.com/duckdb/duckdb/pull/21239
• Lazy call mmap in BlockAllocator by @lnkuiper in https://github.com/duckdb/duckdb/pull/21276
• Dynamically determine radix bits for external aggregation by @lnkuiper in https://github.com/duckdb/duckdb/pull/21274
• Avoid potential division by 0 in PhysicalHashJoin::PrepareFinalize by @lnkuiper in https://github.com/duckdb/duckdb/pull/21271
• Do not use MSYS shell for MinGW builds by @staticlibs in https://github.com/duckdb/duckdb/pull/21296
• add structured Path objects, update joinpath: normalize, support url/… by @benfleis in https://github.com/duckdb/duckdb/pull/21277
• When stress testing FORCE_ASYNC, add the relevant error messages by @carlopi in https://github.com/duckdb/duckdb/pull/21267
• Fix invalid JSON when casting from certain types by @Maxxen in https://github.com/duckdb/duckdb/pull/21280
• Fix .open of Parquet files etc. in CLI by @hannes in https://github.com/duckdb/duckdb/pull/21269
• Bump storage version to v1.5.1 by @taniabogatsch in https://github.com/duckdb/duckdb/pull/21287
• Implement line number reporting in errors for PEG parser by @Dtenwolde in https://github.com/duckdb/duckdb/pull/21157
• Support new v1.5 syntax for PEG grammar by @Dtenwolde in https://github.com/duckdb/duckdb/pull/21172
• [Fix] Memory error when transforming to v1.0.0 ART storage by @taniabogatsch in https://github.com/duckdb/duckdb/pull/21270
• Add missing expression traversal in merge into binding by @kryonix in https://github.com/duckdb/duckdb/pull/21283
• Add UUID to settings cache by @Mytherin in https://github.com/duckdb/duckdb/pull/21290
• Fix Terminal::TryGetBackgroundColor when stdin is reading from a pipe but stdout is still writing to the terminal by @Mytherin in https://github.com/duckdb/duckdb/pull/21288
• Fix #21248: correctly expand type count in CSV header detection by @Mytherin in https://github.com/duckdb/duckdb/pull/21292
• Add batch index support to parquet_metadata and friends to allow it to be executed in parallel also with order preservation by @Mytherin in https://github.com/duckdb/duckdb/pull/21314
• Make overriding HTTPUtil thread safe by @Mytherin in https://github.com/duckdb/duckdb/pull/21210
• Revert #21067 - and fix WAL corruption issue through calling MarkBlockAsCheckpointed on WAL blocks by @Mytherin in https://github.com/duckdb/duckdb/pull/21285
• Fix sampling for UB in musl libc by @carlopi in https://github.com/duckdb/duckdb/pull/21318
• TryGetCurrentSetting: Fixup paramater passing for FileOpenerInfo by @carlopi in https://github.com/duckdb/duckdb/pull/21301
• Fix Row Group Reorderer Bug by @d-justen in https://github.com/duckdb/duckdb/pull/21282
• Windows shell: fix UTF-8 to UTF-16 conversion by @staticlibs in https://github.com/duckdb/duckdb/pull/21319
• Issue #21244: AsOf Unordered LIMIT by @hawkfish in https://github.com/duckdb/duckdb/pull/21250
• Throw error on incorrect use of ParseExpressionList by @Dtenwolde in https://github.com/duckdb/duckdb/pull/21306
• Issue #20481: Prepare Window Parameters by @hawkfish in https://github.com/duckdb/duckdb/pull/21323
• CLI: Explicitly clean up shell state instead of letting static destructor order determine when it gets destroyed by @Mytherin in https://github.com/duckdb/duckdb/pull/21315
• Fixup 401bcf041f36f3abc39ecc6d50ba3dd336fc79d7: "When stress testing … by @carlopi in https://github.com/duckdb/duckdb/pull/21329
• CLI: Make bail on error the default in more situations by @Mytherin in https://github.com/duckdb/duckdb/pull/21344
• Improve estimate when first Parquet file is almost empty, and get exact cardinality count when we are using union by name by @Mytherin in https://github.com/duckdb/duckdb/pull/21345
• Fix infinite recursion in FileOpener::TryGetCurrentSetting by @Mytherin in https://github.com/duckdb/duckdb/pull/21356
• fix argument check for .multiline and .singleline by @jaywgraves in https://github.com/duckdb/duckdb/pull/21336
• Windows shell: remove .utf8 dot command by @staticlibs in https://github.com/duckdb/duckdb/pull/21343
• When writing unsupported Parquet variant types to Parquet, try to convert them to INT64 by @Mytherin in https://github.com/duckdb/duckdb/pull/21357
• Use cached Parquet metadata to improve cardinality estimates over Parquet files by @Mytherin in https://github.com/duckdb/duckdb/pull/21358
• Parquet Reader: Allow merging of prefetch column ranges for columns that do not have table filters by @Mytherin in https://github.com/duckdb/duckdb/pull/21373
• In the parquet reader, if we are globbing over a directory, use file sizes from the glob to estimate cardinalities instead of relying only on the first parquet file by @Mytherin in https://github.com/duckdb/duckdb/pull/21374
• MbedTLS: Actually throw exception by @hannes in https://github.com/duckdb/duckdb/pull/21365
• Well-defined environment for MinGW builds by @staticlibs in https://github.com/duckdb/duckdb/pull/21371
• Fix #21335: correctly add checkpoint and recovery WAL to allowed paths when launching an initial db with enable_external_access set to false by @Mytherin in https://github.com/duckdb/duckdb/pull/21379
• automate clangd/compile_commands.json gen via builds by @benfleis in https://github.com/duckdb/duckdb/pull/21361
• Parquet: Ignore optional filters when deciding whether or not to do a lazy fetch by @Mytherin in https://github.com/duckdb/duckdb/pull/21383
• parquet: avoid corrupting define buffers during skips by @Mikubill in https://github.com/duckdb/duckdb/pull/21298
• CLI: Fix .tables rendering for large database names by @Mytherin in https://github.com/duckdb/duckdb/pull/21389
• Fix column pruning for CTEs by @kryonix in https://github.com/duckdb/duckdb/pull/21275
• add test for #21271 by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/21398
• Grab correct row group id in ValidityColumnData::UpdateWithBase by @Mytherin in https://github.com/duckdb/duckdb/pull/21397
• Add lance extension by @carlopi in https://github.com/duckdb/duckdb/pull/21406
• add lance for v1.5 by @samansmink in https://github.com/duckdb/duckdb/pull/21111
• Fix #21289: correctly determine render width of UTF8 string with grapheme clusters by @Mytherin in https://github.com/duckdb/duckdb/pull/21409
• Avoid calling PushCollation in create_sort_key by @Mytherin in https://github.com/duckdb/duckdb/pull/21412
• Flush remaining operators in pipeline by @DinosL in https://github.com/duckdb/duckdb/pull/21405
• Correctly limit auto-detection in read_json for files that don't have string columns by @Mytherin in https://github.com/duckdb/duckdb/pull/21411
• Fix INSERT OR REPLACE updates on non-unique indexed columns by @feichai0017 in https://github.com/duckdb/duckdb/pull/20962
• fix(adbc): support concurrent statements on the same connection by @eitsupi in https://github.com/duckdb/duckdb/pull/21415
• Fix invalid common subplan CTE reuse for issue #21372 by @feichai0017 in https://github.com/duckdb/duckdb/pull/21386
• Use regular pushdown path for semi/anti/left delim joins by @Mytherin in https://github.com/duckdb/duckdb/pull/21416
• Predicate factoring by @lnkuiper in https://github.com/duckdb/duckdb/pull/21418
• Bump SQLite by @staticlibs in https://github.com/duckdb/duckdb/pull/21414
• Enable Row Group Pruner for NULLS_FIRST by @d-justen in https://github.com/duckdb/duckdb/pull/21399
• Read geoparquet file with null CRS. Fix #21332 by @philippechataignon in https://github.com/duckdb/duckdb/pull/21333
• test/sql/join/test_hash_join_many_columns.test needs 64bit by @carlopi in https://github.com/duckdb/duckdb/pull/21432
• Parquet Reader: initialize scan without holding the global lock in the multi file reader by @Mytherin in https://github.com/duckdb/duckdb/pull/21439
• bump spatial for v1.5.2 by @Maxxen in https://github.com/duckdb/duckdb/pull/21440
• [vortex] Bump to d0b5bae4d907694e776c97b57de6edfb662c6c25 by @carlopi in https://github.com/duckdb/duckdb/pull/21430
• Fix stale update read during index removal by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/21427
• Fix window elimination optimizer by @kryonix in https://github.com/duckdb/duckdb/pull/21428
• Avoid scanning struct validity when executing pushdown extract by @Mytherin in https://github.com/duckdb/duckdb/pull/21421
• Bump avro by @taniabogatsch in https://github.com/duckdb/duckdb/pull/21426
• Add allowed_configs option for allow-listing configs when setting lock_configurations by @hrl20 in https://github.com/duckdb/duckdb/pull/20938
• Fix minor typos in documentation and comments by @Monstertov in https://github.com/duckdb/duckdb/pull/21442
• Fix parquet metadata cache invalidation in local file system by @Mytherin in https://github.com/duckdb/duckdb/pull/21435
• Bump ducklake by @Mytherin in https://github.com/duckdb/duckdb/pull/21448
• [httpfs] Bump to 7e86e7a5e5 and remove patches by @carlopi in https://github.com/duckdb/duckdb/pull/21437
• verify_fetch_row.json + roaring seems to work as intended, restore by @carlopi in https://github.com/duckdb/duckdb/pull/21300
• Refactor for multiple external extensions, and skip temporary for osx_amd64 by @carlopi in https://github.com/duckdb/duckdb/pull/21450
• bump iceberg by @Tmonster in https://github.com/duckdb/duckdb/pull/21453
• Fix #21436: correctly preserve spaces within unquoted struct values in pretty printing code by @Mytherin in https://github.com/duckdb/duckdb/pull/21457
• Bump Postgres and MySQL by @staticlibs in https://github.com/duckdb/duckdb/pull/21433
• Shell: use Unicode entry point on Windows by @staticlibs in https://github.com/duckdb/duckdb/pull/21472
• Fix #21459: detect when read_duckdb is used to read a non-DuckDB file and throw a descriptive error by @Mytherin in https://github.com/duckdb/duckdb/pull/21460
• Fix #21367: Prevent throwing in WindowSelfJoinOptimizer when a logical plan cannot be copied, instead fallback to not running the optimization by @Mytherin in https://github.com/duckdb/duckdb/pull/21461
• bump delta && unity in prep for v1.5.1 by @benfleis in https://github.com/duckdb/duckdb/pull/21451
• Adjust v1.5.0 for z/OS by @DNikolaevAtRocket in https://github.com/duckdb/duckdb/pull/21325
• [vortex] Bump to 6ea8bd77fe8e6e814bde11b6981f934fa82ab961 by @carlopi in https://github.com/duckdb/duckdb/pull/21462
• Fix NULL dereference in TryGetValueFromStats (#21477) by @carlopi in https://github.com/duckdb/duckdb/pull/21479
• Bump spatial again by @Maxxen in https://github.com/duckdb/duckdb/pull/21485
• Bump vcpkg-duckdb-ports baseline by @yan-alex in https://github.com/duckdb/duckdb/pull/21493

Full Changelog: https://github.com/duckdb/duckdb/compare/v1.5.0...v1.5.1

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/pull/18982
• Fix field id uniqueness for alter database by @abramk in https://github.com/duckdb/duckdb/pull/18988
• Fix unused variable warnings by @mlafeldt in https://github.com/duckdb/duckdb/pull/18913
• Avoid adding a TupleDataChunkPart with only one row. by @lance5401 in https://github.com/duckdb/duckdb/pull/18904
• Tiny fix for ColumnDataAllocator::ColumnDataAllocator by @baolinhuang in https://github.com/duckdb/duckdb/pull/18990
• Fixes for ALTER DATABASE - use serialization framework, and fix stringification of identifiers by @Mytherin in https://github.com/duckdb/duckdb/pull/18994
• Expected errors 2053 by @hmeriann in https://github.com/duckdb/duckdb/pull/18960
• Fix union semantics in recursive CTEs by @cryoEncryp in https://github.com/duckdb/duckdb/pull/19017
• Multifile parquet_metadata and friends parallelism by @J-Meyers in https://github.com/duckdb/duckdb/pull/18854
• [Optimize] use StorageLock for CompressionFunction by @baolinhuang in https://github.com/duckdb/duckdb/pull/19028
• PEG grammar updates by @Dtenwolde in https://github.com/duckdb/duckdb/pull/19031
• Rework Compression Function registration to avoid grabbing locks by @Mytherin in https://github.com/duckdb/duckdb/pull/19045
• Merge v1.4 into main by @Mytherin in https://github.com/duckdb/duckdb/pull/19048
• [C-API] default to adding overload on conflict when registering functions by @Maxxen in https://github.com/duckdb/duckdb/pull/19036
• Destroy row groups in parallel by @Mytherin in https://github.com/duckdb/duckdb/pull/19053
• Switching core extension upload to dedicated credentials by @hannes in https://github.com/duckdb/duckdb/pull/19060
• CI: Increase stale bot timeout to 1 year by @szarnyasg in https://github.com/duckdb/duckdb/pull/19000
• Revert "set default value of MAIN_BRANCH_VERSIONING to false" by @c-herrewijn in https://github.com/duckdb/duckdb/pull/19057
• Fix extension load by @dentiny in https://github.com/duckdb/duckdb/pull/19079
• Change core extensions bucket name by @hannes in https://github.com/duckdb/duckdb/pull/19082
• Merge v1.4 into main by @Mytherin in https://github.com/duckdb/duckdb/pull/19098
• Allow directory override for extension build by @Mytherin in https://github.com/duckdb/duckdb/pull/19110
• Skip serialization of row_start in DataPointer when targeting latest storage by @Mytherin in https://github.com/duckdb/duckdb/pull/19111
• [C-API] Initial support for accessing file system by @Maxxen in https://github.com/duckdb/duckdb/pull/19086
• Rework UNION (ALL) operators (SetOperationNode/LogicalSetOperation/PhysicalUnion) to have multiple children by @Mytherin in https://github.com/duckdb/duckdb/pull/19109
• pushdown filter when doing cross or lateral join with unnest by @DinosL in https://github.com/duckdb/duckdb/pull/19085
• Fix unholy interaction between CREATE VIEW and CTE definitions by @kryonix in https://github.com/duckdb/duckdb/pull/19116
• Add support for read_duckdb - a function that allows reading / globbing DuckDB database files by @Mytherin in https://github.com/duckdb/duckdb/pull/19108
• Fix typo by @szarnyasg in https://github.com/duckdb/duckdb/pull/19130
• fix: check tree depth and flatten dep join for custom operator extension by @Wal8800 in https://github.com/duckdb/duckdb/pull/19094
• During optimistic writing, gather N row groups and write them at the same time column-at-a-time by @Mytherin in https://github.com/duckdb/duckdb/pull/19118
• Remove unused code by @szarnyasg in https://github.com/duckdb/duckdb/pull/19134
• Add support for late materialization and filter pushdown to read_duckdb by @Mytherin in https://github.com/duckdb/duckdb/pull/19145
• Move storage block prefetching to an option instead of baking in testing during ALTERNATIVE_VERIFY + add a test config for this option by @Mytherin in https://github.com/duckdb/duckdb/pull/19146
• Introduce parser_override_function_t by @Dtenwolde in https://github.com/duckdb/duckdb/pull/19126
• Perform deduplication based on join_keys when building ht by @tianjq16 in https://github.com/duckdb/duckdb/pull/19097
• Print help to stdout by @staticlibs in https://github.com/duckdb/duckdb/pull/19170
• Validate filesystem registration by @dentiny in https://github.com/duckdb/duckdb/pull/19168
• Fix missing replacement scan code for CTEs by @kryonix in https://github.com/duckdb/duckdb/pull/19159
• Correctly set row start in WAL replay by @Mytherin in https://github.com/duckdb/duckdb/pull/19192
• Use a PartialBlockManager per column, instead of sharing one over the entire row group by @Mytherin in https://github.com/duckdb/duckdb/pull/19194
• Internal #5380: AsOf Join Pipeline by @hawkfish in https://github.com/duckdb/duckdb/pull/19169
• Cross and lateral join pushdown with unnest or json - update by @DinosL in https://github.com/duckdb/duckdb/pull/19152
• Missing error messages for test cases by @hmeriann in https://github.com/duckdb/duckdb/pull/19129
• [Profiling] Move EXTRA_INFO into the metrics map by @maiadegraaf in https://github.com/duckdb/duckdb/pull/19124
• Common Subplan Elimination by @lnkuiper in https://github.com/duckdb/duckdb/pull/19080
• GEOMETRY Rework: Part 1 - Logical Type by @Maxxen in https://github.com/duckdb/duckdb/pull/19136
• [Parquet] Implement (unshredded) VARIANT support for COPY TO parquet by @Tishj in https://github.com/duckdb/duckdb/pull/19125
• Add more missing error messages to test cases by @hmeriann in https://github.com/duckdb/duckdb/pull/19210
• [CI] - Fix failing Extension updating test NightlyTests job by cleaning up some space on the runner by @hmeriann in https://github.com/duckdb/duckdb/pull/19214
• Inconsistent semicolon handling by @Dtenwolde in https://github.com/duckdb/duckdb/pull/19199
• Internal #5383: Range Join Sorting by @hawkfish in https://github.com/duckdb/duckdb/pull/19174
• [Profiling] Add QueryContext to more functions, for Reads by @maiadegraaf in https://github.com/duckdb/duckdb/pull/18726
• Merge v1.4-andium into main by @Maxxen in https://github.com/duckdb/duckdb/pull/19225
• [shell] Fix tilde parsing for .once statement by @dentiny in https://github.com/duckdb/duckdb/pull/19254
• Partially remove BoundQueryNode - have Bind directly emit a BoundStatement by @Mytherin in https://github.com/duckdb/duckdb/pull/19289
• Binder clean-up by @Mytherin in https://github.com/duckdb/duckdb/pull/19293
• test: add test for CREATE TABLE with my_schema.my_enum[] by @NickCrews in https://github.com/duckdb/duckdb/pull/19296
• Fix uncaught exception in test_empty_profiling_settings.test by @maiadegraaf in https://github.com/duckdb/duckdb/pull/19286
• GEOMETRY Rework: Part 2 - Statistics by @Maxxen in https://github.com/duckdb/duckdb/pull/19203
• Internal #5380: AsOf Sorting Conversion by @hawkfish in https://github.com/duckdb/duckdb/pull/19278
• Add option for opt-in to parser override by @Dtenwolde in https://github.com/duckdb/duckdb/pull/19181
• Remove BoundTableRef and make binding a TableRef directly return a BoundStatement by @Mytherin in https://github.com/duckdb/duckdb/pull/19294
• Rewrite Grouped Top-N Window Functions To Aggregations by @d-justen in https://github.com/duckdb/duckdb/pull/19280
• Perform optimistic reads while filling gaps in CachingFileSystem by @carlopi in https://github.com/duckdb/duckdb/pull/19122
• Issue #19027: AsOf Join Predicates by @hawkfish in https://github.com/duckdb/duckdb/pull/19316
• Enable experimental metadata re-use by default by @Mytherin in https://github.com/duckdb/duckdb/pull/19317
• Binder: BoundQueryNode cleanup by @Mytherin in https://github.com/duckdb/duckdb/pull/19322
• Remove old sort code by @lnkuiper in https://github.com/duckdb/duckdb/pull/19321
• [Parquet] Implement shredded VARIANT support for COPY TO parquet by @Tishj in https://github.com/duckdb/duckdb/pull/19219
• Merge andium into main by @Tishj in https://github.com/duckdb/duckdb/pull/19325
• [C API] Expose column count and type for table description by @taniabogatsch in https://github.com/duckdb/duckdb/pull/19334
• Relocate the python sqllogic code to the dedicated repository by @Tishj in https://github.com/duckdb/duckdb/pull/19340
• Binder: Rework the way set operations work so that we can use the standard binding flow by @Mytherin in https://github.com/duckdb/duckdb/pull/19342
• Rework CTE binding: remove CTENode, and bind CommonTableExpressionMap directly instead by @Mytherin in https://github.com/duckdb/duckdb/pull/19351
• Avoid keeping shared ptr to ClientContext in QueryContext by @Mytherin in https://github.com/duckdb/duckdb/pull/19353
• Internal #6190: AsOf Threading by @hawkfish in https://github.com/duckdb/duckdb/pull/19328
• [Indexes] Buffer Managed Indexes Part 4: Segment Handles for Base Leaf by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/19303
• Provide force assertion macros by @dentiny in https://github.com/duckdb/duckdb/pull/19212
• Parse result for PEG transformer by @Dtenwolde in https://github.com/duckdb/duckdb/pull/19229
• Allow * NOT SIMILAR TO 'pattern' by @Dtenwolde in https://github.com/duckdb/duckdb/pull/19232
• [C API] Improve documentation on list vectors by @taniabogatsch in https://github.com/duckdb/duckdb/pull/19349
• Make Binding CTEs lazy, and other CTE binding refactors by @Mytherin in https://github.com/duckdb/duckdb/pull/19372
• Internal #6210: IEJoin Threading by @hawkfish in https://github.com/duckdb/duckdb/pull/19361
• [CI] Move two test cases from duckdb-httpfs repo by @hmeriann in https://github.com/duckdb/duckdb/pull/19368
• [C API] Update misleading "use instead" by @taniabogatsch in https://github.com/duckdb/duckdb/pull/19371
• Enable -Wtype-limits warning and fix warnings by @hannes in https://github.com/duckdb/duckdb/pull/19382
• [Profiling] Add metrics for ATTACH / CHECKPOINT / WAL replay by @taniabogatsch in https://github.com/duckdb/duckdb/pull/19367
• Update issue template by @szarnyasg in https://github.com/duckdb/duckdb/pull/19384
• Not building imdb all the time by @hannes in https://github.com/duckdb/duckdb/pull/19388
• CSV Reader: make line reconstruction deal with buffer_pos == buffer_size by @Mytherin in https://github.com/duckdb/duckdb/pull/19390
• [Dev] variant_extract BindData copy fix by @Tishj in https://github.com/duckdb/duckdb/pull/19394
• [Dev] Add a VARIANT visitor class by @Tishj in https://github.com/duckdb/duckdb/pull/19387
• Switch RowVersionManager to using the FixedSizeAllocator by @Mytherin in https://github.com/duckdb/duckdb/pull/19392
• [Profiling][CAPI] Add appender profiling test by @maiadegraaf in https://github.com/duckdb/duckdb/pull/19383
• Use statement for PEG Parser transformer by @Dtenwolde in https://github.com/duckdb/duckdb/pull/19302
• old_transactions is no longer necessary by @Captain32 in https://github.com/duckdb/duckdb/pull/19381
• Add Null Support for TopNWindowElimination Rule by @d-justen in https://github.com/duckdb/duckdb/pull/19370
• Use const references in exceptions varargs by @maiadegraaf in https://github.com/duckdb/duckdb/pull/18723
• Merge v1.4-andium into main by @Mytherin in https://github.com/duckdb/duckdb/pull/19402
• [Variant] Implement comparison operation logic for Variant columns by @Tishj in https://github.com/duckdb/duckdb/pull/19337
• Implement std::allocator that uses ArenaAllocator by @lnkuiper in https://github.com/duckdb/duckdb/pull/19412
• [CI] Correct file path in test case by @hmeriann in https://github.com/duckdb/duckdb/pull/19429
• [C API] Patch C API query progress documentation by @taniabogatsch in https://github.com/duckdb/duckdb/pull/19430
• Fixes .dump command failing with ROLLBACK when dumping tables in non-default schemas. by @shivampr in https://github.com/duckdb/duckdb/pull/19363
• [C API] Extend documentation around header generation by @taniabogatsch in https://github.com/duckdb/duckdb/pull/19433
• Internal #6270: Fix small binary fallback values for arg_min/max_nulls_last by @d-justen in https://github.com/duckdb/duckdb/pull/19434
• Merge v1.4 into main by @Mytherin in https://github.com/duckdb/duckdb/pull/19438
• SET statement for PEG Transformer by @Dtenwolde in https://github.com/duckdb/duckdb/pull/19320
• Add DuckDB::String to operators by @maiadegraaf in https://github.com/duckdb/duckdb/pull/19423
• Make cached hashes thread-safe and emit dictionary vectors from Perfect Hash Join by @lnkuiper in https://github.com/duckdb/duckdb/pull/19332
• fix: make GetCachedHashes thread safe by @0ax1 in https://github.com/duckdb/duckdb/pull/19274
• [Profiling] Enable ATTACH / CHECKPOINT / WAL replay metrics by default by @maiadegraaf in https://github.com/duckdb/duckdb/pull/19436
• Update / simplify issue template by @szarnyasg in https://github.com/duckdb/duckdb/pull/19442
• Move FORCE_ASYNC_SINK_SOURCE from Nightly to Main by @carlopi in https://github.com/duckdb/duckdb/pull/19452
• Fix WITH ORDINALITY virtual columns by @niykko in https://github.com/duckdb/duckdb/pull/19315
• Internal #6196: AsOf Prefix Comparisons by @hawkfish in https://github.com/duckdb/duckdb/pull/19456
• Add safe queue and deque by @dentiny in https://github.com/duckdb/duckdb/pull/19273
• :gift_heart: duckdb now has its endoflife.date page :hourglass_flowing_sand: by @adriens in https://github.com/duckdb/duckdb/pull/19450
• Fix wording in README by @lnkuiper in https://github.com/duckdb/duckdb/pull/19462
• [C-API] Add support for defining config options (settings) by @Maxxen in https://github.com/duckdb/duckdb/pull/19473
• Internal #6196: AsOf Prefix Comparisons by @hawkfish in https://github.com/duckdb/duckdb/pull/19466
• Internal #6196: AsOf Prefix Comparisons by @hawkfish in https://github.com/duckdb/duckdb/pull/19484
• [TPCH] fix load.sql to produce valid test data by @hmeriann in https://github.com/duckdb/duckdb/pull/19441
• [minor] Add catalog type to exception by @dentiny in https://github.com/duckdb/duckdb/pull/19488
• GEOMETRY Rework: Part 3 - Filter pushdown by @Maxxen in https://github.com/duckdb/duckdb/pull/19439
• [minor] Address test compilation warnings by @dentiny in https://github.com/duckdb/duckdb/pull/19492
• Fix issue #17941: Cryptic error message when dropping a column part of a unique constraint. by @arjanssuri in https://github.com/duckdb/duckdb/pull/19465
• [Optimizer] Support constant order normalization by @doublefish5106 in https://github.com/duckdb/duckdb/pull/19494
• Use Late Materialization in TopNWindowElimination Optimizer by @d-justen in https://github.com/duckdb/duckdb/pull/19463
• Internal #6326: AsOf Join Copying by @hawkfish in https://github.com/duckdb/duckdb/pull/19505
• [swift] fix microseconds conversion to seconds by @kokluch in https://github.com/duckdb/duckdb/pull/19486
• Fix bug initializing std::vector for column names in ADBC API by @CurtHagenlocher in https://github.com/duckdb/duckdb/pull/19444
• Remove empty lines at the start of code blocks by @lnkuiper in https://github.com/duckdb/duckdb/pull/19519
• Merge v1.4 into main by @Mytherin in https://github.com/duckdb/duckdb/pull/19528
• Fix failing python replacement scan by @evertlammerts in https://github.com/duckdb/duckdb/pull/19509
• Adds parquet_full_metadata function by @J-Meyers in https://github.com/duckdb/duckdb/pull/19148
• [Profiling] Add WAL_REPLAY_ENTRY_COUNT and COMMIT_WRITE_WAL_LATENCY metrics by @maiadegraaf in https://github.com/duckdb/duckdb/pull/19524
• Convert CLI to use C++ API, and remove sqlite API wrappers by @Mytherin in https://github.com/duckdb/duckdb/pull/19536
• Adding release name for 1.5 by @hannes in https://github.com/duckdb/duckdb/pull/19540
• CLI: Generate ".help" menu from the list of commands, and add syntax highlighting to .help by @Mytherin in https://github.com/duckdb/duckdb/pull/19542
• CLI: Refactor command-line parameters into a struct similar to MetadataCommands, and add better errors + syntax highlighting by @Mytherin in https://github.com/duckdb/duckdb/pull/19544
• Delete Statement and expression associativity for PEG Transformer by @Dtenwolde in https://github.com/duckdb/duckdb/pull/19507
• Attach statement for PEG transformer by @Dtenwolde in https://github.com/duckdb/duckdb/pull/19460
• Augment Table API function via context stored in AsyncResult object by @carlopi in https://github.com/duckdb/duckdb/pull/19422
• Add COLUMNS() expansion support to DISTINCT ON by @shivampr in https://github.com/duckdb/duckdb/pull/19550
• Retain recursive unnest column names by @DinosL in https://github.com/duckdb/duckdb/pull/19310
• Adds struct variant to regexp_extract_all by @J-Meyers in https://github.com/duckdb/duckdb/pull/19078
• CLI: Make last query result queryable through the _ token by @Mytherin in https://github.com/duckdb/duckdb/pull/19553
• CLI: rework .import to use built-in readers by @Mytherin in https://github.com/duckdb/duckdb/pull/19563
• Count also time blocked waiting for the lock in BLOCKED_THREADS_TIME by @carlopi in https://github.com/duckdb/duckdb/pull/19547
• Change format_version to 2 when specify V2 for PARQUET_VERSION by @koron in https://github.com/duckdb/duckdb/pull/18855
• Fix: list_concat(NULL) returns NULL by @maiadegraaf in https://github.com/duckdb/duckdb/pull/19565
• CLI: More shell code refactoring, remove global variables and split commands into separate files by @Mytherin in https://github.com/duckdb/duckdb/pull/19568
• Consdier offset in topn optimizer by @ZENOTME in https://github.com/duckdb/duckdb/pull/19561
• Fix Issue #19487: array_to_string on empty list return NULL instead of empty string by @arjanssuri in https://github.com/duckdb/duckdb/pull/19548
• CLI: Add support for dynamic prompts by @Mytherin in https://github.com/duckdb/duckdb/pull/19579
• Custom Order Row Group Scans by @d-justen in https://github.com/duckdb/duckdb/pull/19537
• Added missing return code checks for ADBC test cases by @hannes in https://github.com/duckdb/duckdb/pull/19576
• CLI: Make startup-text display configurable using the .startup_text by @Mytherin in https://github.com/duckdb/duckdb/pull/19584
• CLI: Unify all highlighting color code, add support for extended (8-bit) colors and add .display_colors command by @Mytherin in https://github.com/duckdb/duckdb/pull/19587
• Replace deprecated header by @krlmlr in https://github.com/duckdb/duckdb/pull/19602
• const-safe: Add const handling for list_entry_t by @krlmlr in https://github.com/duckdb/duckdb/pull/19603
• Fix uninitialized physical_type in move constructor by @krlmlr in https://github.com/duckdb/duckdb/pull/19604
• Fix uninitialized variable in multi-file progress tracking by @krlmlr in https://github.com/duckdb/duckdb/pull/19597
• Fix uninitialized members in CachedFile constructor by @krlmlr in https://github.com/duckdb/duckdb/pull/19598
• Fix uninitialized members in HashJoinGlobalSourceState by @krlmlr in https://github.com/duckdb/duckdb/pull/19599
• [C API] Generate description, deprecated, and use_instead for function groups by @taniabogatsch in https://github.com/duckdb/duckdb/pull/19586
• Merge v1.4-andium into main by @carlopi in https://github.com/duckdb/duckdb/pull/19589
• CLI: Sort .display_colors by group / hue / luminosity by @Mytherin in https://github.com/duckdb/duckdb/pull/19610
• Use std::remove_cv for physical type id fetching by @dentiny in https://github.com/duckdb/duckdb/pull/19614
• [C-API] Initial support for defining COPY functions by @Maxxen in https://github.com/duckdb/duckdb/pull/19186
• Apply RemoveUnusedColumns below table in out functions by @geoffxy in https://github.com/duckdb/duckdb/pull/19474
• Fix uninitialized sorted_tuples member by @krlmlr in https://github.com/duckdb/duckdb/pull/19593
• Array comparison optimization by @EslamAhmed171 in https://github.com/duckdb/duckdb/pull/19591
• Python SQLLogicTest - show results in a consistent order by @DinosL in https://github.com/duckdb/duckdb/pull/19562
• Add missing description to copy CAPI by @lnkuiper in https://github.com/duckdb/duckdb/pull/19617
• Speed up Dictionary and DICT_FSST compression by replacing std::unordered_map with PrimitiveDictionary by @yan-alex in https://github.com/duckdb/duckdb/pull/19577
• CLI: Display auto-complete suggestions when tabbing through them by @Mytherin in https://github.com/duckdb/duckdb/pull/19626
• Allow Table function to opt-in to return arbitrary combinations of [0, output.size()] x [HAVE_MORE_OUTPUT, FINISHED] by @carlopi in https://github.com/duckdb/duckdb/pull/19566
• Add a Mermaid Flowchart transformer for EXPLAIN output by @tobilg in https://github.com/duckdb/duckdb/pull/19581
• Add recovery mode to ATTACH options and enable NO_WAL mode by @taniabogatsch in https://github.com/duckdb/duckdb/pull/19612
• feat: add --sql option to .open in the cli client by @hello-world-bfree in https://github.com/duckdb/duckdb/pull/19445
• [ART] Pretty Printer + Verify by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/19558
• Internal #6341: AsOf Parallelism by @hawkfish in https://github.com/duckdb/duckdb/pull/19605
• Add window functions to duckdb_functions by @Tishj in https://github.com/duckdb/duckdb/pull/19532
• CLI: Fix cursor rendering in multi-line editing mode by @Mytherin in https://github.com/duckdb/duckdb/pull/19649
• CLI: Eagerly open database also if it does not exist by @Mytherin in https://github.com/duckdb/duckdb/pull/19627
• CLI: Make the progress bar configurable by @Mytherin in https://github.com/duckdb/duckdb/pull/19650
• Encapsulate BaseScalarFunction properties by @Maxxen in https://github.com/duckdb/duckdb/pull/19632
• Buffer-managed query results by @lnkuiper in https://github.com/duckdb/duckdb/pull/19437
• [ART] Iterative Iterator by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/19521
• CI Fuzzer runtime error by @DinosL in https://github.com/duckdb/duckdb/pull/19630
• Guard printing for bignum by @krlmlr in https://github.com/duckdb/duckdb/pull/19600
• Don't truncate test names to 80 characters by @JelteF in https://github.com/duckdb/duckdb/pull/19642
• [Parquet] Emit VARIANT from Parquet VARIANT columns, instead of JSON by @Tishj in https://github.com/duckdb/duckdb/pull/18996
• CLI: Make Linenoise work on Windows by @Mytherin in https://github.com/duckdb/duckdb/pull/19659
• Issue #19499: HashedSort Sorting Memory by @hawkfish in https://github.com/duckdb/duckdb/pull/19664
• Fix incorrect partition calculation due to missing vector_type by @tianjq16 in https://github.com/duckdb/duckdb/pull/19638
• CLI - store action as just a char to avoid sanitizer complaints by @Mytherin in https://github.com/duckdb/duckdb/pull/19679
• Merge v1.4 into main by @Mytherin in https://github.com/duckdb/duckdb/pull/19670
• More arena_stl_allocator integration by @lnkuiper in https://github.com/duckdb/duckdb/pull/19677
• Fix z/OS-specific issues by @DNikolaevAtRocket in https://github.com/duckdb/duckdb/pull/19641
• CLI - Add paging support for output by @Mytherin in https://github.com/duckdb/duckdb/pull/19676
• GEOMETRY Rework: Part 4 - Fixup Parquet Extension + Add Arrow Support by @Maxxen in https://github.com/duckdb/duckdb/pull/19476
• SegmentTree: move next and index out of SegmentBase and into SegmentNode by @Mytherin in https://github.com/duckdb/duckdb/pull/19686
• Add Clear method to BaseAppender by @EtgarDev in https://github.com/duckdb/duckdb/pull/19623
• Handle edge case for date_trunc optimization by @rcurtin in https://github.com/duckdb/duckdb/pull/19628
• fix checkpointing on files that dont exist by @dioptre in https://github.com/duckdb/duckdb/pull/19344
• Fix: Correct typos in comments and error messages by @feichai0017 in https://github.com/duckdb/duckdb/pull/19257
• Fix compiler warnings on main by @lnkuiper in https://github.com/duckdb/duckdb/pull/19690
• Issue #19499: HashedSort Sorting Memory by @hawkfish in https://github.com/duckdb/duckdb/pull/19687
• Internal #6519: HashedSort Memory Footprint by @hawkfish in https://github.com/duckdb/duckdb/pull/19702
• Fix LENGTH(NULL) with GROUP BY NULL binding issue by @shivampr in https://github.com/duckdb/duckdb/pull/19269
• New EXTENSION_RELATION type by @krlmlr in https://github.com/duckdb/duckdb/pull/19596
• array intersect by @krleonid in https://github.com/duckdb/duckdb/pull/19667
• Internal #6341: AsOf Deadlock by @hawkfish in https://github.com/duckdb/duckdb/pull/19705
• Add options for how invalid utf-8 should be handled in decode() by @casperhart in https://github.com/duckdb/duckdb/pull/18168
• CommonSubplan improvements by @lnkuiper in https://github.com/duckdb/duckdb/pull/19710
• Fix #18653: remove unnecessary delim_join by @flashmouse in https://github.com/duckdb/duckdb/pull/19235
• Internal #6523: AsOf Exception Handling by @hawkfish in https://github.com/duckdb/duckdb/pull/19703
• CLI: Refactor BoxRenderer, add wrapping support for large values, and add pretty printing / highlighting for nested types, JSON and variant by @Mytherin in https://github.com/duckdb/duckdb/pull/19721
• Fix empty result pullup for ANTI joins by @feichai0017 in https://github.com/duckdb/duckdb/pull/19701
• search activer binders in table function binder during binding column… by @Damon07 in https://github.com/duckdb/duckdb/pull/14486
• Move formatting logic for tests and benchmarks into a standalone script by @adsharma in https://github.com/duckdb/duckdb/pull/17350
• Exclude Row Groups in Top-N Queries by @d-justen in https://github.com/duckdb/duckdb/pull/19655
• fix bug in generate_grammar script by @OrangieLou in https://github.com/duckdb/duckdb/pull/19751
• Internal #4490: DENSE_RANK Performance by @hawkfish in https://github.com/duckdb/duckdb/pull/19757
• Internal #6521: HashedSort Scan Lock by @hawkfish in https://github.com/duckdb/duckdb/pull/19758
• Issue #19647: Constant Window Allocators by @hawkfish in https://github.com/duckdb/duckdb/pull/19752
• BoxRenderer: Fix rendering of empty results by @Mytherin in https://github.com/duckdb/duckdb/pull/19746
• Bump ducklake main by @J-Meyers in https://github.com/duckdb/duckdb/pull/19756
• Fix initialization when all values are NULL in SMALLER_BINARY aggregation by @DinosL in https://github.com/duckdb/duckdb/pull/19755
• Clean up unused headers in parser/ and subfolders by @Schwarf in https://github.com/duckdb/duckdb/pull/18422
• Fix #17251: Eliminate duplicates after a set operation using set sema… by @tianjq16 in https://github.com/duckdb/duckdb/pull/17267
• Implement outer join elimination by @flashmouse in https://github.com/duckdb/duckdb/pull/18043
• [C-API] Add support for catalog entry lookup by @Maxxen in https://github.com/duckdb/duckdb/pull/19684
• Add Stats API to filesystem interfaces by @dentiny in https://github.com/duckdb/duckdb/pull/19743
• Add sleep scalar function by @krleonid in https://github.com/duckdb/duckdb/pull/19736
• Add flush memory threshold for appender to prevent OOM by @p1p1bear in https://github.com/duckdb/duckdb/pull/19007
• add statement debug and debug_skip by @samansmink in https://github.com/duckdb/duckdb/pull/18472
• Storage: Remove start from RowGroup, ColumnData and ColumnSegment, and rework the way that start is defined in the ColumnSegmentTree by @Mytherin in https://github.com/duckdb/duckdb/pull/19761
• Add Seek() to TupleDataCollection for IEJoin optimization by @EslamAhmed171 in https://github.com/duckdb/duckdb/pull/19753
• Fix TopN Pruning Test by @d-justen in https://github.com/duckdb/duckdb/pull/19768
• Support reading pipes with read_text by @lnkuiper in https://github.com/duckdb/duckdb/pull/19765
• Support TopN dynamic filter for NULLS FIRST by @feichai0017 in https://github.com/duckdb/duckdb/pull/19744
• fix(#18481): Avoid to overwrite secret_directory configuration by it default value by @quentingodeau in https://github.com/duckdb/duckdb/pull/19448
• Change back default strategy for debug_physical_table_scan_execution_strategy by @carlopi in https://github.com/duckdb/duckdb/pull/19778
• Fix major big-endian issues by @DNikolaevAtRocket in https://github.com/duckdb/duckdb/pull/19748
• Disable sleep() function if DuckDB isn't compiled with threads by @lnkuiper in https://github.com/duckdb/duckdb/pull/19783
• Remove unused parameter from arrow by @pdet in https://github.com/duckdb/duckdb/pull/19784
• Block Allocator by @lnkuiper in https://github.com/duckdb/duckdb/pull/19678
• Merge v1.4-andium into main by @Mytherin in https://github.com/duckdb/duckdb/pull/19771
• CLI: Add table metadata rendering, and use this rendering for .tables and DESCRIBE queries by @Mytherin in https://github.com/duckdb/duckdb/pull/19792
• CLI: Improve array rendering by no longer adding newlines after every array entry unless there are complex objects in the array by @Mytherin in https://github.com/duckdb/duckdb/pull/19795
• CLI: For .tables - group tables by database/schema, and render the database name and schema of the tables as a header above the tables by @Mytherin in https://github.com/duckdb/duckdb/pull/19798
• Skip test block_allocator_memory.test on 32bit platforms by @carlopi in https://github.com/duckdb/duckdb/pull/19794
• [ADBC] Fix bug in StatementGetParameterSchema when no params are set by @amoeba in https://github.com/duckdb/duckdb/pull/19790
• Specify shared deletion option on windows by @dentiny in https://github.com/duckdb/duckdb/pull/19782
• Fix flaky sleep test by @krleonid in https://github.com/duckdb/duckdb/pull/19803
• Internal #6541: Window ArenaAllocator Usage by @hawkfish in https://github.com/duckdb/duckdb/pull/19770
• CLI: Several auto-complete improvements, make auto-complete behave more like zsh by @Mytherin in https://github.com/duckdb/duckdb/pull/19805
• [Profiling] Split COMMIT_WRITE_WAL_LATENCY into COMMIT_LOCAL_STORAGE_LATENCY and WRITE_TO_WAL_LATENCY by @maiadegraaf in https://github.com/duckdb/duckdb/pull/19808
• Move GetData as GetDataInternal, and have GetData as wrapper by @carlopi in https://github.com/duckdb/duckdb/pull/19791
• [swift] fix compiler warnings for deprecated @_implementationOnly by @kokluch in https://github.com/duckdb/duckdb/pull/19800
• CLI: Silence auto-complete failures instead of exiting by @Mytherin in https://github.com/duckdb/duckdb/pull/19813
• Random small nits by @taniabogatsch in https://github.com/duckdb/duckdb/pull/19828
• Add test to exclusion list by @Maxxen in https://github.com/duckdb/duckdb/pull/19827
• Create statement for PEG Transformer by @Dtenwolde in https://github.com/duckdb/duckdb/pull/19807
• Add struct_keys method to StructVector by @EtgarDev in https://github.com/duckdb/duckdb/pull/19673
• [Dev] Disallow aggregates used in the TRY expression child by @Tishj in https://github.com/duckdb/duckdb/pull/16285
• CI Cleanup by @Mytherin in https://github.com/duckdb/duckdb/pull/19840
• Fix positional scan and restore task executor by @carlopi in https://github.com/duckdb/duckdb/pull/19825
• [CLI] fix escaping sequence for ctrl/alt arrow key shortcuts by @tobwen in https://github.com/duckdb/duckdb/pull/19261
• Enable macros in DuckLake by @pdet in https://github.com/duckdb/duckdb/pull/19836
• Make RowGroup::Checkpoint and ColumnData::Checkpoint generate a new RowGroup/ColumnData - instead of checkpointing them in-place by @Mytherin in https://github.com/duckdb/duckdb/pull/19843
• Fix incorrect results with NOT EXISTS and IS DISTINCT FROM operator (#19680) by @henry8128 in https://github.com/duckdb/duckdb/pull/19811
• #6429 Roaring Booleans by @yan-alex in https://github.com/duckdb/duckdb/pull/19785
• GEOMETRY Rework: Part 4 - Step 2 - Adjust WKB conversion functions by @Maxxen in https://github.com/duckdb/duckdb/pull/19848
• Internal #6607: IEJoin Task Locking by @hawkfish in https://github.com/duckdb/duckdb/pull/19852
• Add TOTAL_MEMORY_ALLOCATED profiling metric by @krleonid in https://github.com/duckdb/duckdb/pull/19834
• Delete unused block header size by @ccfelius in https://github.com/duckdb/duckdb/pull/19855
• [CAPI] Expose basic custom log storage to CAPI by @maiadegraaf in https://github.com/duckdb/duckdb/pull/19810
• Enable reads to run concurrently while another connection is checkpointing by @Mytherin in https://github.com/duckdb/duckdb/pull/19867
• CLI: Enable support for mouse clicks in Linenoise - pressing Ctrl+Q allows a single mouse-click to be consumed to change the cursor position by @Mytherin in https://github.com/duckdb/duckdb/pull/19869
• Add alias reference support (alias.<name>) by @EtgarDev in https://github.com/duckdb/duckdb/pull/19747
• [Compression] Fix an existing and a new bug in Roaring compression by @Tishj in https://github.com/duckdb/duckdb/pull/19878
• PEG Transformer template script by @Dtenwolde in https://github.com/duckdb/duckdb/pull/19812
• [Testing][Dev] Extend tests covered by the storage_compatibility test config by @Tishj in https://github.com/duckdb/duckdb/pull/19860
• [swift] decode boolean primitive type by @kokluch in https://github.com/duckdb/duckdb/pull/19890
• [Parquet] Implement automatic shredding for VARIANT columns in COPY TO parquet by @Tishj in https://github.com/duckdb/duckdb/pull/19336
• Offset Pruning for Pagination Queries by @d-justen in https://github.com/duckdb/duckdb/pull/19806
• Internal #6568: SortStrategy Refactoring by @hawkfish in https://github.com/duckdb/duckdb/pull/19814
• Refactor hash join filter scan helper by @feichai0017 in https://github.com/duckdb/duckdb/pull/19802
• [Optimizer] Fix cardinality estimates getting lost through struct_extract expressions by @Tishj in https://github.com/duckdb/duckdb/pull/19829
• [Dev] Fix assertion failure in AlterType by @Tishj in https://github.com/duckdb/duckdb/pull/19850
• Internal #6653: WindowExpression Construction by @hawkfish in https://github.com/duckdb/duckdb/pull/19885
• Fix nested sleep_ms calls and add tests by @krleonid in https://github.com/duckdb/duckdb/pull/19837
• fix: make row_start an optional_idx in PartitionStatistics by @rustyconover in https://github.com/duckdb/duckdb/pull/19903
• CLI: Refactor shell rendering code, move everything to ShellRenderer, and perform various fixes by @Mytherin in https://github.com/duckdb/duckdb/pull/19897
• [Storage] Implement storage for VARIANT columns by @Tishj in https://github.com/duckdb/duckdb/pull/19674
• Encapsulate scalar/aggregate function callbacks by @Maxxen in https://github.com/duckdb/duckdb/pull/19707
• Merge V1.4 -> Main by @pdet in https://github.com/duckdb/duckdb/pull/19876
• Checkpoint: prevent adding blocks to the free_list that are still being used by concurrent readers by @Mytherin in https://github.com/duckdb/duckdb/pull/19928
• Merge V1.4 -> Main by @pdet in https://github.com/duckdb/duckdb/pull/19935
• Avoid eagerly grabbing the checkpoint lock when performing inserts, instead grab a shared table lock by @Mytherin in https://github.com/duckdb/duckdb/pull/19937
• [Checkpoint] Fully rewrite stats on Checkpoint by @Tishj in https://github.com/duckdb/duckdb/pull/19932
• fix: update aggregate docs regarding combine, add guards around calling combine callback. by @rustyconover in https://github.com/duckdb/duckdb/pull/19938
• [Wal]ReplayDelete in batches instead of rows by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/19904
• CheckZonemapSegments: iterate on filters, then jump further by @carlopi in https://github.com/duckdb/duckdb/pull/19865
• Tweak Relation::Query() by @krlmlr in https://github.com/duckdb/duckdb/pull/19594
• More TASK_EXECUTOR opt-in by @carlopi in https://github.com/duckdb/duckdb/pull/19940
• [Stats] has_no_null is no longer initialized to true in BaseStatistics::CreateEmpty by @Tishj in https://github.com/duckdb/duckdb/pull/19948
• [Stats] Improve the VariantStats class to support merging and better visualization by @Tishj in https://github.com/duckdb/duckdb/pull/19950
• Handle empty table name on CREATE by @yan-alex in https://github.com/duckdb/duckdb/pull/19955
• Fix ColumnAliasBinder by @d-justen in https://github.com/duckdb/duckdb/pull/19956
• CLI: Add support for dark / light mode that is automatically detected by @Mytherin in https://github.com/duckdb/duckdb/pull/19985
• CLI: Change return value from -1 to false in TryGetBackgroundColor by @c8ef in https://github.com/duckdb/duckdb/pull/19992
• CLI: Fully unify result rendering, and fix automatic pager mode by @Mytherin in https://github.com/duckdb/duckdb/pull/19988
• Adding extension alias lookup in GetDatabaseType by @tomas-karnagel in https://github.com/duckdb/duckdb/pull/19980
• CLI: Various auto-complete fixes by @Mytherin in https://github.com/duckdb/duckdb/pull/19995
• ALP uncompressed mode by @yan-alex in https://github.com/duckdb/duckdb/pull/19902
• Disable block allocator test on non-64bit by @lnkuiper in https://github.com/duckdb/duckdb/pull/19999
• Add comments to cardinality estimator code by @Tmonster in https://github.com/duckdb/duckdb/pull/19973
• [fix] ClientBufferManager::Pin to also propagate context when available by @carlopi in https://github.com/duckdb/duckdb/pull/19986
• Sideways Information Passing for Joins using Bloom Filters by @gropaul in https://github.com/duckdb/duckdb/pull/19502
• Don't require icu unless extension is enabled by @dg0yt in https://github.com/duckdb/duckdb/pull/19963
• Add z/OS support for block allocator by @DNikolaevAtRocket in https://github.com/duckdb/duckdb/pull/19977
• Add a secondary extension directory for package managers by @xhochy in https://github.com/duckdb/duckdb/pull/17499
• #15867 - Make it possible to hide query in profiling output by setting query_name metric to false. by @ormandi in https://github.com/duckdb/duckdb/pull/15870
• Internal #6607: IEJoin Task Locking by @hawkfish in https://github.com/duckdb/duckdb/pull/20028
• Fix #19984: shouldn't use outer table distinct info to eliminate join by @flashmouse in https://github.com/duckdb/duckdb/pull/20023
• fix: allow table in/out functions to indicate if they support parallelism by @rustyconover in https://github.com/duckdb/duckdb/pull/19951
• Fix #20029: accept "\e\" as termination sequence, and add a timeout to TryGetBackgroundColor by @Mytherin in https://github.com/duckdb/duckdb/pull/20042
• Fix #20034: correctly move correlated columns for lazy CTEs by @Mytherin in https://github.com/duckdb/duckdb/pull/20038
• Bloom filter row group skipping by @lnkuiper in https://github.com/duckdb/duckdb/pull/20035
• CLI: Optimize and clean-up result rendering code by @Mytherin in https://github.com/duckdb/duckdb/pull/20021
• fix alter table rename / alter on temp table losing temporary flag by @diwu-sf in https://github.com/duckdb/duckdb/pull/20011
• Improve catalog error message for missing schemas by @krleonid in https://github.com/duckdb/duckdb/pull/19922
• feat(adbc): partial supporting ADBC 1.1.0 by @eitsupi in https://github.com/duckdb/duckdb/pull/19833
• [Profiling] Generate more metric code and add metric subgroups by @maiadegraaf in https://github.com/duckdb/duckdb/pull/19483
• Filesystem-compatible wrapper for CachingFileSystem by @dentiny in https://github.com/duckdb/duckdb/pull/19972
• #Fix 18158: Deliver child column info by @flashmouse in https://github.com/duckdb/duckdb/pull/18327
• Allow concurrent commits to happen while a checkpoint is running by @Mytherin in https://github.com/duckdb/duckdb/pull/20052
• CLI: Improve rendering of wide values, and improve auto-complete by @Mytherin in https://github.com/duckdb/duckdb/pull/20074
• Checkpoint: Allow vacuuming of rows for tables that have indexes if the vacuum does not change the rowids by @Mytherin in https://github.com/duckdb/duckdb/pull/20073
• Eagerly Execute Min/Max Aggregates on Statistics by @d-justen in https://github.com/duckdb/duckdb/pull/19906
• Late extension linking by @hannes in https://github.com/duckdb/duckdb/pull/19369
• ADBC: Set append data error in Ingest() by @kou in https://github.com/duckdb/duckdb/pull/19991
• Don't throw permission error during binder when LocalFileSystem is disabled by @JelteF in https://github.com/duckdb/duckdb/pull/20077
• Add struct_values function to return field values of STRUCT by @EtgarDev in https://github.com/duckdb/duckdb/pull/19968
• TupleDataCollection + MemoryTag fix by @lnkuiper in https://github.com/duckdb/duckdb/pull/20089
• Enable Parquet reader support for uniformly encrypted Parquet files written by Arrow C++ API by @ccfelius in https://github.com/duckdb/duckdb/pull/20046
• Fix source and bin dirs to duckdb's root by @evertlammerts in https://github.com/duckdb/duckdb/pull/20088
• Allow CTEs to emit NULL types by @Mytherin in https://github.com/duckdb/duckdb/pull/20097
• Change CLI highlighting colors and error message rendering by @Mytherin in https://github.com/duckdb/duckdb/pull/20099
• Roaring boolean FetchRow fix by @yan-alex in https://github.com/duckdb/duckdb/pull/20101
• Fix race condition in piecewise merge join by @lnkuiper in https://github.com/duckdb/duckdb/pull/20059
• Improve join filter pushdown for ON clause conditions by @EslamAhmed171 in https://github.com/duckdb/duckdb/pull/19888
• Merge V1.4 -> Main by @pdet in https://github.com/duckdb/duckdb/pull/20111
• Fix parsing of dollar quoted strings in various places by @JelteF in https://github.com/duckdb/duckdb/pull/20121
• Do not autocomplete within dollar-quoted strings by @JelteF in https://github.com/duckdb/duckdb/pull/20122
• Fix concurrent test failure by @Mytherin in https://github.com/duckdb/duckdb/pull/20129
• Fix over-eager constraint checking in the presence of primary keys/unique constraints by @Mytherin in https://github.com/duckdb/duckdb/pull/20119
• When shortening columns in the BoxRenderer, avoid applying the min col width twice by @Mytherin in https://github.com/duckdb/duckdb/pull/20126
• Unify column renaming behavior of CTEs with other places in the system by @kryonix in https://github.com/duckdb/duckdb/pull/20116
• Fix vector sizes CI by @lnkuiper in https://github.com/duckdb/duckdb/pull/20130
• [Logging] Add assertions for LogType type by @maiadegraaf in https://github.com/duckdb/duckdb/pull/20064
• [Profiling] Check that file type set by profiling_output matches output type by @maiadegraaf in https://github.com/duckdb/duckdb/pull/19946
• Add flag to use pre-built static library by @hannes in https://github.com/duckdb/duckdb/pull/20092
• Create Shell Log Storage to Print Warnings in CLI by @maiadegraaf in https://github.com/duckdb/duckdb/pull/19974
• [Doc] Add ccache into contributing doc build section by @dentiny in https://github.com/duckdb/duckdb/pull/20139
• Fix column lifetime for DISTINCT ON by @feichai0017 in https://github.com/duckdb/duckdb/pull/19786
• documentation for extension patch workflow by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/19905
• Art pretty printer options by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/20079
• feat: add OperatorOrder() to table functions to indicate ordering needs. by @rustyconover in https://github.com/duckdb/duckdb/pull/19954
• Internal #6777: IEJoin Unified L1/2 by @hawkfish in https://github.com/duckdb/duckdb/pull/20083
• fix: link error on linux with multiple definition of LogicalType::VARCHAR in shell_renderer.cpp by @rustyconover in https://github.com/duckdb/duckdb/pull/20096
• Remove pointer indirection in ExtensionAccess by @staticlibs in https://github.com/duckdb/duckdb/pull/19529
• [Dev] Fix failure on extension_entries.hpp on main by @Tishj in https://github.com/duckdb/duckdb/pull/20138
• [Dev] Fix concurrent test failure (followup) by @Tishj in https://github.com/duckdb/duckdb/pull/20140
• HashCSVStateMachineConfig to return hash_t by @carlopi in https://github.com/duckdb/duckdb/pull/20137
• Provide option disable cache validation by @dentiny in https://github.com/duckdb/duckdb/pull/19886
• Parallel TupleDataCollection destructor by @lnkuiper in https://github.com/duckdb/duckdb/pull/20159
• Internal #6778: IEJoin Parallel L1/L2 by @hawkfish in https://github.com/duckdb/duckdb/pull/20152
• Allow concurrent insertions into tables with indexes while checkpointing by @Mytherin in https://github.com/duckdb/duckdb/pull/20160
• Revert linux toolchain downgrade by @hannes in https://github.com/duckdb/duckdb/pull/20170
• Do not exit shell on Ctrl+C by @staticlibs in https://github.com/duckdb/duckdb/pull/20155
• CLI: Several rendering fixes / improvements by @Mytherin in https://github.com/duckdb/duckdb/pull/20175
• fix: remove extra space in GetName() for PhysicalTableScan in profiler output by @rustyconover in https://github.com/duckdb/duckdb/pull/20179
• Internal #6779: 64-Bit Range Joins by @hawkfish in https://github.com/duckdb/duckdb/pull/20176
• More CommonSubplanOptimizer improvements by @lnkuiper in https://github.com/duckdb/duckdb/pull/20168
• Profiling: Fix rows_scanned by @d-justen in https://github.com/duckdb/duckdb/pull/20161
• [Optimizer] Clean up the cross-over point from ColumnIndex -> StorageIndex by @Tishj in https://github.com/duckdb/duckdb/pull/20087
• Issue #19629: DATE_TRUNC Return Type by @hawkfish in https://github.com/duckdb/duckdb/pull/20120
• Move to macos-latest for newer compiler by @hannes in https://github.com/duckdb/duckdb/pull/20169
• [minor] Avoid divide by 0 for json progress report by @dentiny in https://github.com/duckdb/duckdb/pull/20196
• Allow Late Materialization for Parquet in TopNWindowElimination by @d-justen in https://github.com/duckdb/duckdb/pull/20066
• Link MSVC runtime library statically by @staticlibs in https://github.com/duckdb/duckdb/pull/19415
• fix ci run - 'no space left on device' by @c-herrewijn in https://github.com/duckdb/duckdb/pull/20203
• fix: simplify logic by removing empty else branch by @darion-yaphet in https://github.com/duckdb/duckdb/pull/20184
• fix: simplify platform detection in CMakeLists.txt by @darion-yaphet in https://github.com/duckdb/duckdb/pull/20183
• Add days_in_month internal macro for retrieving number of days in a month by @ArNine in https://github.com/duckdb/duckdb/pull/20180
• Fix try cast for variant to incompatible struct types by @wmTJc9IK0Q in https://github.com/duckdb/duckdb/pull/20211
• fix: add schema and catalog to table scan explain output by @rustyconover in https://github.com/duckdb/duckdb/pull/20181
• feat: add filenames to MultiFileDynamicToString by @rustyconover in https://github.com/duckdb/duckdb/pull/20182
• [C-API] Add support for scalar function local states by @Maxxen in https://github.com/duckdb/duckdb/pull/20109
• CLI: Add .last to re-render the last query result, and make several (performance) improvements to .mode duckbox by @Mytherin in https://github.com/duckdb/duckdb/pull/20223
• Throw exception if there is ARTKey mismatch by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/20225
• Fix Windows shell input: correct variable buffering and character order by @EslamAhmed171 in https://github.com/duckdb/duckdb/pull/20217
• [minor] Address compilation warnings by @dentiny in https://github.com/duckdb/duckdb/pull/20213
• Refactor PhysicalCreateIndex and introduce index build abstraction by @ccfelius in https://github.com/duckdb/duckdb/pull/20158
• Refactor PhysicalCreateIndex and introduce index build abstraction by @Maxxen in https://github.com/duckdb/duckdb/pull/19461
• Internal #6837: Streaming IGNORE NULLS by @hawkfish in https://github.com/duckdb/duckdb/pull/20226
• [Optimizer] Push down struct_extract expression to the storage. by @Tishj in https://github.com/duckdb/duckdb/pull/20063
• Friendly SWITCH case by @Dtenwolde in https://github.com/duckdb/duckdb/pull/20001
• Parallel SortedRunMerger destructor by @lnkuiper in https://github.com/duckdb/duckdb/pull/20200
• Internal #6462: Implement AGO Macro by @hawkfish in https://github.com/duckdb/duckdb/pull/20228
• Do not call UnregisterBlock from destructor by @staticlibs in https://github.com/duckdb/duckdb/pull/20242
• [minor] Address more compile warnings by @dentiny in https://github.com/duckdb/duckdb/pull/20232
• Re-enable aws tests by @Tmonster in https://github.com/duckdb/duckdb/pull/20249
• Fix wrong error message when add primary key to a view(#20239) by @ArNine in https://github.com/duckdb/duckdb/pull/20253
• Fix last parallel destructor race condition (hopefully) by @lnkuiper in https://github.com/duckdb/duckdb/pull/20251
• [Optimizer] Pushdown a CAST expression on top of a struct_extract by @Tishj in https://github.com/duckdb/duckdb/pull/20250
• [ART] Prefix handles by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/19658
• Fix: CHECK constraint internal error on UPDATE with missing columns (#20199) by @AestheticAkhmad in https://github.com/duckdb/duckdb/pull/20243
• Internal #6462: Implement AGO Macro by @hawkfish in https://github.com/duckdb/duckdb/pull/20257
• feat: preserve ATTACH options and return via duckdb_databases() by @rustyconover in https://github.com/duckdb/duckdb/pull/20186
• support reading parquet files with empty groups by @achille-roussel in https://github.com/duckdb/duckdb/pull/20135
• Move checkpointing outside of the attached database destructor by @taniabogatsch in https://github.com/duckdb/duckdb/pull/19930
• Issue #20076: Implement CountWindowElimination Logic by @hawkfish in https://github.com/duckdb/duckdb/pull/20273
• Minor python fixes by @c-herrewijn in https://github.com/duckdb/duckdb/pull/20269
• Fix concat(null) error by @d-justen in https://github.com/duckdb/duckdb/pull/20266
• Big-endian patches (FSST, arrow, types, md5) by @DNikolaevAtRocket in https://github.com/duckdb/duckdb/pull/20237
• Merge v1.4-andium into main by @carlopi in https://github.com/duckdb/duckdb/pull/20231
• Allow concurrent deletes while checkpointing by @Mytherin in https://github.com/duckdb/duckdb/pull/20286
• Correctly handle default expressions in WAL when doing ALTER TABLE ... ADD COLUMN ... DEFAULT ... by @yan-alex in https://github.com/duckdb/duckdb/pull/20224
• [Fix] Use the current schema and catalog during data creation for TPCH and TPCDS by @taniabogatsch in https://github.com/duckdb/duckdb/pull/20290
• peg grammar: start rule first by @jraymakers in https://github.com/duckdb/duckdb/pull/20275
• return_stats for boolean and numeric (128 bits) during copy by @aykut-bozkurt in https://github.com/duckdb/duckdb/pull/20222
• Fixes raised by cppcheck by @carlopi in https://github.com/duckdb/duckdb/pull/20323
• Fixup QueryProfiler::GetBytesRead and Written by @carlopi in https://github.com/duckdb/duckdb/pull/20318
• Internal #6974: Window Self-Join Files by @hawkfish in https://github.com/duckdb/duckdb/pull/20317
• Internal #6999: Window TopN Comparisons by @hawkfish in https://github.com/duckdb/duckdb/pull/20316
• Internal #6943: IEJoin Code Cleanup by @hawkfish in https://github.com/duckdb/duckdb/pull/20315
• Use eager min/max aggregation on parquet statistics by @d-justen in https://github.com/duckdb/duckdb/pull/20301
• c-api: adding out_file against NULL check by @ProjectMutilation in https://github.com/duckdb/duckdb/pull/20303
• Apply LRU cache to parquet metadata by @dentiny in https://github.com/duckdb/duckdb/pull/20157
• [Profiling] Add duckdb_profiling_settings() macro by @maiadegraaf in https://github.com/duckdb/duckdb/pull/20234
• Fix some compiler warnings on apple clang 17 by @hannes in https://github.com/duckdb/duckdb/pull/20337
• feat(adbc): support the uri option of ADBC 1.1.0 by @eitsupi in https://github.com/duckdb/duckdb/pull/20312
• feat(adbc): support ADBC_INFO_DRIVER_ADBC_VERSION (new in ADBC 1.1.0) by @eitsupi in https://github.com/duckdb/duckdb/pull/20344
• GEOMETRY Rework: Part 5 - Coordinate Reference System Support by @Maxxen in https://github.com/duckdb/duckdb/pull/20143
• Remove two unnecessary test exclusions by @yan-alex in https://github.com/duckdb/duckdb/pull/20347
• Preserve uppercase chars in DB filename on Windows by @staticlibs in https://github.com/duckdb/duckdb/pull/20298
• Eager aggregate support filter by @flashmouse in https://github.com/duckdb/duckdb/pull/20198
• [Profiling] Add enable_profiling() Table Function by @maiadegraaf in https://github.com/duckdb/duckdb/pull/20151
• Fix: Potential Unexpected Result when Using TRY Expression #20006 by @AestheticAkhmad in https://github.com/duckdb/duckdb/pull/20238
• Fix #20308: Added collation binding to the join conditions by @gemy26 in https://github.com/duckdb/duckdb/pull/20349
• Pick up stale PR 19271 by @lnkuiper in https://github.com/duckdb/duckdb/pull/20359
• Support reading FIXED_LEN_BYTE_ARRAY fields with DELTA_BYTE_ARRAY encoding by @arouel in https://github.com/duckdb/duckdb/pull/20270
• Parquet: Populate the column_orders field and expose it in parquet_file_metadata by @lasanaka-jumptrading in https://github.com/duckdb/duckdb/pull/20241
• Add RemoveFiles to FileSystem by @utay in https://github.com/duckdb/duckdb/pull/20333
• Perform cleanup when COPY function throws an error by @yan-alex in https://github.com/duckdb/duckdb/pull/20345
• Pick up stale PR 19268 by @lnkuiper in https://github.com/duckdb/duckdb/pull/20358
• CachingOperator: handle also ORDERED, and consider swapping chunks by @carlopi in https://github.com/duckdb/duckdb/pull/20259
• fix binder: handle errors with over in where inside subquery by @Pranav2612000 in https://github.com/duckdb/duckdb/pull/20310
• Add interruption check to optimizer execution by @EtgarDev in https://github.com/duckdb/duckdb/pull/20377
• Out of core tests by @lnkuiper in https://github.com/duckdb/duckdb/pull/20383
• Use forward-compatible std::shuffle by @philippmd in https://github.com/duckdb/duckdb/pull/20395
• fix compilation with FORCE_QUERY_LOG=1 by @zhanglei1949 in https://github.com/duckdb/duckdb/pull/20387
• [minor] Fix a few compilation warnings by @dentiny in https://github.com/duckdb/duckdb/pull/20385
• Add parse_formatted_bytes function to parse human-readable byte size by @EtgarDev in https://github.com/duckdb/duckdb/pull/20107
• Fix issue #20187: Fix PIVOT aggregate mismatch for ranges >=21 by @gemy26 in https://github.com/duckdb/duckdb/pull/20272
• Fix caching filesystem CanSeek by @dentiny in https://github.com/duckdb/duckdb/pull/20330
• Improve format script compatibility on Windows by @xuboying in https://github.com/duckdb/duckdb/pull/20398
• Add way to skip version checks in scripts/format.py by @carlopi in https://github.com/duckdb/duckdb/pull/20388
• Fix function chain in qualify(#20233) by @ArNine in https://github.com/duckdb/duckdb/pull/20262
• Fix concat(null) is null return false, it should be true(issue: #20306) by @ArNine in https://github.com/duckdb/duckdb/pull/20320
• NightlyTests fixes by @lnkuiper in https://github.com/duckdb/duckdb/pull/20408
• Storage cleanup: remove unused headers and fix transitive includes by @Schwarf in https://github.com/duckdb/duckdb/pull/20407
• Avoid frequent checkpoints triggered by optimistic insertions by @Captain32 in https://github.com/duckdb/duckdb/pull/20336
• No catalog found Nightly test fix by @ccfelius in https://github.com/duckdb/duckdb/pull/20409
• TIME_NS Support + Arrow by @pdet in https://github.com/duckdb/duckdb/pull/20361
• feat(adbc): support the experimental adbc.ingest.target_catalog option and improve ingest name resolution by @eitsupi in https://github.com/duckdb/duckdb/pull/20369
• Fix file opener propagation by @dentiny in https://github.com/duckdb/duckdb/pull/20414
• Cleanup RowGroup Scan code, and make BoundIndex::Delete throw an error if the rows are not present in the index by @Mytherin in https://github.com/duckdb/duckdb/pull/20430
• [Optimizer] Support NOT elimination by @doublefish5106 in https://github.com/duckdb/duckdb/pull/20394
• JSON Reader: exit scan loop if we have found an error that we can't yet throw by @Mytherin in https://github.com/duckdb/duckdb/pull/20434
• Merge V1.4 -> Main by @pdet in https://github.com/duckdb/duckdb/pull/20350
• Internal #6975: Window Inner Self-Join by @hawkfish in https://github.com/duckdb/duckdb/pull/20459
• Issue #20413: ASOF Arbitrary Predicates by @hawkfish in https://github.com/duckdb/duckdb/pull/20456
• [C API] Expose safe string assign function by @taniabogatsch in https://github.com/duckdb/duckdb/pull/20467
• Internal #6976: Window Self-Join Predicate by @hawkfish in https://github.com/duckdb/duckdb/pull/20473
• CMake: export also duckdb_generated_extension_loader by @carlopi in https://github.com/duckdb/duckdb/pull/20449
• Chore: merge back main into v1.5-variegata by @carlopi in https://github.com/duckdb/duckdb/pull/20469
• add_third_party(skiplist) into top level CMake by @carlopi in https://github.com/duckdb/duckdb/pull/20494
• Add SHOW schemas by @c-herrewijn in https://github.com/duckdb/duckdb/pull/20492
• [SQLLogicTest] Add the CONTINUE statement by @Tishj in https://github.com/duckdb/duckdb/pull/20489
• Remove fs limitation: OVERWRITE is not supported for remote file systems by @carlopi in https://github.com/duckdb/duckdb/pull/20487
• [Encryption] Adding random IV and tag for canary encryption by @ccfelius in https://github.com/duckdb/duckdb/pull/20208
• [Optimizer] Push down variant_extract + cast into the storage layer by @Tishj in https://github.com/duckdb/duckdb/pull/20268
• Internal #6977: Window Self-Join Aggregate by @hawkfish in https://github.com/duckdb/duckdb/pull/20497

Full Changelog: https://github.com/duckdb/duckdb/compare/v1.4.4...v1.5.0

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 https://github.com/duckdb/duckdb/pull/20153
• Fix minio nightly tests by @c-herrewijn in https://github.com/duckdb/duckdb/pull/20132
• Fix use-after-free in mode aggregate Combine function by @victor-ab in https://github.com/duckdb/duckdb/pull/20146
• Only pushdown varchar if the arrow type is not a string view by @evertlammerts in https://github.com/duckdb/duckdb/pull/20165
• Quote filters in adbc_get_objects by @evertlammerts in https://github.com/duckdb/duckdb/pull/20172
• Issue #20156: Streaming Window Unions by @hawkfish in https://github.com/duckdb/duckdb/pull/20191
• MergeInto: correctly clean-up buffer and handle non trivial GetData by @carlopi in https://github.com/duckdb/duckdb/pull/20163
• Fix extentension-ci-tools to latest release version in the v1.4-andium branch by @carlopi in https://github.com/duckdb/duckdb/pull/20227
• [Chore] Clean up CI nightly run to prevent time outs by @taniabogatsch in https://github.com/duckdb/duckdb/pull/20150
• Bump Julia to v1.4.3 by @maiadegraaf in https://github.com/duckdb/duckdb/pull/20248
• Internal #6881: 2025c Time Zones by @hawkfish in https://github.com/duckdb/duckdb/pull/20258
• Split statements by semicolon by @Dtenwolde in https://github.com/duckdb/duckdb/pull/20174
• [chore] Remove numeric_cast.hpp import and other tidy stuff by @taniabogatsch in https://github.com/duckdb/duckdb/pull/20278
• [chore] Reduce latency of VARCHAR index creation test by @taniabogatsch in https://github.com/duckdb/duckdb/pull/20277
• Reuse correct table-level metadata during checkpoints by @ywelsch in https://github.com/duckdb/duckdb/pull/20267
• Fix view resolution not being stable if the referenced table lives in a different schema by @Tishj in https://github.com/duckdb/duckdb/pull/20260
• ConstantOrNullFunction input validity mask overwrite bugfix by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/20283
• dbgen: use TaskExecutor framework by @Mytherin in https://github.com/duckdb/duckdb/pull/20284
• fix(adbc): return error when setting an empty sql query by @gishor in https://github.com/duckdb/duckdb/pull/20071
• Bump iceberg, and add wasm platforms! by @carlopi in https://github.com/duckdb/duckdb/pull/20205
• _extension_distribution: Pin to v1.4-andium branch of extension-ci-tools by @carlopi in https://github.com/duckdb/duckdb/pull/20294
• Optimize prepared statement parameter lookups by @EtgarDev in https://github.com/duckdb/duckdb/pull/20252
• Update VectorType in ComputePartitionIndices by @lnkuiper in https://github.com/duckdb/duckdb/pull/20343
• Add some defensive programming in RadixPartitionedHashTable::Combine and RadixPartitionedHashTable::Finalize by @lnkuiper in https://github.com/duckdb/duckdb/pull/20342
• Increase reserved size for paths in SetPathsInternal by @Flogex in https://github.com/duckdb/duckdb/pull/20340
• Use UTF-16 console output in Windows shell (1.4) by @staticlibs in https://github.com/duckdb/duckdb/pull/20339
• Force repartitioning in RadixPartitionedHashTable::Combine by @lnkuiper in https://github.com/duckdb/duckdb/pull/20357
• Fixup comparison to wrong iterator on abdc's driver by @carlopi in https://github.com/duckdb/duckdb/pull/20360
• [chore] dsdgen generation signed integer overflow fix by @taniabogatsch in https://github.com/duckdb/duckdb/pull/20279
• Give preference do variables set in config by @pdet in https://github.com/duckdb/duckdb/pull/20396
• Add QueryContext also to Write(void *buffer, idx_t nr_bytes), so that BytesWritten are updated also there by @carlopi in https://github.com/duckdb/duckdb/pull/20393
• Fix Issue #20233: fix function chain in qualify by @ArNine in https://github.com/duckdb/duckdb/pull/20302
• Backport client data cleanup by @taniabogatsch in https://github.com/duckdb/duckdb/pull/20403
• Add v1.4.4 to Storage Version by @maiadegraaf in https://github.com/duckdb/duckdb/pull/20404
• Parquet Reader: Ignore invalid UTF8 in string stats, instead of throwing an error by @Mytherin in https://github.com/duckdb/duckdb/pull/20405
• Don't add a semicolon to final query when splitting statements by @Dtenwolde in https://github.com/duckdb/duckdb/pull/20401
• Fixup BRANCHES_TO_BE_CACHED, vars are not available on PRs, so env it is by @carlopi in https://github.com/duckdb/duckdb/pull/20411
• [Fix] Defensive infinite loop guard and UTF-8 check in C API by @taniabogatsch in https://github.com/duckdb/duckdb/pull/20348
• Add ducklake, httpfs and iceberg tests so they are run in CI by @carlopi in https://github.com/duckdb/duckdb/pull/20319
• [Stats] date_trunc stat propagation fix by @Tishj in https://github.com/duckdb/duckdb/pull/20421
• Refactor allowed path sanitize by @hannes in https://github.com/duckdb/duckdb/pull/20346
• Issue #20413: ASOF SEMI/ANTI Bindings by @hawkfish in https://github.com/duckdb/duckdb/pull/20433
• Fix #20410: fix for RIGHT SEMI/ANTI - cannot fully label chain as found if there are non-equality predicates present in the join condition by @Mytherin in https://github.com/duckdb/duckdb/pull/20435
• [Fix] Misaligned size in ART prefix count by @taniabogatsch in https://github.com/duckdb/duckdb/pull/20455
• Wrap ccache in own action by @carlopi in https://github.com/duckdb/duckdb/pull/20466
• [Chore] Add ORDER BY to AS OF test by @taniabogatsch in https://github.com/duckdb/duckdb/pull/20465
• Fix segfault in hive partitioning with NULL values by @Schwarf in https://github.com/duckdb/duckdb/pull/20468
• Nightly test encryption fixes by @ccfelius in https://github.com/duckdb/duckdb/pull/20461
• [C API] Fix error data creation by @taniabogatsch in https://github.com/duckdb/duckdb/pull/20451
• Skip concurrent_encrypted_attach due to race in autoloading httpfs by @carlopi in https://github.com/duckdb/duckdb/pull/20471
• CI fixup: Comparisons needs to be done via strings (since input via workflow_call is a string) by @carlopi in https://github.com/duckdb/duckdb/pull/20464
• Add unity_catalog to extensions built by duckdb/duckdb by @carlopi in https://github.com/duckdb/duckdb/pull/20445
• Invert the setup of ccache and cleanup_runner by @carlopi in https://github.com/duckdb/duckdb/pull/20429
• bump spatial for andium by @Maxxen in https://github.com/duckdb/duckdb/pull/20479
• Reclaim disk space on MacOS runners by @lnkuiper in https://github.com/duckdb/duckdb/pull/20493
• Adding secure clear functions by @ccfelius in https://github.com/duckdb/duckdb/pull/20285
• rewrite unaligned scan by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/20474
• Issue #20470: TIMESTAMPTZ to DATE by @hawkfish in https://github.com/duckdb/duckdb/pull/20498
• Reset cached dictionaries in TRY expression by @Maxxen in https://github.com/duckdb/duckdb/pull/20452
• [Copy] Fix #20324 partition_by option binding by @Tishj in https://github.com/duckdb/duckdb/pull/20509
• Bump multiple extensions by @maiadegraaf in https://github.com/duckdb/duckdb/pull/20504
• update azure ref for v1.4-andium by @benfleis in https://github.com/duckdb/duckdb/pull/20506
• [Fix] Directly retrieve the logical column index during MERGE INTO binding by @taniabogatsch in https://github.com/duckdb/duckdb/pull/20503
• Sanitize pragmas by @samansmink in https://github.com/duckdb/duckdb/pull/20514
• Bump httpfs, ducklake and postgres by @carlopi in https://github.com/duckdb/duckdb/pull/20518
• Revert vortex bump for v1.4.4 by @taniabogatsch in https://github.com/duckdb/duckdb/pull/20527
• Bump VSS by @taniabogatsch in https://github.com/duckdb/duckdb/pull/20542
• Bump Excel by @maiadegraaf in https://github.com/duckdb/duckdb/pull/20540
• Fix Issue #20233: Fix function chain in having and merge to v1.4 by @ArNine in https://github.com/duckdb/duckdb/pull/20532
• bump iceberg by @Tmonster in https://github.com/duckdb/duckdb/pull/20549
• Bump Iceberg v1.4 by @Tmonster in https://github.com/duckdb/duckdb/pull/20604
• Fix KeyValueSecretReader init by @NiclasHaderer in https://github.com/duckdb/duckdb/pull/20620
• Fail fast extensions by @carlopi in https://github.com/duckdb/duckdb/pull/20605

New Contributors

• @victor-ab made their first contribution in https://github.com/duckdb/duckdb/pull/20146
• @gishor made their first contribution in https://github.com/duckdb/duckdb/pull/20071

Full Changelog: https://github.com/duckdb/duckdb/compare/v1.4.3...v1.4.4

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/duckdb/pull/19699
• chore: bump vortex to 0.56.0 by @0ax1 in https://github.com/duckdb/duckdb/pull/19815
• PositionalScan: handle also HAVE_MORE_OUTPUT + empty chunk via iteration by @carlopi in https://github.com/duckdb/duckdb/pull/19824
• AttachDatabase: first set whether file is remote, then do the rest by @carlopi in https://github.com/duckdb/duckdb/pull/19826
• Add CacheBehavior::AUTOMATIC to DBInstanceCache that automatically does the right thing™ by @Mytherin in https://github.com/duckdb/duckdb/pull/19841
• Reuse metadata even in the presence of deletes by @ywelsch in https://github.com/duckdb/duckdb/pull/19823
• DuckIndexScanState::TableScanFunc, split into 2 explicit phases by @carlopi in https://github.com/duckdb/duckdb/pull/19838
• Bump httpfs and iceberg by @carlopi in https://github.com/duckdb/duckdb/pull/19859
• Keep cte_root alive while binding materialized CTEs in MERGE INTO children by @Mytherin in https://github.com/duckdb/duckdb/pull/19863
• CI Cleanup (#19840) by @yan-alex in https://github.com/duckdb/duckdb/pull/19857
• Fix #19517: preserve relation name for table-qualified star LIKE expression by @henry8128 in https://github.com/duckdb/duckdb/pull/19887
• avoid underflow/"inf" loop while reporting unittest summary (backport… by @benfleis in https://github.com/duckdb/duckdb/pull/19900
• Fixes incorrect handing of APPROX_QUANTILE TIME by @Damon07 in https://github.com/duckdb/duckdb/pull/19891
• Add v1.4.3 to Storage Version by @maiadegraaf in https://github.com/duckdb/duckdb/pull/19907
• clean up tmp files while building extensions by @c-herrewijn in https://github.com/duckdb/duckdb/pull/19908
• Bump: ducklake, mysql_scanner by @maiadegraaf in https://github.com/duckdb/duckdb/pull/19910
• remove large limit optimization whenever there is a filter by @guillesd in https://github.com/duckdb/duckdb/pull/19911
• free disk space in Upload Extensions job by @c-herrewijn in https://github.com/duckdb/duckdb/pull/19912
• [Compression] Prevent overriding COMPRESSION_EMPTY with COMPRESSION_CONSTANT by @Tishj in https://github.com/duckdb/duckdb/pull/19913
• Make make tidy-check-diff compare against base branch, instead of always comparing against origin/main by @Mytherin in https://github.com/duckdb/duckdb/pull/19917
• More testing for appender and attach-detach by @taniabogatsch in https://github.com/duckdb/duckdb/pull/19708
• Script to release a extension manually by @samansmink in https://github.com/duckdb/duckdb/pull/19881
• Assert that result types match with column data collection when fetching data by @pdet in https://github.com/duckdb/duckdb/pull/19750
• No longer auto-enable profiling on DEBUG mode by @maiadegraaf in https://github.com/duckdb/duckdb/pull/19931
• Fix optimizer incorrectly remove ORDER BY clause from aggregates by @tianjq16 in https://github.com/duckdb/duckdb/pull/19925
• Backport revert append fixes by @Mytherin in https://github.com/duckdb/duckdb/pull/19941
• Bump: spatial by @Maxxen in https://github.com/duckdb/duckdb/pull/19943
• Issue #19916: WASM Time Zones by @hawkfish in https://github.com/duckdb/duckdb/pull/19918
• Fix correlated column binding in ConstantBinder by @d-justen in https://github.com/duckdb/duckdb/pull/19945
• [chore] Increase slow threshold by @taniabogatsch in https://github.com/duckdb/duckdb/pull/19965
• [Parquet] Fix prepared copy option parameter by @Tishj in https://github.com/duckdb/duckdb/pull/19966
• [TestConfig] Fix verify_fetch_row config, reduce duplication in skip_tests by @Tishj in https://github.com/duckdb/duckdb/pull/19967
• remove sha from artifacts by @c-herrewijn in https://github.com/duckdb/duckdb/pull/19957
• Unbound index binding with context by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/19953
• [Fix] Bug in FetchRow after update on indexed table with dict_fsst compression by @taniabogatsch in https://github.com/duckdb/duckdb/pull/19970
• Null assertion on denormalized_table argument by @Dtenwolde in https://github.com/duckdb/duckdb/pull/19947
• [Art][Wal]Unbound index allocations by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/19901
• No sampling over 281TB by @Tmonster in https://github.com/duckdb/duckdb/pull/19978
• Take in consideration if the sniffer used unstrictness while selecting candidates by @pdet in https://github.com/duckdb/duckdb/pull/20005
• [CSV] Avoid throwing unnecessary errors on strict mode by @pdet in https://github.com/duckdb/duckdb/pull/20007
• [Compression] Fix an issue with NULL updates to a column compressed with DICT_FSST by @Tishj in https://github.com/duckdb/duckdb/pull/20009
• Bump: delta, ducklake, iceberg by @maiadegraaf in https://github.com/duckdb/duckdb/pull/20012
• add unity_catalog, update delta by @samansmink in https://github.com/duckdb/duckdb/pull/20019
• Bump spatial by @staticlibs in https://github.com/duckdb/duckdb/pull/20020
• Retag #19821 to v1.4 - Use PLAIN_DICTIONARY for Parquet version 1 by @pdet in https://github.com/duckdb/duckdb/pull/20024
• Fix INSERT OR REPLACE BY NAME with partial columns(#19845) by @henry8128 in https://github.com/duckdb/duckdb/pull/19989
• Bump MySQL scanner by @staticlibs in https://github.com/duckdb/duckdb/pull/20025
• Windows must sample less by @Tmonster in https://github.com/duckdb/duckdb/pull/20018
• Issue #20015: Streaming Window Sequence by @hawkfish in https://github.com/duckdb/duckdb/pull/20027
• bump iceberg by @Tmonster in https://github.com/duckdb/duckdb/pull/20032
• Fix #20014: correctly use numeric_limits::min for NumericLimits::Min so that stats are initialized to -infinity for floating points by @Mytherin in https://github.com/duckdb/duckdb/pull/20039
• Enable windows_arm64 arch for main extensions by @staticlibs in https://github.com/duckdb/duckdb/pull/20004
• Fix mark join decorrelation by @kryonix in https://github.com/duckdb/duckdb/pull/20033
• propagate gate status in Node4::DeleteChild by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/20044
• Bump: httpfs by @samansmink in https://github.com/duckdb/duckdb/pull/20036
• Bump ducklake by @pdet in https://github.com/duckdb/duckdb/pull/20054
• bump azure to v1.4.3 by @benfleis in https://github.com/duckdb/duckdb/pull/20057
• Bump extensions by @samansmink in https://github.com/duckdb/duckdb/pull/20055
• Fix unnecessary dependent join rewrite by @kryonix in https://github.com/duckdb/duckdb/pull/20048
• Version tag for local files for robust external file cache validation by @lnkuiper in https://github.com/duckdb/duckdb/pull/20058
• backport runner cleanup action by @hannes in https://github.com/duckdb/duckdb/pull/20085

Full Changelog: https://github.com/duckdb/duckdb/compare/v1.4.2...v1.4.3

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. 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__COMPILER_LAUNCHER by @evertlammerts in https://github.com/duckdb/duckdb/pull/19326
• Add settings field to test config by @Mytherin in https://github.com/duckdb/duckdb/pull/19330
• Keep track of which database managers have which databases attached in the DatabaseFilePathManager by @Mytherin in https://github.com/duckdb/duckdb/pull/19338
• Bugfixes by @lnkuiper in https://github.com/duckdb/duckdb/pull/19329
• skip several ci jobs on prs that only bump extensions by @samansmink in https://github.com/duckdb/duckdb/pull/19249
• [C API] bind_value out of range fix by @taniabogatsch in https://github.com/duckdb/duckdb/pull/19348
• Destroy TaskNotifier prior to calling FinishTask by @Mytherin in https://github.com/duckdb/duckdb/pull/19373
• Remove zip bombs by @Mytherin in https://github.com/duckdb/duckdb/pull/19380
• Avoid calling shared_from_this() and instead use the passed in ClientContext in buffered data by @Mytherin in https://github.com/duckdb/duckdb/pull/19379
• add test tag support [vfs integration tests p1] by @benfleis in https://github.com/duckdb/duckdb/pull/19331
• Throw if non-VARCHAR key is passed to json_object by @lnkuiper in https://github.com/duckdb/duckdb/pull/19365
• BUGFIX: Silent failure to write row groups with large lists by @J-Meyers in https://github.com/duckdb/duckdb/pull/19376
• Fixes for CTE (de)serialization compatibility with older versions by @Mytherin in https://github.com/duckdb/duckdb/pull/19393
• Fix #18139: correctly initialize flush size in MemoryStream, and re-use writer states by @Mytherin in https://github.com/duckdb/duckdb/pull/19398
• Fixup Kalman fiter: bound it's (0, scale_factor), not (0, 1) by @carlopi in https://github.com/duckdb/duckdb/pull/19395
• Fix StringDecompress for hugeint_t values by @ywelsch in https://github.com/duckdb/duckdb/pull/19403
• Fix #19211: make INSERT OR IGNORE correctly handle multiple constraints by @Mytherin in https://github.com/duckdb/duckdb/pull/19409
• Issue #19386: ICU TZDEFAULT by @hawkfish in https://github.com/duckdb/duckdb/pull/19413
• Fix issue in MetadataManager triggered when doing concurrent reads while checkpointing, and rework concurrent attach / detach test by @Mytherin in https://github.com/duckdb/duckdb/pull/19424
• ADBC fix: escape schema, table and column identifiers by @evertlammerts in https://github.com/duckdb/duckdb/pull/19407
• v1.4: Only serialize CTE nodes when MATERIALIZED is specified by @Mytherin in https://github.com/duckdb/duckdb/pull/19420
• Add forwards compatibility tests to CI by @Mytherin in https://github.com/duckdb/duckdb/pull/19432
• Internal #6168: Unsupported Correlated Binds by @hawkfish in https://github.com/duckdb/duckdb/pull/19431
• Don't pull up filters through DISTINCT ON and make enum casts in Parquet safe (bugfixes) by @lnkuiper in https://github.com/duckdb/duckdb/pull/19406
• Get table bindings for all operators under a logical get if the logical get function is an unnest by @Tmonster in https://github.com/duckdb/duckdb/pull/19467
• WASM #1897: UTC Offset Support by @hawkfish in https://github.com/duckdb/duckdb/pull/19464
• Add tests for nested lambda bindings by @Dtenwolde in https://github.com/duckdb/duckdb/pull/19453
• [Compression] Fix issue in ZSTD decompression related to mis-interpreted segment offsets by @Tishj in https://github.com/duckdb/duckdb/pull/19475
• vfs integration tests p2 - update (env) vars and tests by @benfleis in https://github.com/duckdb/duckdb/pull/19428
• CI Fix: clear benchmark cache between runs by @Mytherin in https://github.com/duckdb/duckdb/pull/19508
• Make DatabaseInstance::log_manager a unique_ptr by @Flogex in https://github.com/duckdb/duckdb/pull/19471
• Support non-standard NULL in Parquet again by @Mytherin in https://github.com/duckdb/duckdb/pull/19523
• Bump: inet by @samansmink in https://github.com/duckdb/duckdb/pull/19526
• Bump multiple extensions by @samansmink in https://github.com/duckdb/duckdb/pull/19522
• add upcoming patch release to internal versions by @samansmink in https://github.com/duckdb/duckdb/pull/19525
• Add test that either 'latest' or 'vX.Y.Z' are supported STORAGE_VERSIONs by @carlopi in https://github.com/duckdb/duckdb/pull/19527
• Moving staging to cf and uploading to install bucket by @hannes in https://github.com/duckdb/duckdb/pull/19539
• Creating separate OSX cli binaries for each arch by @hannes in https://github.com/duckdb/duckdb/pull/19538
• [Dev] Disable the use of ZSTD if the block_manager is the InMemoryBlockManager by @Tishj in https://github.com/duckdb/duckdb/pull/19543
• Follow up to staging move by @hannes in https://github.com/duckdb/duckdb/pull/19551
• Bugfixes: Parquet JSON+DELTA_LENGTH_BYTE_ARRAY and sorting iterator by @lnkuiper in https://github.com/duckdb/duckdb/pull/19556
• [ported from main] Fix bug initializing std::vector for column names by @evertlammerts in https://github.com/duckdb/duckdb/pull/19555
• Disable jemalloc on BSD by @lnkuiper in https://github.com/duckdb/duckdb/pull/19560
• Fix race condition between Append and Scan by @Captain32 in https://github.com/duckdb/duckdb/pull/19571
• Release relevant tests to still be run on all builds by @carlopi in https://github.com/duckdb/duckdb/pull/19559
• fix inconsistent behavior in remote read_file/blob, and prevent union… by @Maxxen in https://github.com/duckdb/duckdb/pull/19531
• [v1.4-andium] Add Profiler output to logger interface by @carlopi in https://github.com/duckdb/duckdb/pull/19572
• Fix edge case in uncompressed validity scan with offset and fix off-by-one in ArrayColumnData::Select by @Maxxen in https://github.com/duckdb/duckdb/pull/19567
• Skip compiling remote optimizer test when TSAN Is enabled by @Mytherin in https://github.com/duckdb/duckdb/pull/19590
• Wal index deletes by @artjomPlaunov in https://github.com/duckdb/duckdb/pull/19477
• add vortex external extension by @samansmink in https://github.com/duckdb/duckdb/pull/19580
• Avoid eagerly resolving the next on-disk pointer in the MetadataReader, as that pointer might not always be valid by @Mytherin in https://github.com/duckdb/duckdb/pull/19588
• [DevEx] Improve error message when FROM clause is omitted by @Tishj in https://github.com/duckdb/duckdb/pull/18995
• bump iceberg by @Tmonster in https://github.com/duckdb/duckdb/pull/19618
• Improve error message around compression type deprecation/availability checks by @Tishj in https://github.com/duckdb/duckdb/pull/19619
• Increase cast-cost of old-style implicit cast to string by @Maxxen in https://github.com/duckdb/duckdb/pull/19621
• Try to prevent overshooting of FILE_SIZE_BYTES by pre-emptively increasing bytes written in Parquet writer by @lnkuiper in https://github.com/duckdb/duckdb/pull/19622
• Bump: spatial by @Maxxen in https://github.com/duckdb/duckdb/pull/19620
• Detect invalid merge into action and throw exception by @Mytherin in https://github.com/duckdb/duckdb/pull/19636
• Fix #19455: correctly extract root table in merge into when running ajoin that contains single-sided predicates that are transformed into filters by @Mytherin in https://github.com/duckdb/duckdb/pull/19637
• Remove FlushAll from DETACH by @lnkuiper in https://github.com/duckdb/duckdb/pull/19644
• Bump MySQL scanner by @staticlibs in https://github.com/duckdb/duckdb/pull/19643
• Enable running all extensions tests as part of the build step by @carlopi in https://github.com/duckdb/duckdb/pull/19631
• Always remember extra_metadata_blocks when checkpointing by @ywelsch in https://github.com/duckdb/duckdb/pull/19639
• duckdb_logs_parsed to do case-insensitive matching by @carlopi in https://github.com/duckdb/duckdb/pull/19669
• Categorize ParseLogMessage as CAN_THROW_RUNTIME_ERROR by @carlopi in https://github.com/duckdb/duckdb/pull/19672
• Fixup linking for LLVM by @carlopi in https://github.com/duckdb/duckdb/pull/19668
• Log total probe matches in hash join by @lnkuiper in https://github.com/duckdb/duckdb/pull/19683
• Fix InsertRelation on attached database by @evertlammerts in https://github.com/duckdb/duckdb/pull/19583
• Add request timing to HTTP log by @samansmink in https://github.com/duckdb/duckdb/pull/19691
• Add missing query location to blob cast by @Mytherin in https://github.com/duckdb/duckdb/pull/19689
• Bump: aws, ducklake, httpfs, iceberg by @samansmink in https://github.com/duckdb/duckdb/pull/19654
• Bump: delta, ducklake, httpfs by @samansmink in https://github.com/duckdb/duckdb/pull/19715
• Fix #19355: correctly resolve subquery in MERGE INTO action condition by @Mytherin in https://github.com/duckdb/duckdb/pull/19720
• Fix #19700: correctly sort output selection vector in nested selection operations by @Mytherin in https://github.com/duckdb/duckdb/pull/19718
• Bump httpfs and resume testing on Windows by @carlopi in https://github.com/duckdb/duckdb/pull/19714
• [Dev] Fix assertion failure for empty ColumnData serialization by @Tishj in https://github.com/duckdb/duckdb/pull/19713
• Bump the Postgres scanner extension by @Mytherin in https://github.com/duckdb/duckdb/pull/19730
• Add explicit Initialize(HTTPParam&) method to HTTPClient by @carlopi in https://github.com/duckdb/duckdb/pull/19723
• Logs to be case-insensitive also at enable_logging callsite by @carlopi in https://github.com/duckdb/duckdb/pull/19734
• Fix CVE https://github.com/duckdb/duckdb/security/advisories/GHSA-vmp8-hg63-v2hp crypto issues by @samansmink in https://github.com/duckdb/duckdb/pull/19716

Full Changelog: https://github.com/duckdb/duckdb/compare/v1.4.1...v1.4.2