DuckDB 1.1.1 release notes

This is a bug fix release for various issues discovered after we released 1.1.0. There are no new major features, just bug fixes. Database files created by DuckDB since v0.9.* can be read by DuckDB v1.1.1.

What's Changed

[Python] Fix a crash related to handling of the f_locals by @Tishj in https://github.com/duckdb/duckdb/pull/13821
[Dev] Remove unnecessary parameter from BufferHandle constructor by @Tishj in https://github.com/duckdb/duckdb/pull/13823
When vacuuming, immediately checkpoint the vacuumed row groups instead of scheduling a checkpoint task by @Mytherin in https://github.com/duckdb/duckdb/pull/13825
Check for unquoted errors after finishing up a buffer. by @pdet in https://github.com/duckdb/duckdb/pull/13826
Issue #13813: TIMETZ Uninvertible Casts by @hawkfish in https://github.com/duckdb/duckdb/pull/13820
add cardinality for cross product and propositional join by @jeewonhh in https://github.com/duckdb/duckdb/pull/13818
Add requested_schema argument to PyCapsule interface by @WillAyd in https://github.com/duckdb/duckdb/pull/13802
Throw at double/float cast to decimal if it does not fit by @pdet in https://github.com/duckdb/duckdb/pull/13745
[Fix] C API - Correct type comparison in MAP value functions by @taniabogatsch in https://github.com/duckdb/duckdb/pull/13844
[C-API Dev] Fix up "Test DataChunk populate ListVector in C API" test by @Tishj in https://github.com/duckdb/duckdb/pull/13839
[Dev] Minor cleanup to BufferManager and BlockHandle API by @Tishj in https://github.com/duckdb/duckdb/pull/13838
Small fixes for prompt of sniff_csv by @pdet in https://github.com/duckdb/duckdb/pull/13843
[BufferManager] Fix duckdb_memory() reporting wrong size for temporary_storage_bytes by @Tishj in https://github.com/duckdb/duckdb/pull/13837
Fix for internal error when using rejects tables and adding implicit cast for boolean values. by @pdet in https://github.com/duckdb/duckdb/pull/13849
[Fix ART] Correct prefix transformation by @taniabogatsch in https://github.com/duckdb/duckdb/pull/13858
[Python] Fix issue causing an exception when creating a duckdb.StarExpression without an exclude_list by @Tishj in https://github.com/duckdb/duckdb/pull/13881
Fix issue with cgroups/slurm variables: skip if memory limit cannot be parsed, and only run this on Linux by @Mytherin in https://github.com/duckdb/duckdb/pull/13879
Explicit windows-2019 instead of windows-latest by @carlopi in https://github.com/duckdb/duckdb/pull/13883
CI/Windows: Drop redundant package by @szarnyasg in https://github.com/duckdb/duckdb/pull/13874
Preserve operator in BindWithCTE by @lnkuiper in https://github.com/duckdb/duckdb/pull/13873
Update description of 'max_temp_directory_size' by @szarnyasg in https://github.com/duckdb/duckdb/pull/13724
13810 unnest cross join error by @Tmonster in https://github.com/duckdb/duckdb/pull/13878
Tweak allocation purging by @lnkuiper in https://github.com/duckdb/duckdb/pull/13877
Copy From Database - create a balanced UNION ALL tree instead of a depth-first union all tree to avoid stack overflows by @Mytherin in https://github.com/duckdb/duckdb/pull/13889
[Python] Fix issue related to the GIL when using execute with multiple statements by @Tishj in https://github.com/duckdb/duckdb/pull/13893
Fix #13880: correctly name http_proxy_password setting by @Mytherin in https://github.com/duckdb/duckdb/pull/13890
Fix #13872: duckdb_result_return_type is not deprecated, and group together deprecated functions by @Mytherin in https://github.com/duckdb/duckdb/pull/13891
[Python] Add python_scan_all_frames to opt-in to scanning all frames (< 1.1 behavior) by @Tishj in https://github.com/duckdb/duckdb/pull/13896
Improve error on enums by @carlopi in https://github.com/duckdb/duckdb/pull/13885
Handle extension ABI mismatches in a forward & backward compatible way by @carlopi in https://github.com/duckdb/duckdb/pull/13894
Fix #13824: min() max() varchar column use default collation by @flashmouse in https://github.com/duckdb/duckdb/pull/13909
Fix issue in casting 2 byte BIT -> BLOB by @Tishj in https://github.com/duckdb/duckdb/pull/13908
add missing azure secret providers for autoloading by @samansmink in https://github.com/duckdb/duckdb/pull/13902
Remove buffer_manager_allocate.patch and bump spatial by @carlopi in https://github.com/duckdb/duckdb/pull/13895
[Python] Improve install_extension to support repository/repository_url and version by @Tishj in https://github.com/duckdb/duckdb/pull/13876
fix REGEX not supported anymore for valid queries (only statement error) #2889 by @hmeriann in https://github.com/duckdb/duckdb/pull/13633
[CI] Invert operations on OSX.yml, deploying nightly artifacts before test by @carlopi in https://github.com/duckdb/duckdb/pull/13927
[Python][Jupyter] Don't use ExplainFormat::HTML for explain('analyze') by @Tishj in https://github.com/duckdb/duckdb/pull/13928
Only bind to SQL value functions if there is no alias with this name present we can bind to instead by @Mytherin in https://github.com/duckdb/duckdb/pull/13925
Improve logic for remote extension install on Windows by @carlopi in https://github.com/duckdb/duckdb/pull/13929
CI: Trigger actions for labeled discussions by @szarnyasg in https://github.com/duckdb/duckdb/pull/13937
[Swift] Update README.md in Swift repo by @tcldr in https://github.com/duckdb/duckdb/pull/13955
[Dev] Add exclusion for pybind11 internal _pybind11_conduit_v1_ method by @Tishj in https://github.com/duckdb/duckdb/pull/13961
Create a balanced union tree, also for export by @Mytherin in https://github.com/duckdb/duckdb/pull/13956
Increment julia version by @Mytherin in https://github.com/duckdb/duckdb/pull/13966
Fix #13585 - transform from or select first based on order specified by the user by @Mytherin in https://github.com/duckdb/duckdb/pull/13959
Fix Cross Product Cardinality by @jeewonhh in https://github.com/duckdb/duckdb/pull/13954
Do not run the date/timestamp format sniffer if they are set by the user by @pdet in https://github.com/duckdb/duckdb/pull/13960
Modify create_art_varchar.benchmark so it passes weekly regressions by @Tmonster in https://github.com/duckdb/duckdb/pull/13968
Fix data race when writing GeoParquet by @Maxxen in https://github.com/duckdb/duckdb/pull/13962
Check vector type in GetVectorScanType to avoid concurrent race when updating validity by @Mytherin in https://github.com/duckdb/duckdb/pull/13965
Parser Keyword Category Search by @pdet in https://github.com/duckdb/duckdb/pull/13875
Escape quotes in FTS by @lnkuiper in https://github.com/duckdb/duckdb/pull/13917
Fix #13941: fix error message in appender by @Mytherin in https://github.com/duckdb/duckdb/pull/13957
fix: remove http prefix from proxy value when present by @dylanspag-lmco in https://github.com/duckdb/duckdb/pull/13973
Use defaults when serializing copy to file by @Mytherin in https://github.com/duckdb/duckdb/pull/13978
Fix #13933: disable join filter pushdown when a join is performed over collated columns by @Mytherin in https://github.com/duckdb/duckdb/pull/13958
Fix partitions on wide tables by @piever in https://github.com/duckdb/duckdb/pull/13988
[Fix] Throw exception for UNNEST in lambdas by @taniabogatsch in https://github.com/duckdb/duckdb/pull/13969
Fixing some parquet issues found by fuzzing by @hannes in https://github.com/duckdb/duckdb/pull/13964
fix julia partitions for streaming result by @piever in https://github.com/duckdb/duckdb/pull/14000
More descriptive Parquet created_by with version and source hash by @hannes in https://github.com/duckdb/duckdb/pull/13992
Decimal downcast limit check by @pdet in https://github.com/duckdb/duckdb/pull/13922
[C API] Add SQLNULL to the duckdb types by @taniabogatsch in https://github.com/duckdb/duckdb/pull/13999
Fix crash in the shell caused by printing blobs that failed to cast by @Maxxen in https://github.com/duckdb/duckdb/pull/13983
[Binding] Always try binding with the schema of the UserType first if it's set by @Tishj in https://github.com/duckdb/duckdb/pull/13995
[Arrow] Only produce 'arrow.json' Extension types when arrow_lossless_conversion is enabled. by @Tishj in https://github.com/duckdb/duckdb/pull/13989
Bugfixes by @lnkuiper in https://github.com/duckdb/duckdb/pull/13982
Disable swift linux tests by @Mytherin in https://github.com/duckdb/duckdb/pull/14019
fix minor typos in comments of aggregate function tests by @era127 in https://github.com/duckdb/duckdb/pull/14007
[CSV Sniffer] Slight change of rules for dialect detection by @pdet in https://github.com/duckdb/duckdb/pull/14013
[Test Fix] Add noforcestorage to in-memory tests by @taniabogatsch in https://github.com/duckdb/duckdb/pull/14016
Fix #14020: fix off-by-one in RLE compression: avoid flushing when last_seen_count == 0 which can happen if a column has exactly 2^16 (65535) repeated values by @Mytherin in https://github.com/duckdb/duckdb/pull/14030
Adds Julia support for scalar UDFs by @drizk1 in https://github.com/duckdb/duckdb/pull/14024
Proper NULL handling in special json extraction functions by @lnkuiper in https://github.com/duckdb/duckdb/pull/14032
Fix #13993 - avoid disabling optimizers for SET VARIABLE by @Mytherin in https://github.com/duckdb/duckdb/pull/14028
[Arrow] Make unknown Arrow extensions throw at scan instead of bind by @pdet in https://github.com/duckdb/duckdb/pull/14015
Improve assertion macros by @c-herrewijn in https://github.com/duckdb/duckdb/pull/14033
[Arrow] Move ArrowUtil to its own file by @Tishj in https://github.com/duckdb/duckdb/pull/13990
[CSV Sniffer] Verify validity of header before value access by @pdet in https://github.com/duckdb/duckdb/pull/14040
Fix #14026: all TIMESTAMP_xx cannot cast to TIME directly by @flashmouse in https://github.com/duckdb/duckdb/pull/14045
Only merge distinct stats if both sides have distinct stats available by @Mytherin in https://github.com/duckdb/duckdb/pull/14046
Avoid http-redirect in README by @carlopi in https://github.com/duckdb/duckdb/pull/14029
fix: make ArrowArrayWrapper::GetNextChunk() virtual by @rustyconover in https://github.com/duckdb/duckdb/pull/14003
Issue #13655: MEDIAN Even Tests by @hawkfish in https://github.com/duckdb/duckdb/pull/13722
Fix #13934: use CreateSortKeyWithValidity to correctly handle NULL in all calls to arg_max by @Mytherin in https://github.com/duckdb/duckdb/pull/14053
Upgrade MySQL/Postgres extensions by @Mytherin in https://github.com/duckdb/duckdb/pull/14054
[Union Reader] Early-out on readers of files that do not have data by @pdet in https://github.com/duckdb/duckdb/pull/14050
Issue #13899: AsOf Unrelated Pushdown by @hawkfish in https://github.com/duckdb/duckdb/pull/13975
Feature #3128: 2024b Time Zones by @hawkfish in https://github.com/duckdb/duckdb/pull/14061
bump spatial by @Maxxen in https://github.com/duckdb/duckdb/pull/14062
Fixup StagedUpload invocation via workflow_call by @carlopi in https://github.com/duckdb/duckdb/pull/14065
Skip polars test in 3.7 due to missing PanicException by @carlopi in https://github.com/duckdb/duckdb/pull/14066
Add building, testing and distributing for Python 3.13 by @carlopi in https://github.com/duckdb/duckdb/pull/14067
bump sqlsmith and azure versions by @samansmink in https://github.com/duckdb/duckdb/pull/14069
bump substrait by @pdet in https://github.com/duckdb/duckdb/pull/14055
CIBW_SKIP also musllinux on Python 3.7 or Python 3.8 by @carlopi in https://github.com/duckdb/duckdb/pull/14074

Full Changelog: https://github.com/duckdb/duckdb/compare/v1.1.0...v1.1.1