1.2.1

This is a bug fix release for various issues discovered after we released 1.2.0. There are no new major features, just bug fixes. Database files created by DuckDB versions all the way back to v0.9.* can be read by this version.

What's Changed

• [Dev] MultiFileReader fix InternalError in CreateFilterMap by @Tishj in https://github.com/duckdb/duckdb/pull/16114
• [bug-fix] Avoid throwing in catch block for failed commits by @Vegetable26 in https://github.com/duckdb/duckdb/pull/15903
• Issue #16098: ValidEnd Parallel Vectorisation by @hawkfish in https://github.com/duckdb/duckdb/pull/16140
• Adding an extension option shouldn't delete a set value and promote unrecognized options by @bleskes in https://github.com/duckdb/duckdb/pull/15919
• Parquet writer: Re-implement GetRowSize for Strings by @Mytherin in https://github.com/duckdb/duckdb/pull/16178
• Fix #16157: correctly get the first row when reading hive partitions from a dictionary vector by @Mytherin in https://github.com/duckdb/duckdb/pull/16180
• Fix #16122: bind default values in a sub-binder to avoid modifying the catalog search path of the current binder by @Mytherin in https://github.com/duckdb/duckdb/pull/16181
• Fix #16134: when a catalog/schema/table has the same name, we prefer to suggest the table name by @Mytherin in https://github.com/duckdb/duckdb/pull/16189
• Ensure MergeCollectionTask has a writer by @ywelsch in https://github.com/duckdb/duckdb/pull/16207
• Backport #16115 by @NiclasHaderer in https://github.com/duckdb/duckdb/pull/16227
• Deleted copy constructor of pending query by @NiclasHaderer in https://github.com/duckdb/duckdb/pull/16242
• Correctly report errors caused by get_database in C extensions by @mlafeldt in https://github.com/duckdb/duckdb/pull/16253
• use random seeds for bernoulli sample when parallel is enabled by @Tmonster in https://github.com/duckdb/duckdb/pull/16223
• Parquet Reader: avoid caching the compressed buffer in the ColumnReader by @Mytherin in https://github.com/duckdb/duckdb/pull/16263
• Fix #16260: correctly handle parameters in getvariable by @Mytherin in https://github.com/duckdb/duckdb/pull/16264
• Avoid calling SetFilterAlwaysTrue multiple times in RowGroup::CheckZonemap by @Mytherin in https://github.com/duckdb/duckdb/pull/16269
• [Fix] Scanning from normal leaf to nested leaf by @taniabogatsch in https://github.com/duckdb/duckdb/pull/16270
• Fix #16231: refer to order by condition in ARRAY(SUBQUERY) by alias instead of by index by @Mytherin in https://github.com/duckdb/duckdb/pull/16272
• Fix #16257 by @lnkuiper in https://github.com/duckdb/duckdb/pull/16275
• AFL Tests for the CSV reader by @pdet in https://github.com/duckdb/duckdb/pull/16280
• Issue #16250: Window Range Performance by @hawkfish in https://github.com/duckdb/duckdb/pull/16276
• Fix #16278: late materialization should not trigger on very large limits, and it should never trigger on limits without offsets when preserve_insertion_order = false by @Mytherin in https://github.com/duckdb/duckdb/pull/16282
• Overflow strings allocations: avoid rounding up memory allocated per overflow string - when reading "small" overflow strings place them directly into the vector instead by @Mytherin in https://github.com/duckdb/duckdb/pull/16283
• Use ordered map to preserve expressions order by @Damon07 in https://github.com/duckdb/duckdb/pull/16111
• [Dev] register_filesystem stubs, use fsspec.AbstractFileSystem, not str by @Tishj in https://github.com/duckdb/duckdb/pull/16266
• [Python Dev] Fix crash with empty args for isin | Fix transformation for isnotin by @Tishj in https://github.com/duckdb/duckdb/pull/16271
• Fix issue related to hang when all candidates are eliminated in refinement by @pdet in https://github.com/duckdb/duckdb/pull/16288
• [Fix] Early-out on CREATE INDEX (IF NOT EXISTS) by @taniabogatsch in https://github.com/duckdb/duckdb/pull/16093
• [Python] Fix the reverse binary expressions in the Expression API by @Tishj in https://github.com/duckdb/duckdb/pull/16300
• Bugfixes by @lnkuiper in https://github.com/duckdb/duckdb/pull/16244
• [Fix] MinGW bundle static libs by @taniabogatsch in https://github.com/duckdb/duckdb/pull/16292
• Fix heap buffer oveflow sampling by @Tmonster in https://github.com/duckdb/duckdb/pull/16279
• Expose STRING_LITERAL in C API by @taniabogatsch in https://github.com/duckdb/duckdb/pull/16293
• Allow accessing profiler query tree under lock by @ywelsch in https://github.com/duckdb/duckdb/pull/16314
• bump extensions by @Maxxen in https://github.com/duckdb/duckdb/pull/16313
• Inline virtual list lambda bind functions by @Maxxen in https://github.com/duckdb/duckdb/pull/16327
• Update shell.cpp to fix #16333 by @teaguesterling in https://github.com/duckdb/duckdb/pull/16335
• Add the suggestion to verify the nullstring as part of the cast error message by @pdet in https://github.com/duckdb/duckdb/pull/16336
• Take NULLs into account for DELTA_BINARY_PACKED by @lnkuiper in https://github.com/duckdb/duckdb/pull/16317
• PhysicalTableScan: Adapt to allow async behaviour by @carlopi in https://github.com/duckdb/duckdb/pull/16310
• Allow querying attached catalog from detached catalog by @jeewonhh in https://github.com/duckdb/duckdb/pull/16289
• Reduce minimum expected memory usage in RadixPartitionedHashTable by @lnkuiper in https://github.com/duckdb/duckdb/pull/16332
• Backport ebb4dccf to v1.2-, adding missing include by @carlopi in https://github.com/duckdb/duckdb/pull/16369
• Excecption load on mismatched ABI: Use '%d' to print ABI type by @carlopi in https://github.com/duckdb/duckdb/pull/16367
• Aggregation: For dictionaries without an id - use the correct threshold to bail-out on using the dictionary by @Mytherin in https://github.com/duckdb/duckdb/pull/16364
• Bump excel to the same version distributed on core repository by @carlopi in https://github.com/duckdb/duckdb/pull/16375
• Accept valid dialects with escape set into the refinement phase by @pdet in https://github.com/duckdb/duckdb/pull/16387
• Push the correct casts for values of different types in (X, Y) IN (SELECT X, Y) by @Mytherin in https://github.com/duckdb/duckdb/pull/16392
• Add support for autoload and autoinstall for ui extension by @carlopi in https://github.com/duckdb/duckdb/pull/16393
• Add twine_upload option to Python.yml to trigger upload by @carlopi in https://github.com/duckdb/duckdb/pull/16410
• Only select options that generate more columns with null_padding, if they at least hold 50% of consistency by @pdet in https://github.com/duckdb/duckdb/pull/16404
• Use checkpoint bind in DuckTableEntry::Copy to avoid re-validating default values (and potentially causing issues during WAL replay) by @Mytherin in https://github.com/duckdb/duckdb/pull/16398
• Rename DUCKDB_API to DUCKDB_C_API for duckdb.h by @Mytherin in https://github.com/duckdb/duckdb/pull/16397
• Issue #16407: Try_Strptime Invalid TimeZone by @hawkfish in https://github.com/duckdb/duckdb/pull/16416
• Internal #4303: Windowed DISTINCT Leaks by @hawkfish in https://github.com/duckdb/duckdb/pull/16417
• Internal #4258: MODE Spooling Stability by @hawkfish in https://github.com/duckdb/duckdb/pull/16415
• Fix PyPi upload also for branches, when twine_upload is provided by @carlopi in https://github.com/duckdb/duckdb/pull/16421
• [Fix] Throw constraint violation for FK constraint checking by @taniabogatsch in https://github.com/duckdb/duckdb/pull/16399
• Add storage and serialization version for v1.2.1 by @Flogex in https://github.com/duckdb/duckdb/pull/16403
• Update flaky return_files.test by @jeewonhh in https://github.com/duckdb/duckdb/pull/16432
• Add python version to duckdb_api by @guenp in https://github.com/duckdb/duckdb/pull/15599
• Do not accept null values in lists for column parameters by @pdet in https://github.com/duckdb/duckdb/pull/16425
• Use seed for system sample when it is provided. by @Tmonster in https://github.com/duckdb/duckdb/pull/16408
• Bump delta to working commit by @carlopi in https://github.com/duckdb/duckdb/pull/16442
• Adding windows code signing using azure by @hannes in https://github.com/duckdb/duckdb/pull/16444
• CSV small code Improvements + initialising boolean variable. by @pdet in https://github.com/duckdb/duckdb/pull/16454
• [Python Dev] Make pandas not required in a couple places, check if it's installed in others by @Tishj in https://github.com/duckdb/duckdb/pull/16414
• fix passing a null path to the C API instance cache by @jraymakers in https://github.com/duckdb/duckdb/pull/16474
• Add methods to retrieve current task scheduler busyness by @NiclasHaderer in https://github.com/duckdb/duckdb/pull/16465
• Fixed reading piped JSON by @lnkuiper in https://github.com/duckdb/duckdb/pull/16480
• [Python Dev] pyproject.toml should not use oldest-supported-numpy anymore by @Tishj in https://github.com/duckdb/duckdb/pull/16486
• [tests] Multiple FORMAT in copy, only last one matters by @carlopi in https://github.com/duckdb/duckdb/pull/16493
• Bump postgres_scanner and fts extensions by @lnkuiper in https://github.com/duckdb/duckdb/pull/16492
• bump sqlsmith extension tag by @Tmonster in https://github.com/duckdb/duckdb/pull/16488
• [BugFix]: Swap join children, not left and right set by @Tmonster in https://github.com/duckdb/duckdb/pull/16487
• [tests] Add allow_unsigned_extensions require by @carlopi in https://github.com/duckdb/duckdb/pull/16499
• Provide callback when tasks are starting / stopping by @ywelsch in https://github.com/duckdb/duckdb/pull/16451
• CodeQuality: ubuntu-20 to ubuntu-22, lock black to version 24 and trick clang_format detection by @carlopi in https://github.com/duckdb/duckdb/pull/16513
• Move from ubuntu-20:04 to ubuntu-22:04, part I by @carlopi in https://github.com/duckdb/duckdb/pull/16510
• [chore] Build Linux releases also on PRs AND ubuntu-20 to 22 by @carlopi in https://github.com/duckdb/duckdb/pull/16506
• Move from ubuntu-20:04 to ubuntu-22:04, part II by @carlopi in https://github.com/duckdb/duckdb/pull/16514
• bump spatial and excel for v1.2 by @Maxxen in https://github.com/duckdb/duckdb/pull/16504
• CI Fixes after upgrade to ubuntu 22 by @Mytherin in https://github.com/duckdb/duckdb/pull/16516
• LinuxRelease.yml: Pass down override git describe by @carlopi in https://github.com/duckdb/duckdb/pull/16521
• bump spatial again by @Maxxen in https://github.com/duckdb/duckdb/pull/16518

Full Changelog: https://github.com/duckdb/duckdb/compare/v1.2.0...v1.2.1