DuckDB 1.1.3 release notes

This is a bug fix release for various issues discovered after we released 1.1.2. 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

[Adaptive Sniffer] In case files have only one row, be more permissive to detect headers and types. by @pdet in https://github.com/duckdb/duckdb/pull/14174
Increase bounds for test/sql/copy/file_size_bytes.test by @lnkuiper in https://github.com/duckdb/duckdb/pull/14367
Use table-level locking when acquiring shared locks by @ywelsch in https://github.com/duckdb/duckdb/pull/14370
[Arrow] Fix scanning of BOOL columns when offsets are involved by @Tishj in https://github.com/duckdb/duckdb/pull/14395
avoid unnecessary file list materialization when pruning readers by @samansmink in https://github.com/duckdb/duckdb/pull/14397
Fixing type pushdown on the CSV Scanner by @pdet in https://github.com/duckdb/duckdb/pull/14399
Issue #14398: Lead Shift Defaults by @hawkfish in https://github.com/duckdb/duckdb/pull/14409
Escape should default to quoted by @pdet in https://github.com/duckdb/duckdb/pull/14418
Sniff CSV rejects options and small sniffer fix for ignore_errors by @pdet in https://github.com/duckdb/duckdb/pull/14417
Fix #14430 - throw an error when reading corrupt statistics in the perfect hash aggregate by @Mytherin in https://github.com/duckdb/duckdb/pull/14442
Use corrent container to produce BinderErrors by @carlopi in https://github.com/duckdb/duckdb/pull/14437
Rework list_concat to accept a variable number of arguments similar to string concat by @Mytherin in https://github.com/duckdb/duckdb/pull/14443
SingleFileBlockManager::MarkBlockAsUsed - also erase from newly_freed_list to ensure trim does not prune blocks that are in-use by @Mytherin in https://github.com/duckdb/duckdb/pull/14467
acosh: Change example to avoid returning NaN by @szarnyasg in https://github.com/duckdb/duckdb/pull/14477
Don't move lvalue when inserting in order preserving map by @Maxxen in https://github.com/duckdb/duckdb/pull/14492
bump vss by @Maxxen in https://github.com/duckdb/duckdb/pull/14493
Bug in percentage calculation in query_graph by @bjornasm in https://github.com/duckdb/duckdb/pull/14494
fix: standardize usage of LogicalType::ROW_TYPE for COLUMN_IDENTIFIER_ROW_ID by @rustyconover in https://github.com/duckdb/duckdb/pull/14480
[Python][Dev] Fix up test to work with older version by @Tishj in https://github.com/duckdb/duckdb/pull/14505
Avoid throwing on failure to open extensions's .info file (when force installing) by @carlopi in https://github.com/duckdb/duckdb/pull/14272
Python 3.7 tests are particularly brittle, we will keep building wheels but avoid testing them by @carlopi in https://github.com/duckdb/duckdb/pull/14510
Being more restrictive with the names option in the csv reader by @pdet in https://github.com/duckdb/duckdb/pull/14466
[Arrow] Fix issue where uninitialized memory was being read when scanning empty lists by @Tishj in https://github.com/duckdb/duckdb/pull/14538
Fix #14545 - pivot header must be defined in the grammar by @Mytherin in https://github.com/duckdb/duckdb/pull/14556
[Python][Arrow] Cast to py::bytes when dealing with BLOB in filter pushdown by @Tishj in https://github.com/duckdb/duckdb/pull/14553
[Dev] Include aliases for RETURNING list expressions in ToString by @Tishj in https://github.com/duckdb/duckdb/pull/14533
CI: Mirror 'reproduced' / 'under review' to the internal repository by @szarnyasg in https://github.com/duckdb/duckdb/pull/14527
Approx-Top K: Make aggregate state trivially destructible by @Mytherin in https://github.com/duckdb/duckdb/pull/14571
Don't pre-initialize hash vector in DistinctStatistics construction by @abramk in https://github.com/duckdb/duckdb/pull/14570
Fix query_graph tool for #14290 by @JasonPunyon in https://github.com/duckdb/duckdb/pull/14521
Fix typos by @deining in https://github.com/duckdb/duckdb/pull/14579
[Dev] Traverse the replace_list of StarExpression in ParsedExpressionIterator::EnumerateChildren by @Tishj in https://github.com/duckdb/duckdb/pull/14535
chore: Add EOL to source files by @krlmlr in https://github.com/duckdb/duckdb/pull/14583
Issue template: Add Swift redirect by @szarnyasg in https://github.com/duckdb/duckdb/pull/14588
Fix for underflow issue on number of rows in the CSV Reader by @pdet in https://github.com/duckdb/duckdb/pull/14587
Cas strong by @lnkuiper in https://github.com/duckdb/duckdb/pull/14592
HTTPFS: HTTPException no longer inherits from IOException by @Mytherin in https://github.com/duckdb/duckdb/pull/14585
[bufferpool] Fix PurgeAgedBlocksInternal() evictions by @Vegetable26 in https://github.com/duckdb/duckdb/pull/14446
CI: Add bot for 'minimal reproducible example' by @szarnyasg in https://github.com/duckdb/duckdb/pull/14598
CI: Fix and simplify 'needs reproducible example' labelling by @szarnyasg in https://github.com/duckdb/duckdb/pull/14608
CI: Fix and simplify 'needs reproducible example' labelling by @szarnyasg in https://github.com/duckdb/duckdb/pull/14609
Enable serialization of LogicalExport by @Mytherin in https://github.com/duckdb/duckdb/pull/14594
Test fixes for new arrow release by @pdet in https://github.com/duckdb/duckdb/pull/14593
CI: Fix labelling bot by @szarnyasg in https://github.com/duckdb/duckdb/pull/14611
CI: Add repo name to labelling script by @szarnyasg in https://github.com/duckdb/duckdb/pull/14612
Unexpected result comparing blob by @Tmonster in https://github.com/duckdb/duckdb/pull/14604
Storage info update by @szarnyasg in https://github.com/duckdb/duckdb/pull/14371
Fix #14600: use UUID to generate unique pivot enum names by @Mytherin in https://github.com/duckdb/duckdb/pull/14622
Fix #14601: avoid exporting entries in the temp or system schema by @Mytherin in https://github.com/duckdb/duckdb/pull/14623
Issue #14618: Year Day Year by @hawkfish in https://github.com/duckdb/duckdb/pull/14624
Fix #14542 by @lnkuiper in https://github.com/duckdb/duckdb/pull/14610
add index plan callback to IndexType by @Maxxen in https://github.com/duckdb/duckdb/pull/14511
FIX: Discrepancy Between Count and Sum Queries in SQL by @Tmonster in https://github.com/duckdb/duckdb/pull/14634
Fix Windows Extensions CI by @Mytherin in https://github.com/duckdb/duckdb/pull/14643
chore: Add qualification for brotli code by @krlmlr in https://github.com/duckdb/duckdb/pull/14628
fix: Initialize atomic class member by @krlmlr in https://github.com/duckdb/duckdb/pull/14627
Fix secret serialization issues by @samansmink in https://github.com/duckdb/duckdb/pull/14652
Add serialization for bitstring_agg function by @ywelsch in https://github.com/duckdb/duckdb/pull/14654
Force error on CSV Sniffer Failure by @lcostantino in https://github.com/duckdb/duckdb/pull/14661
bump vss + spatial by @Maxxen in https://github.com/duckdb/duckdb/pull/14667
Bump extensions: AWS, Delta, Iceberg, INET by @carlopi in https://github.com/duckdb/duckdb/pull/14669
fix scoping problem with function argument by @Damon07 in https://github.com/duckdb/duckdb/pull/14666

Full Changelog: https://github.com/duckdb/duckdb/compare/v1.1.2...v1.1.3