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