DuckDB v1.5.2 Bugfix Release

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

Full Changelog: v1.5.1...v1.5.2