Duckdb Versions Save

This is a bug fix release for various issues discovered after we released 0.10.1. There are no new features, just bug fixes. Database files created by DuckDB v0.10.* or v0.9.* can be read by DuckDB v0.10.2.

SQL Modifications

This release has a number of bug fixes that change SQL semantics in a few edge cases:

• Nested Boolean Comparisons now have consistent NULL comparison semantics - https://github.com/duckdb/duckdb/pull/11496
• Structs with non-matching keys require explicit casts when compared or combined - https://github.com/duckdb/duckdb/pull/11396

What's Changed

• Bump julia version & fix release script for sub-versions > 9 by @Mytherin in https://github.com/duckdb/duckdb/pull/11225
• Flatten Rewrite by @maiadegraaf in https://github.com/duckdb/duckdb/pull/11223
• ORDER BY ColumnNumber with Collations by @tiagokepe in https://github.com/duckdb/duckdb/pull/11139
• Fix differences to implementation for to_parquet, write_parquet, to_csv, write_csv, Expression.alias, DuckDBPyRelation.map by @binste in https://github.com/duckdb/duckdb/pull/11135
• Issue template: Ask for MWEs by @szarnyasg in https://github.com/duckdb/duckdb/pull/11192
• Cleaning up FSST: Remove unused AVX512 code by @hannes in https://github.com/duckdb/duckdb/pull/11222
• Fix #11211 - correctly fill in string_t padding for bit type by @Mytherin in https://github.com/duckdb/duckdb/pull/11231
• Fix #3391: Stop creating background threads if the thread constructor throws an exception by @Mytherin in https://github.com/duckdb/duckdb/pull/11236
• R_CMD_CHECK: Pin to duckdb/duckdb-r 0ed106a71c by @carlopi in https://github.com/duckdb/duckdb/pull/11245
• Add support for HEX(BLOB) by @Mytherin in https://github.com/duckdb/duckdb/pull/11243
• Remove no_vector_verification in Map Subscript Test by @maiadegraaf in https://github.com/duckdb/duckdb/pull/11242
• Update logos in README by @szarnyasg in https://github.com/duckdb/duckdb/pull/11256
• Ignore user defined parameters that change names or types of csv columns in sniffer's prompt. by @pdet in https://github.com/duckdb/duckdb/pull/11257
• [Python] Fix error caused by looking up a TypeCatalogEntry without an active transaction. by @Tishj in https://github.com/duckdb/duckdb/pull/11255
• [Fix] Fuzzer issue in list_select by @taniabogatsch in https://github.com/duckdb/duckdb/pull/11248
• [Parquet] Support for LZ4 Compression by @hannes in https://github.com/duckdb/duckdb/pull/11220
• Fix #11254: Add missing includes to terminal by @Mytherin in https://github.com/duckdb/duckdb/pull/11265
• Issue #10867: AsOf Predicate Pushdown by @hawkfish in https://github.com/duckdb/duckdb/pull/11233
• Fix plan cost runner regression script by @Tmonster in https://github.com/duckdb/duckdb/pull/11129
• Check if we need to throw any remaining errors at end of CSV scanning by @pdet in https://github.com/duckdb/duckdb/pull/11276
• Allow duplicate names in json objects when ignore_errors is true by @lnkuiper in https://github.com/duckdb/duckdb/pull/11271
• Do not surround JSON with quotes in sqlite shell output by @lnkuiper in https://github.com/duckdb/duckdb/pull/11268
• add TRIM support to virtual filesystem, and implementation on linux by @jkub in https://github.com/duckdb/duckdb/pull/11258
• Perform direct write operation if input data are larger than buffer size by @quentingodeau in https://github.com/duckdb/duckdb/pull/11203
• Fuzzer fixes by @lnkuiper in https://github.com/duckdb/duckdb/pull/11286
• Compile spatial also for rtools by @carlopi in https://github.com/duckdb/duckdb/pull/11291
• allow injecting custom BufferManager implementation by @jkub in https://github.com/duckdb/duckdb/pull/11215
• Default to RECORDS in JSON reader if more than one column is specified by @lnkuiper in https://github.com/duckdb/duckdb/pull/11295
• Add support for materialized CTEs in INSERT/UPDATE/DELETE statements by @kryonix in https://github.com/duckdb/duckdb/pull/10878
• Only throw exception if je_mallctl fails in DEBUG mode by @lnkuiper in https://github.com/duckdb/duckdb/pull/11303
• Fixing casting issue in generators by @hannes in https://github.com/duckdb/duckdb/pull/11304
• Rework FileSystem::OpenFile call, and add FILE_FLAGS_NULL_IF_NOT_EXISTS by @Mytherin in https://github.com/duckdb/duckdb/pull/11297
• Fix potential UB when list() aggregate is used in combination with other arena using aggregate functions by @Maxxen in https://github.com/duckdb/duckdb/pull/11306
• Fix #11293 - for ARRAY([subquery]) explicitly push the ORDER BY of the underlying subquery into the array aggregate by @Mytherin in https://github.com/duckdb/duckdb/pull/11316
• Fix #11281: explicitly select column types of information_schema tables for all columns, even if they are always NULL by @Mytherin in https://github.com/duckdb/duckdb/pull/11317
• Fixup py upload by @carlopi in https://github.com/duckdb/duckdb/pull/11308
• Issue #11279: TIMESTAMP => TIMESTAMPTZ by @hawkfish in https://github.com/duckdb/duckdb/pull/11320
• Fix null pointer exception when rolling back updates if the rollback was caused by an OOM by @Mytherin in https://github.com/duckdb/duckdb/pull/11309
• Fix #11283 - report consistent foreign key constraint name in information_schema by @Mytherin in https://github.com/duckdb/duckdb/pull/11318
• Fix #11294 - avoid applying Filter Pushdown optimization for UNION/EXCEPT without ALL by @Mytherin in https://github.com/duckdb/duckdb/pull/11315
• Fix #10695 - handle ? prepared statement parameters correctly for POSITION(x IN y) by @Mytherin in https://github.com/duckdb/duckdb/pull/11314
• Windows CLI - emit UTF8 directly using SetConsoleOutputCP(CP_UTF8) if possible by @Mytherin in https://github.com/duckdb/duckdb/pull/11324
• Fix #11319: use modulo when computing day of the week in excel extension by @Mytherin in https://github.com/duckdb/duckdb/pull/11328
• [CI] Fix bash syntax in TwineUpload by @carlopi in https://github.com/duckdb/duckdb/pull/11333
• Fix #11284: avoid adding the same column multiple times to a primary key/unique constraint name list by @Mytherin in https://github.com/duckdb/duckdb/pull/11325
• In ColumnData, limit scan to the current count in the column by @Mytherin in https://github.com/duckdb/duckdb/pull/11329
• Issue #11269: DISTINCT Sorted Aggregates by @hawkfish in https://github.com/duckdb/duckdb/pull/11321
• [Attach] Fix bug causing sequences to break attaching databases. by @Tishj in https://github.com/duckdb/duckdb/pull/11327
• Flatten hash vector before combining list hashes by @lnkuiper in https://github.com/duckdb/duckdb/pull/11340
• Make sniffer more consistent when nullpadding/ignore_errors are on by @pdet in https://github.com/duckdb/duckdb/pull/11313
• fix(arrow): union buffer count & handle schema errors by @Mause in https://github.com/duckdb/duckdb/pull/11326
• fix duckdb-r script by @Tmonster in https://github.com/duckdb/duckdb/pull/11345
• Fix regression_test_runner.py by @carlopi in https://github.com/duckdb/duckdb/pull/11346
• Issue #11234: IEJoin Scan Reset by @hawkfish in https://github.com/duckdb/duckdb/pull/11347
• TPC-H: Use BIGINT for ID fields schema where required by the specification by @szarnyasg in https://github.com/duckdb/duckdb/pull/11341
• Another round of polishing staged releases by @carlopi in https://github.com/duckdb/duckdb/pull/11342
• CI: Remove issue labeling workflow by @szarnyasg in https://github.com/duckdb/duckdb/pull/11355
• RE2 upgrade to version 2023-02-01 by @hannes in https://github.com/duckdb/duckdb/pull/11252
• File System: Add optional_ptr<FileOpener> to various calls, and add support for attaching DuckDB files over S3 by @Mytherin in https://github.com/duckdb/duckdb/pull/11343
• README: Display different logo for light/dark mode by @szarnyasg in https://github.com/duckdb/duckdb/pull/11366
• Fix bug in duckdb_bind_blob by @pfarndt in https://github.com/duckdb/duckdb/pull/11368
• Fix OSX CI by @samansmink in https://github.com/duckdb/duckdb/pull/11379
• Enable clang-tidy on headers and fix all headers to conform to our clang-tidy rules by @Mytherin in https://github.com/duckdb/duckdb/pull/11376
• Add logical_type to parameters of format_pg_type by @Flogex in https://github.com/duckdb/duckdb/pull/11369
• Issue #10965: RESPECT IGNORE NULLS by @hawkfish in https://github.com/duckdb/duckdb/pull/11372
• Fix building issues in WIN32, remove unnecessary modification. by @kindred77 in https://github.com/duckdb/duckdb/pull/11356
• Zero-initialize aggregate states with destructors immediately after allocating by @lnkuiper in https://github.com/duckdb/duckdb/pull/11360
• Update README.md by @jingshi-ant in https://github.com/duckdb/duckdb/pull/11357
• Issue #10885: Negative Window RANGEs by @hawkfish in https://github.com/duckdb/duckdb/pull/11390
• Issue #11377: Invertible TIMESTAMP_XXX Casts by @hawkfish in https://github.com/duckdb/duckdb/pull/11392
• Update init.py To export "extract_statements" function by @oomojola in https://github.com/duckdb/duckdb/pull/11394
• Internal #1657: Stricter STRUCT Casts by @hawkfish in https://github.com/duckdb/duckdb/pull/11396
• allow set readonly on attached db by @stephaniewang526 in https://github.com/duckdb/duckdb/pull/11397
• Give preference to FSSPEC defined FS by @pdet in https://github.com/duckdb/duckdb/pull/11400
• Default serialize optional_idx, add skip_default option to json_serialize_sql() by @Maxxen in https://github.com/duckdb/duckdb/pull/11405
• CI: Also label PRs as 'stale' and close them when there's no activity by @szarnyasg in https://github.com/duckdb/duckdb/pull/11420
• fix(jdbc): 1-index getBytes() by @Mause in https://github.com/duckdb/duckdb/pull/11421
• Remove redundant default descriptions by @szarnyasg in https://github.com/duckdb/duckdb/pull/11415
• clang-tidy: enable cppcoreguidelines-pro-type-const-cast by @Mytherin in https://github.com/duckdb/duckdb/pull/11414
• clang-tidy: enable cppcoreguidelines-avoid-non-const-global-variables by @Mytherin in https://github.com/duckdb/duckdb/pull/11424
• Issue #11419: Quantile Order By by @hawkfish in https://github.com/duckdb/duckdb/pull/11428
• [CSV Sniffer] Give preference to quoted candidates by @pdet in https://github.com/duckdb/duckdb/pull/11418
• clang-tidy: enable cppcoreguidelines-virtual-class-destructor by @Mytherin in https://github.com/duckdb/duckdb/pull/11437
• clang-tidy: enable cppcoreguidelines-[interfaces-global-init|slicing|rvalue-reference-param-not-moved] by @Mytherin in https://github.com/duckdb/duckdb/pull/11435
• Fix #11393 - improve error message when trying to use a lateral join column in a table function that does not support it by @Mytherin in https://github.com/duckdb/duckdb/pull/11436
• add readonly to duckdb_databases() by @stephaniewang526 in https://github.com/duckdb/duckdb/pull/11429
• Fix missing opener propagation by @quentingodeau in https://github.com/duckdb/duckdb/pull/11454
• Fix #11246: Use SetConsoleCP function to set input to UTF8 when reading by @Mytherin in https://github.com/duckdb/duckdb/pull/11452
• CLI: Add support for ".edit" or "\e" by @Mytherin in https://github.com/duckdb/duckdb/pull/11447
• Fix VS2022 Preview ClangCl build by @bodand in https://github.com/duckdb/duckdb/pull/11456
• Remove an unnecessary line from bind_insert.cpp by @huachaohuang in https://github.com/duckdb/duckdb/pull/11443
• [CI] Skip ccache for R.yml by @carlopi in https://github.com/duckdb/duckdb/pull/11459
• Improve binding of CTEs by @kryonix in https://github.com/duckdb/duckdb/pull/11399
• Move BindCreateIndex from Catalog to Binder by @philippmd in https://github.com/duckdb/duckdb/pull/11402
• [Substrait-ADBC] Fix for substrait plan execution via ADBC by @pdet in https://github.com/duckdb/duckdb/pull/11358
• Removing abort() from RE2 again because Google refuses to use exceptions by @hannes in https://github.com/duckdb/duckdb/pull/11458
• Defer allocation in read_json by @lnkuiper in https://github.com/duckdb/duckdb/pull/11378
• [ODBC] Add escape character to ParseStringFilter to support Power Query ('table_name' is escaped to 'table_name') by @guenp in https://github.com/duckdb/duckdb/pull/11432
• Bump to post-portfile change for duckdb_azure by @carlopi in https://github.com/duckdb/duckdb/pull/11476
• Reduce memory usage of DELETE operations by @Mytherin in https://github.com/duckdb/duckdb/pull/11470
• Use optional_idx in more places by @Mytherin in https://github.com/duckdb/duckdb/pull/11466
• Revert "Move BindCreateIndex from Catalog to Binder" by @Mytherin in https://github.com/duckdb/duckdb/pull/11478
• [Arrow] Throw on invalid STRUCT type by @Tishj in https://github.com/duckdb/duckdb/pull/11464
• [Dev] Do not use CatalogEntry references inside Dependency objects. by @Tishj in https://github.com/duckdb/duckdb/pull/11408
• Fix extension builds by @carlopi in https://github.com/duckdb/duckdb/pull/11486
• [Fix] Throw BinderException for UNNEST expressions in WINDOW expressions by @taniabogatsch in https://github.com/duckdb/duckdb/pull/11247
• Check for IUTF8 flag defined before setting it by @patmaddox in https://github.com/duckdb/duckdb/pull/11488
• Fix #11445: correctly detect recursive aliases when using struct unnest by @Mytherin in https://github.com/duckdb/duckdb/pull/11497
• Fix #11444: avoid using recursion in string -> list parsing by @Mytherin in https://github.com/duckdb/duckdb/pull/11498
• Add serialization for LogicalCopyDatabase operator by @Flogex in https://github.com/duckdb/duckdb/pull/11401
• add support in Julia appender for missing and nothing values by @rdavis120 in https://github.com/duckdb/duckdb/pull/11508
• [Python] Produce datetime.time values when converting TIME columns to Pandas DataFrame by @Tishj in https://github.com/duckdb/duckdb/pull/11468
• [Fix][ADBC] Implement required ADBCConnectionGetObjects schema by @joellubi in https://github.com/duckdb/duckdb/pull/11446
• Add support for decimal modulo operation by @Mytherin in https://github.com/duckdb/duckdb/pull/11506
• Move CompressedMaterialization inside of StatisticsPropagator by @lnkuiper in https://github.com/duckdb/duckdb/pull/11495
• Bump stale bot version by @szarnyasg in https://github.com/duckdb/duckdb/pull/11509
• Rework issue workflow by @Mytherin in https://github.com/duckdb/duckdb/pull/11522
• [RE2] Add includes and remove potential throw from destructor by @carlopi in https://github.com/duckdb/duckdb/pull/11513
• Issue #11292: Nested Boolean Compares by @hawkfish in https://github.com/duckdb/duckdb/pull/11496
• [Dev] Initialize new buffers with garbage data if DESTROY_UNPINNED_BLOCKS is set by @Tishj in https://github.com/duckdb/duckdb/pull/11270
• Fix timeout in async workflow by @samansmink in https://github.com/duckdb/duckdb/pull/11525
• Move assertion in json_scan.cpp by @lnkuiper in https://github.com/duckdb/duckdb/pull/11530
• Issue #11518: TryParseTime by @hawkfish in https://github.com/duckdb/duckdb/pull/11519
• Fuzzer Bugfixes by @Maxxen in https://github.com/duckdb/duckdb/pull/11544
• [CI] Fix CI failure on C Enum Integrity Check by @Tishj in https://github.com/duckdb/duckdb/pull/11547
• [ICU] Use the correct lookup precedence for TimeZone settings by @Tishj in https://github.com/duckdb/duckdb/pull/11546
• [CI] Move from default GITHUB_TOKEN to specific one by @carlopi in https://github.com/duckdb/duckdb/pull/11556
• [CI] Fix Deploy step to execute only for duckdb organization by @carlopi in https://github.com/duckdb/duckdb/pull/11553
• Rework RadixPartitionHashTable task assignment in source phase by @lnkuiper in https://github.com/duckdb/duckdb/pull/11528
• Run new micro benchmarks in CI when they are added by @Tmonster in https://github.com/duckdb/duckdb/pull/11532
• Rework vector_hash for ARRAYs by @Maxxen in https://github.com/duckdb/duckdb/pull/11558
• [Dev] Add assertions around Uncompressed String storage by @Tishj in https://github.com/duckdb/duckdb/pull/11267
• python: Add missing global options to write_csv by @jzavala-gonzalez in https://github.com/duckdb/duckdb/pull/10382
• [Python] Fix issue with lists containing dictionaries of different sizes by @Tishj in https://github.com/duckdb/duckdb/pull/11095
• [Dev][Python] Add nightly test to execute all sqllogic tests using the python package by @Tishj in https://github.com/duckdb/duckdb/pull/11137
• Parquet Writer: Early out creating dictionary by @lnkuiper in https://github.com/duckdb/duckdb/pull/11461
• ODBC driver should ignore "driver" and "trusted_connection" keywords in connection string by @guenp in https://github.com/duckdb/duckdb/pull/11382
• [ODBC] Fix: Support loading UTF-8 encoded data with Power BI by @guenp in https://github.com/duckdb/duckdb/pull/11423
• Draft permissions - bot does not have permission for drafting by @Mytherin in https://github.com/duckdb/duckdb/pull/11575
• CI: Remove 'needs reproducible example' when 'reproduced' label is applied by @szarnyasg in https://github.com/duckdb/duckdb/pull/11576
• Various fixes & clean-up around STRUCT UNNEST by @Mytherin in https://github.com/duckdb/duckdb/pull/11580
• Update token by @Mytherin in https://github.com/duckdb/duckdb/pull/11592
• Update issue template by @szarnyasg in https://github.com/duckdb/duckdb/pull/11577
• [CI] Remove GITHUB_PAT variable from R-CMD-check by @carlopi in https://github.com/duckdb/duckdb/pull/11593
• Respect read-only mode in dbgen and dsdgen by @Mytherin in https://github.com/duckdb/duckdb/pull/11585
• Bump-back duckdb_azure to pre-lzma custom vcpkg-port by @carlopi in https://github.com/duckdb/duckdb/pull/11595
• Correctly handle database names with quotes in USE statement by @Mytherin in https://github.com/duckdb/duckdb/pull/11587
• Bump postgres version and build arrow also for windows by @carlopi in https://github.com/duckdb/duckdb/pull/11604
• Support reading gzipped files in the test runner by @chrisiou in https://github.com/duckdb/duckdb/pull/11600
• initializes unknown indexes on catalog lookup by @Maxxen in https://github.com/duckdb/duckdb/pull/11551
• Fix Progress Bar for many large CSV Files + Adjustment to not store buffers from compressed files over single threaded scans by @pdet in https://github.com/duckdb/duckdb/pull/11273
• CSV Rejects Tables 2.0 by @pdet in https://github.com/duckdb/duckdb/pull/11512
• Fix topn placement by @Tmonster in https://github.com/duckdb/duckdb/pull/11601
• Fix various issues found by oss-fuzz by @Mytherin in https://github.com/duckdb/duckdb/pull/11613
• [ODBC] Fix: timestamps and times are parsed as dates by Power Query by @guenp in https://github.com/duckdb/duckdb/pull/11610
• Fix various fuzzer issues, move fuzzer scripts into this repo, and expand reduce_sql_statement to improve test case reduction capabilities of fuzzer by @Mytherin in https://github.com/duckdb/duckdb/pull/11622
• [Dev] Make the extension_entries.hpp generation script more modular by @Tishj in https://github.com/duckdb/duckdb/pull/11623
• [Fix][ADBC] Don't filter system catalogs/schemas in ConnectionGetObjects by @joellubi in https://github.com/duckdb/duckdb/pull/11618
• Add pyodide wheel building github action by @cpcloud in https://github.com/duckdb/duckdb/pull/11531
• Move away from dynamic_cast to Cast<> infrastructure by @carlopi in https://github.com/duckdb/duckdb/pull/11619
• Extension Metadata by @carlopi in https://github.com/duckdb/duckdb/pull/11515
• [Dev] Regenerate query string for IndexCatalogEntry. by @Tishj in https://github.com/duckdb/duckdb/pull/11462
• Upload pyodide by @carlopi in https://github.com/duckdb/duckdb/pull/11626
• Add docker alpine build to check on builds by @carlopi in https://github.com/duckdb/duckdb/pull/11490
• Add Vector Similarity Search (VSS) Extension by @Maxxen in https://github.com/duckdb/duckdb/pull/11614
• Metadata fix by @carlopi in https://github.com/duckdb/duckdb/pull/11629
• Fix extension config for arrow, remove patch from sqlite by @carlopi in https://github.com/duckdb/duckdb/pull/11628
• [CSV Reader] Resets the buffer manager over recursive scans by @pdet in https://github.com/duckdb/duckdb/pull/11631
• Make path to append_metadata.cmake relative to top-level CMakeLists.txt by @Flogex in https://github.com/duckdb/duckdb/pull/11635
• [CSV Reader] Fixes an issue with conflicting strategies for buffer cleaning by @pdet in https://github.com/duckdb/duckdb/pull/11630
• Fix more issues found by the fuzzer, extend SQL reduction further by @Mytherin in https://github.com/duckdb/duckdb/pull/11642
• fix(jdbc): support non-string parameter types by @Mause in https://github.com/duckdb/duckdb/pull/11646
• Few more fuzzer fixes by @Mytherin in https://github.com/duckdb/duckdb/pull/11648
• Bump spatial by @Maxxen in https://github.com/duckdb/duckdb/pull/11650
• Avoid performing Apple codesign on extensions by @carlopi in https://github.com/duckdb/duckdb/pull/11652
• Filter out single relation predicates before join ordering by @wangxiaoying in https://github.com/duckdb/duckdb/pull/11645
• Fix last_value in the duckdb_sequences metadata function by @Tishj in https://github.com/duckdb/duckdb/pull/11465
• Limit batch insert threads based on available memory, similar to Parquet write by @Mytherin in https://github.com/duckdb/duckdb/pull/11655
• [Vacuum] Fix serialization and Copy of the VacuumStatement by @Tishj in https://github.com/duckdb/duckdb/pull/11656
• More index initialization by @Maxxen in https://github.com/duckdb/duckdb/pull/11659
• Skip tests with the unzip keyword in python and disable unzip.test for 32bit systems by @chrisiou in https://github.com/duckdb/duckdb/pull/11658
• Bump extension versions, remove patches by @carlopi in https://github.com/duckdb/duckdb/pull/11662
• Accept a list of multiple nullstring values for CSV Files by @pdet in https://github.com/duckdb/duckdb/pull/11616
• Include falloc to fix build on some Linux systems by @zmbc in https://github.com/duckdb/duckdb/pull/11663
• Fix #11469 - make unnest parameters case-insensitive by @Mytherin in https://github.com/duckdb/duckdb/pull/11667
• Fix #11467: correctly merge unnamed structs and structs in CombineEqualTypes by @Mytherin in https://github.com/duckdb/duckdb/pull/11668
• Skip ADBC tests if python version is not 3.9 or higher by @pdet in https://github.com/duckdb/duckdb/pull/11653
• Fix #11621 - correctly zero-initialize padding bits in bitpacking compression by @Mytherin in https://github.com/duckdb/duckdb/pull/11671
• Fix #11542 - correctly check if a column data segment has updates, and clean up the updates by @Mytherin in https://github.com/duckdb/duckdb/pull/11670
• Make UNION BY NAME also use ForceMaxLogicalType, similar to UNION by @Mytherin in https://github.com/duckdb/duckdb/pull/11665
• Fix extension_version propagation for external extensions by @carlopi in https://github.com/duckdb/duckdb/pull/11672
• Allow decimal type in CSV auto_type_candidates option by @pdet in https://github.com/duckdb/duckdb/pull/11675
• Fix #11484: support constant indexes in ARRAY - e.g. ARRAY(SELECT .. ORDER BY 1) by @Mytherin in https://github.com/duckdb/duckdb/pull/11674
• Improve hive type auto-casting so that it looks at all files instead of only the first file by @Mytherin in https://github.com/duckdb/duckdb/pull/11676
• Fix #11669: deduplicate column names in pivot correctly by @Mytherin in https://github.com/duckdb/duckdb/pull/11678
• Disable setting console pages by default, and add .utf8 setting by @Mytherin in https://github.com/duckdb/duckdb/pull/11682
• bump vss, handle reverting append when index is unknown by @Maxxen in https://github.com/duckdb/duckdb/pull/11681

Full Changelog: https://github.com/duckdb/duckdb/compare/v0.10.1...v0.10.2

This is a bug fix release for various issues discovered after we released 0.10.0. There are no new features, just bug fixes. Database files created by DuckDB v0.10.0 or v0.9.* can be read by DuckDB v0.10.1.

What's Changed

• Remove visualizer leftovers by @Y-- in https://github.com/duckdb/duckdb/pull/10642
• Add explicit numbering to C enums + various compilation/CI fixes by @Mytherin in https://github.com/duckdb/duckdb/pull/10649
• Disable print method for CSV scanner for R build by @hannes in https://github.com/duckdb/duckdb/pull/10650
• Fix #10548 for the DUCKDB_NO_THREADS case by @carlopi in https://github.com/duckdb/duckdb/pull/10654
• Allow StorageExtension to extend DuckCatalog implementation in order to integration with observability system by @bleskes in https://github.com/duckdb/duckdb/pull/10643
• Update storage info for v0.10.0 by @szarnyasg in https://github.com/duckdb/duckdb/pull/10660
• Revamp duckdb-wasm extensions CI by @carlopi in https://github.com/duckdb/duckdb/pull/10672
• [CI] Re-enable skipped test window-rows-overflow.test by @Tishj in https://github.com/duckdb/duckdb/pull/10679
• Catch: prominently display skipped tests by @Mytherin in https://github.com/duckdb/duckdb/pull/10669
• Update Julia to 0.10.0 by @Mytherin in https://github.com/duckdb/duckdb/pull/10689
• Ingestion benchmark framework by @Tmonster in https://github.com/duckdb/duckdb/pull/10341
• [ICU] Add casts from Timestamp_* to TimestampTZ by @Tishj in https://github.com/duckdb/duckdb/pull/9539
• DISTINCT ON - greatly improve performance by rewriting ordered FIRST aggregate into arg_min_null by @Mytherin in https://github.com/duckdb/duckdb/pull/10684
• Fix #10685 - support aliases in join clause by @Mytherin in https://github.com/duckdb/duckdb/pull/10691
• Use assertThrows for throwing assertions in JDBC tests by @peteraisher in https://github.com/duckdb/duckdb/pull/10448
• Casts: report error location in query for failed casts by @Mytherin in https://github.com/duckdb/duckdb/pull/10694
• Fix duckdb spelling in _extension_deploy.yml by @carlopi in https://github.com/duckdb/duckdb/pull/10717
• Fuzzer #1374: ARG_XXX By Decimal by @hawkfish in https://github.com/duckdb/duckdb/pull/10728
• [Python] Rework the python regression test script by @Tishj in https://github.com/duckdb/duckdb/pull/10715
• Removes static member string by @TinyTinni in https://github.com/duckdb/duckdb/pull/10733
• Fuzzer #1372: Order Bind Failure by @hawkfish in https://github.com/duckdb/duckdb/pull/10727
• Fuzzer #1380: To Weeks Overflow by @hawkfish in https://github.com/duckdb/duckdb/pull/10726
• Various fixes by @carlopi in https://github.com/duckdb/duckdb/pull/10708
• Unittest does not satify assertion on MSVC/Debug by @TinyTinni in https://github.com/duckdb/duckdb/pull/10738
• Fix OrderPreservationType issue of MATERIALIZED CTEs by @kryonix in https://github.com/duckdb/duckdb/pull/10587
• Map creation fixes and refactoring by @taniabogatsch in https://github.com/duckdb/duckdb/pull/10436
• Fuzzer #1383: NULL Range Arguments by @hawkfish in https://github.com/duckdb/duckdb/pull/10723
• Fuzzer #1382: Window Stats Overflow by @hawkfish in https://github.com/duckdb/duckdb/pull/10725
• Comment on view columns by @samansmink in https://github.com/duckdb/duckdb/pull/10710
• Union exclude by @Tmonster in https://github.com/duckdb/duckdb/pull/10688
• move the logic for immediate_transaction_mode to the physical operator by @peterboncz in https://github.com/duckdb/duckdb/pull/10739
• [C API] Small fix and more tests by @taniabogatsch in https://github.com/duckdb/duckdb/pull/10748
• List_slice bug fix by @maiadegraaf in https://github.com/duckdb/duckdb/pull/10747
• Enable azure autoload by @samansmink in https://github.com/duckdb/duckdb/pull/10746
• Parquet writer - reduce memory usage of order-preserving write by @Mytherin in https://github.com/duckdb/duckdb/pull/10756
• Refactor csv reader includes because of r path length limitations by @hannes in https://github.com/duckdb/duckdb/pull/10658
• Arrow String View Type by @pdet in https://github.com/duckdb/duckdb/pull/10481
• local_file_system.cpp: minor fix for macOS libproc code by @barracuda156 in https://github.com/duckdb/duckdb/pull/10758
• Make unnamed_subquery naming predictable by @Mytherin in https://github.com/duckdb/duckdb/pull/10765
• [Python] Fix overflow issue in PandasAnalyzer by @Tishj in https://github.com/duckdb/duckdb/pull/10768
• Throw when trying to consume over 128 byte decimals by @pdet in https://github.com/duckdb/duckdb/pull/10601
• CLI: Right-align numerics in markdown tables by @Mytherin in https://github.com/duckdb/duckdb/pull/10767
• Fuzzer #1399: Window NULL RANGE by @hawkfish in https://github.com/duckdb/duckdb/pull/10776
• [CSV Sniffer] Minor sniffer tweak to give preference to dialects that generate the least errors if ignore_errors = true by @pdet in https://github.com/duckdb/duckdb/pull/10777
• Add large benchmark directory by @Tmonster in https://github.com/duckdb/duckdb/pull/10763
• Improve UNPIVOT error messages, and allow expressions in unpivot by @Mytherin in https://github.com/duckdb/duckdb/pull/10773
• Add a method UUID::FromUHugeint to generate a UUID from a uhugeint_t by @Mytherin in https://github.com/duckdb/duckdb/pull/10771
• [CSV Reader] Add lock to buffer reset by @pdet in https://github.com/duckdb/duckdb/pull/10791
• [WINDOWS] Add "/bigobj" that solves compile issue during debug by @maiadegraaf in https://github.com/duckdb/duckdb/pull/10782
• fix: not over-call AllSecrets by @stephaniewang526 in https://github.com/duckdb/duckdb/pull/10807
• Update readme by @szarnyasg in https://github.com/duckdb/duckdb/pull/10814
• [ODBC] Rework Connect to the ODBC driver and add functionality to set all DuckDB configurations in the Connection String by @maiadegraaf in https://github.com/duckdb/duckdb/pull/10692
• Fix arrow conversion, map doesn't support large offset by @yiyuanliu in https://github.com/duckdb/duckdb/pull/10796
• [CSV Reader] Spinlock over GetLine Error + New Strategy for dialect candidates by @pdet in https://github.com/duckdb/duckdb/pull/10755
• Trivial fixes by @carlopi in https://github.com/duckdb/duckdb/pull/10816
• Fix unicode handling in underscore of LIKE operator by @Mytherin in https://github.com/duckdb/duckdb/pull/10821
• JDBC spurious CI failure - an exception being thrown in this test is a race condition by @Mytherin in https://github.com/duckdb/duckdb/pull/10825
• Benchmark runner - allow files (e.g. CSV/Parquet) to be cached using the cache command by @Mytherin in https://github.com/duckdb/duckdb/pull/10817
• Fix #10803 - correctly reclaim space of list indexes when columns are dropped by @Mytherin in https://github.com/duckdb/duckdb/pull/10822
• [Upsert] INSERT OR REPLACE fixes by @Tishj in https://github.com/duckdb/duckdb/pull/10789
• [Dev] Add an optional time out in seconds to run_tests_one_by_one.py by @Tishj in https://github.com/duckdb/duckdb/pull/10744
• Maintain names in COLUMNS(*) expression, and allow aliasing multiple columns using {column} by @Mytherin in https://github.com/duckdb/duckdb/pull/10774
• Disable AWS/Azure on Windows for now by @Mytherin in https://github.com/duckdb/duckdb/pull/10827
• [Dev] Bump memory limit on batch_memory_usage.test_slow by @carlopi in https://github.com/duckdb/duckdb/pull/10845
• Fix coverity apt-get by @carlopi in https://github.com/duckdb/duckdb/pull/10838
• minor: FixedSizeBuffer::Pin move shared_ptr rather than copying by @mapleFU in https://github.com/duckdb/duckdb/pull/10837
• ci: Upgrade workflows to actions/setup-python@v5 by @krlmlr in https://github.com/duckdb/duckdb/pull/10832
• Fuzzer #1389: ARG_XXX Decimal Casts by @hawkfish in https://github.com/duckdb/duckdb/pull/10742
• Contributor guide: Fix new issue link by @szarnyasg in https://github.com/duckdb/duckdb/pull/10836
• Changing source to src in relational_constraints query by @Dtenwolde in https://github.com/duckdb/duckdb/pull/10848
• Fix: correctly calculate the range of build side for perfect hash join by @gitccl in https://github.com/duckdb/duckdb/pull/10446
• [Python] Fix issue caused by deadlock between thread.join() and acquiring the GIL by @Tishj in https://github.com/duckdb/duckdb/pull/10854
• [CSV Parser] 8-Byte Skipping instead of 1-Byte when possible by @pdet in https://github.com/duckdb/duckdb/pull/10855
• Add components of the version to duckdb.hpp by @ahuarte47 in https://github.com/duckdb/duckdb/pull/10840
• [CSV Sniffer] Tweaking header detection by @pdet in https://github.com/duckdb/duckdb/pull/10714
• Check if directory exists before removing files in regression test runner by @Tmonster in https://github.com/duckdb/duckdb/pull/10859
• [Extension] Add CatalogType to the list of functions generated in extension_entries.hpp by @Tishj in https://github.com/duckdb/duckdb/pull/10597
• Regression test build side probe side by @Tmonster in https://github.com/duckdb/duckdb/pull/10585
• [Arrow] Fix issue surrounding lifetime of dictionary arrays by @Tishj in https://github.com/duckdb/duckdb/pull/10610
• Fix #10745 - correctly deal with empty float columns in floating point compression routines by @Mytherin in https://github.com/duckdb/duckdb/pull/10863
• [Extensions] Build fixes by @carlopi in https://github.com/duckdb/duckdb/pull/10860
• Fix MSVC linking issue with workaround by @samansmink in https://github.com/duckdb/duckdb/pull/10865
• Reduce memory usage & avoid spilling to disk unnecessarily for order-preserving table creation/insertion by @Mytherin in https://github.com/duckdb/duckdb/pull/10862
• pb/avoid GetSchema opening a transaction by @peterboncz in https://github.com/duckdb/duckdb/pull/10740
• Support dollar-quoted string-constants in the CLI by @Mytherin in https://github.com/duckdb/duckdb/pull/10879
• Shell: avoid printing "Error: " prefix if the error message already has a prefix (e.g. Binder Error:, Parser Error:, etc) by @Mytherin in https://github.com/duckdb/duckdb/pull/10880
• Partially fix #10751: correctly catch exceptions in sqlite3_print_duckbox by @Mytherin in https://github.com/duckdb/duckdb/pull/10881
• Reset refresh in CompressedFile::Close() by @Maxxen in https://github.com/duckdb/duckdb/pull/10882
• [CSV Reader] Lock when getting progress by @pdet in https://github.com/duckdb/duckdb/pull/10884
• [CSV Sniffer] Early out if things go wrong in dialect detection by @pdet in https://github.com/duckdb/duckdb/pull/10872
• [CSV Reader] Fix for skipping mix of newline delimiters by @pdet in https://github.com/duckdb/duckdb/pull/10864
• Parallelize format.py script by @hatvik in https://github.com/duckdb/duckdb/pull/10646
• Remove Old PSQLODBC scripts by @maiadegraaf in https://github.com/duckdb/duckdb/pull/10888
• Add update_odbc_path.py to ODBC bundle by @maiadegraaf in https://github.com/duckdb/duckdb/pull/10895
• Improve Wasm.yml workflow by @carlopi in https://github.com/duckdb/duckdb/pull/10899
• [Parquet] Fix #10829, write correct data page offset in the presence of dictionaries by @hannes in https://github.com/duckdb/duckdb/pull/10890
• Table name binding does not fail for non-existent tables in DROP TABLE statements by @NiclasHaderer in https://github.com/duckdb/duckdb/pull/10893
• Fix #10889 - correctly deal with compressed vectors in struct filterpushdown of ColumnSegment::FilterSelection by @Mytherin in https://github.com/duckdb/duckdb/pull/10896
• CI: Disable julia nightly for now by @Mytherin in https://github.com/duckdb/duckdb/pull/10905
• CLI - add support for rendering errors/matching brackets for square ([]) and curly ({}) brackets as well by @Mytherin in https://github.com/duckdb/duckdb/pull/10904
• Storage: Fix an internal exception that could be triggered when deleting many rows and checkpointing repeatedly by @Mytherin in https://github.com/duckdb/duckdb/pull/10897
• LIMIT/OFFSET clean-up by @Mytherin in https://github.com/duckdb/duckdb/pull/10873
• Add ARRAY to test_all_types + IO and some clients by @Maxxen in https://github.com/duckdb/duckdb/pull/10850
• Use M1 (ARM) OSX runners by @hannes in https://github.com/duckdb/duckdb/pull/10670
• build: restore tarball build support by @Mause in https://github.com/duckdb/duckdb/pull/10900
• Fix #10902 - allow more expressions to be used with an indirection without brackets (. or [], etc) by @Mytherin in https://github.com/duckdb/duckdb/pull/10909
• feat(jdbc): fixed size array support by @Mause in https://github.com/duckdb/duckdb/pull/10911
• Add regexp_split_to_table macro by @szarnyasg in https://github.com/duckdb/duckdb/pull/10898
• [MetaTransaction] Add lock on modifying all_transactions and transactions by @Tishj in https://github.com/duckdb/duckdb/pull/10799
• Issue #10809: RANGE Hint Corrections by @hawkfish in https://github.com/duckdb/duckdb/pull/10828
• Enable the progress bar (without printing) in unittests by @Mytherin in https://github.com/duckdb/duckdb/pull/10908
• [Python][Dev] Fix issue in read_csv related to the s3 extension by @Tishj in https://github.com/duckdb/duckdb/pull/10690
• Add support for the C API duckdb_query function to the Julia api by @rdavis120 in https://github.com/duckdb/duckdb/pull/10886
• Fix #10501 - in LocalFileSystem::Write split writes into batches of at most 2GB by @Mytherin in https://github.com/duckdb/duckdb/pull/10912
• Correctly reset data chunk in RETURNING of DELETE by @Mytherin in https://github.com/duckdb/duckdb/pull/10915
• bitstring_agg had a trigger-able assertion, [duckdb-fuzzer/#1414] by @hannes in https://github.com/duckdb/duckdb/pull/10918
• Shell: Remove IEE754 function from CLI by @Mytherin in https://github.com/duckdb/duckdb/pull/10919
• Use correct index in string to nested cast error handling by @Mytherin in https://github.com/duckdb/duckdb/pull/10920
• Batch memory manager - keep track of all used memory correctly and enforce that unflushed memory is correctly set to 0 when we are finished by @Mytherin in https://github.com/duckdb/duckdb/pull/10922
• Fix #9975 - correctly open (and keep open) a transaction when checking if prepared statement needs to be rebound by @Mytherin in https://github.com/duckdb/duckdb/pull/10923
• CLI - Insert spaces when copy-pasting tabs by @Mytherin in https://github.com/duckdb/duckdb/pull/10924
• feat: exposing ssl ca cert path to httpfs by @pvaezi in https://github.com/duckdb/duckdb/pull/10704
• Centralize dynamic cast check and disable on MacOS by @Mytherin in https://github.com/duckdb/duckdb/pull/10925
• Checked Numeric Casts by @hannes in https://github.com/duckdb/duckdb/pull/10870
• Avoid running numeric cast checks when CRASH_ON_ASSERT is enabled by @Mytherin in https://github.com/duckdb/duckdb/pull/10942
• Set duckdb_api to 'python jupyter' if in Jupyter notebook by @guenp in https://github.com/duckdb/duckdb/pull/10931
• Array fuzzer issue fixes by @Maxxen in https://github.com/duckdb/duckdb/pull/10944
• Fix assertion trigger in FilterCombiner::AddTransitiveFilters by @Mytherin in https://github.com/duckdb/duckdb/pull/10941
• Support recursive describe queries (i.e. DESCRIBE(DESCRIBE ..)) by @Mytherin in https://github.com/duckdb/duckdb/pull/10945
• Avoid throwing null pointer exception in Window Segment Tree destructor by @Mytherin in https://github.com/duckdb/duckdb/pull/10937
• Fix an issue where partitions were not correctly considered in bound window expression equality by @Mytherin in https://github.com/duckdb/duckdb/pull/10939
• Fix for limit % with subquery on an empty table by @Mytherin in https://github.com/duckdb/duckdb/pull/10946
• Correctly visit all expressions during lateral join decorrelation, particularly with nested lateral joins by @Mytherin in https://github.com/duckdb/duckdb/pull/10936
• when you add the relation, make sure you call gettableIndexes() on th… by @Tmonster in https://github.com/duckdb/duckdb/pull/10949
• Internal #1428: Interval Subtract Overflow by @hawkfish in https://github.com/duckdb/duckdb/pull/10957
• Fuzzer #1445: Trap MAKE_DATE/TIME Overflows by @hawkfish in https://github.com/duckdb/duckdb/pull/10958
• Python.yml: Revert to macos-latest for OSX workflow by @carlopi in https://github.com/duckdb/duckdb/pull/10970
• Purge queue refactor by @taniabogatsch in https://github.com/duckdb/duckdb/pull/10594
• Change time from duckdb_time to duckdb_time_struct in duckdb_time_tz_struct by @Giorgi in https://github.com/duckdb/duckdb/pull/10933
• Add require block_sizes 262144 on tests reading db files by @carlopi in https://github.com/duckdb/duckdb/pull/10974
• [duckdb-fuzzer/#1368] - overflow in bitstring_agg on hugeint & uhugei… by @hannes in https://github.com/duckdb/duckdb/pull/10971
• Fix LIST->ARRAY TRY_CAST when list sizes mismatch by @Maxxen in https://github.com/duckdb/duckdb/pull/10973
• Add a micro extended benchmark. by @Tmonster in https://github.com/duckdb/duckdb/pull/10943
• [Dev] Move TemporaryFileManager and friends out of StandardBufferManager by @Tishj in https://github.com/duckdb/duckdb/pull/10938
• [ODBC] Reorganize Directory Structure by @maiadegraaf in https://github.com/duckdb/duckdb/pull/10979
• Internal #1385: Window Partition Collation by @hawkfish in https://github.com/duckdb/duckdb/pull/10985
• Fuzzer #1471: Trap MAKE_DATE Overflows by @hawkfish in https://github.com/duckdb/duckdb/pull/10987
• Range checks for ACOS by @hannes in https://github.com/duckdb/duckdb/pull/10972
• improve CheckBoundaryValues in TopN by @xuke-hat in https://github.com/duckdb/duckdb/pull/10955
• CSV tests - use TEST_DIR to prevent leaking file by @Mytherin in https://github.com/duckdb/duckdb/pull/10991
• Autoload INET and ICU (and add back sqlite and postgres as autoloadable) by @carlopi in https://github.com/duckdb/duckdb/pull/10948
• Fuzzer #1468: Window RANGE Types by @hawkfish in https://github.com/duckdb/duckdb/pull/10990
• Fuzzer #1446: Quantile Hugeint Interpolation by @hawkfish in https://github.com/duckdb/duckdb/pull/10983
• Override git hash / git version by @carlopi in https://github.com/duckdb/duckdb/pull/10977
• [Storage] Only call FinalizeOptimisticWriter after storage merge has succeeded by @Mytherin in https://github.com/duckdb/duckdb/pull/10998
• Add MetaTransaction::GetTransaction to threadsan suppressions (false positive) by @Mytherin in https://github.com/duckdb/duckdb/pull/11001
• Various fixes: CMake + generated extension_entries.hpp checks by @carlopi in https://github.com/duckdb/duckdb/pull/10994
• Nightly Wasm build fix by @taniabogatsch in https://github.com/duckdb/duckdb/pull/10993
• Fix return null constant in array_slice and other array issues by @Maxxen in https://github.com/duckdb/duckdb/pull/10992
• Add correct table bindings for window relations. by @Tmonster in https://github.com/duckdb/duckdb/pull/10997
• Clean up ExecutorTask and simplify waiting for all tasks to be cancelled by @Mytherin in https://github.com/duckdb/duckdb/pull/11005
• Various JSON thread sanitizer fixes by @Mytherin in https://github.com/duckdb/duckdb/pull/11004
• Fix warnings in ALP and logical_insert by @carlopi in https://github.com/duckdb/duckdb/pull/11008
• Check IsLoaded() before importing cached item by @Tmonster in https://github.com/duckdb/duckdb/pull/11007
• Issue #10995: ICU VARCHAR TIMETZ by @hawkfish in https://github.com/duckdb/duckdb/pull/11002
• Fix #10982 - only update total rows of row group collection after we finish appending to prevent other readers from attempting to initialize scans on in-progress appends by @Mytherin in https://github.com/duckdb/duckdb/pull/11011
• [Nightly] Block size nightly test changes by @taniabogatsch in https://github.com/duckdb/duckdb/pull/11010
• ATTACH with reserved names (temp/main) by @Mytherin in https://github.com/duckdb/duckdb/pull/11020
• Fix various tests for vector_size = 2 by @Mytherin in https://github.com/duckdb/duckdb/pull/11027
• [CI] Create a bigger table in interrupt test by @Mytherin in https://github.com/duckdb/duckdb/pull/11025
• Issue #10995: TIMETZ DST Fix by @hawkfish in https://github.com/duckdb/duckdb/pull/11024
• Fixup LinuxRelease.yml release: unittester was not invoked correctly by @carlopi in https://github.com/duckdb/duckdb/pull/11022
• In DatabaseInstance destructor - destroy TaskScheduler first by @Mytherin in https://github.com/duckdb/duckdb/pull/11021
• Refactor ATTACH options by @taniabogatsch in https://github.com/duckdb/duckdb/pull/11016
• Fix #11033: don't reset arena allocator in between calls to streaming window expression by @Mytherin in https://github.com/duckdb/duckdb/pull/11039
• Avoid checking LastModifiedTime for remote files in object cache by @Mytherin in https://github.com/duckdb/duckdb/pull/11034
• [Block Size Nightly] Enable more block size nightly tests by @taniabogatsch in https://github.com/duckdb/duckdb/pull/11036
• Add missing pipeline dependencies in recursive CTE by @kryonix in https://github.com/duckdb/duckdb/pull/11043
• Use batch limit only when limit + offset are small constants by @Mytherin in https://github.com/duckdb/duckdb/pull/11035
• Add New CSV Error for Invalid Unicode by @pdet in https://github.com/duckdb/duckdb/pull/10984
• [FIX] Lambda bug in subqueries by @taniabogatsch in https://github.com/duckdb/duckdb/pull/11046
• [Swift] performance optimisations by @tcldr in https://github.com/duckdb/duckdb/pull/11052
• add concat_ws to spark API by @nicornk in https://github.com/duckdb/duckdb/pull/11051
• feat(jdbc): expose comments via jdbc methods by @Mause in https://github.com/duckdb/duckdb/pull/11031
• [CI / Tests] Disable CSV sniffer test for smaller vector sizes and reduce block-size nightly runtime by @taniabogatsch in https://github.com/duckdb/duckdb/pull/11055
• [CSV Sniffer] Consider date/timestamp formats from the user when sniffing by @pdet in https://github.com/duckdb/duckdb/pull/11057
• Extend the "Contents of view were altered" error with more information by @Tishj in https://github.com/duckdb/duckdb/pull/11064
• [Python] Add some numeric and string functions to spark API by @mariotaddeucci in https://github.com/duckdb/duckdb/pull/11067
• [ODBC] Allow multiple statements to be executed using SQLExecDirect by @maiadegraaf in https://github.com/duckdb/duckdb/pull/11038
• [CSV Reader] Apply projection on over buffer values. by @pdet in https://github.com/duckdb/duckdb/pull/11056
• Python: use short paths for Windows by @Mytherin in https://github.com/duckdb/duckdb/pull/11068
• Fix #10752: Add support for Parquet encryption on Windows by @Mytherin in https://github.com/duckdb/duckdb/pull/11069
• [Python] Code Quality - PEP8 Compliant + only relevant imports by @mariotaddeucci in https://github.com/duckdb/duckdb/pull/11070
• [CI] Add patch argument to patch the extension's sources before building by @krlmlr in https://github.com/duckdb/duckdb/pull/10831
• fix(jdbc): support fractional seconds in getTime by @Mause in https://github.com/duckdb/duckdb/pull/10707
• Fix #11071 - correctly report progress when scanning multiple Parquet files by @Mytherin in https://github.com/duckdb/duckdb/pull/11072
• Add ipv6 inet + minor fixes by @carlopi in https://github.com/duckdb/duckdb/pull/11073
• Implement IPv6 support in the inet extension. by @troycurtisjr in https://github.com/duckdb/duckdb/pull/10839
• [CI] Add step to verify C API enum integrity. by @Tishj in https://github.com/duckdb/duckdb/pull/10664
• Issue #10995: TIMETZ DST Fix by @hawkfish in https://github.com/duckdb/duckdb/pull/11079
• Check Nested Types for UTF-8 Correctness by @pdet in https://github.com/duckdb/duckdb/pull/11086
• Add scope column to duckdb_settings by @Tishj in https://github.com/duckdb/duckdb/pull/11017
• Partitioned write - flush batches periodically (every 500K rows) instead of only writing when all data has been gathered by @Mytherin in https://github.com/duckdb/duckdb/pull/10976
• [Python] Add extract_statements and the Statement class by @Tishj in https://github.com/duckdb/duckdb/pull/10891
• [Python] Improve performance of conversion to Numpy/Pandas for nested lists by @Tishj in https://github.com/duckdb/duckdb/pull/10826
• Fix an InternalException caused by DICTIONARY_VECTOR inside map_from_entries by @Tishj in https://github.com/duckdb/duckdb/pull/11091
• Fix #11084 - fixes an issue with the Parquet writer when writing vectors of lists with repeated list elements (as can be generated through a join) by @Mytherin in https://github.com/duckdb/duckdb/pull/11094
• Add callbacks for newly added connections, and allow extensions to rebind queries as a result of planning failures by @Mytherin in https://github.com/duckdb/duckdb/pull/11096
• Fuzzer #2376: INTERVAL Muliply Overflow by @hawkfish in https://github.com/duckdb/duckdb/pull/11100
• Make test/sql/copy/csv/test_limit_spinlock.test a slowtest by @pdet in https://github.com/duckdb/duckdb/pull/11088
• Fix #11063 - avoid throwing exception in InClauseRewriter by @Mytherin in https://github.com/duckdb/duckdb/pull/11090
• Add a hint on how to resolve lockups when using ninja. by @troycurtisjr in https://github.com/duckdb/duckdb/pull/11074
• Fix LocalFileSystem::Read/Write, update location after read/write some data by @yiyuanliu in https://github.com/duckdb/duckdb/pull/11105
• run_tests_one_by_one - add a default timeout of 1 hour by @Mytherin in https://github.com/duckdb/duckdb/pull/11104
• [Fix] Aliases in subqueries by @taniabogatsch in https://github.com/duckdb/duckdb/pull/11103
• [CSV Scan] Implement ignore_erros for Dates/Timestamps/Decimals by @pdet in https://github.com/duckdb/duckdb/pull/11083
• Fix TaskScheduler deadlock on NumberOfThreads by @Tishj in https://github.com/duckdb/duckdb/pull/11093
• Fix return null constant in list_resize and list_aggr by @maiadegraaf in https://github.com/duckdb/duckdb/pull/11111
• Add rowsort to more tests for queries that don't have a defined order by @Mytherin in https://github.com/duckdb/duckdb/pull/11110
• Do not extract filters that cannot be hyper edges (Join Order Optimizer) by @Tmonster in https://github.com/duckdb/duckdb/pull/11108
• Add Dictionary vector verification by @Mytherin in https://github.com/duckdb/duckdb/pull/11114
• [Dev][Python] Make test_httpfs.py error test more lenient by @Tishj in https://github.com/duckdb/duckdb/pull/11125
• Fix ConstantVector::Reference for dictionary arrays by @Maxxen in https://github.com/duckdb/duckdb/pull/11136
• Disable jemalloc for ARM distributions and clean up when closing DB by @lnkuiper in https://github.com/duckdb/duckdb/pull/11130
• Case senstivity issue secret manager by @samansmink in https://github.com/duckdb/duckdb/pull/11128
• Bump az aw vcpkg by @samansmink in https://github.com/duckdb/duckdb/pull/11127
• Fix broken micro benchmarks so they can be run weekly by @Tmonster in https://github.com/duckdb/duckdb/pull/11113
• Refactor OSX.yml, now inputs can be provided by @carlopi in https://github.com/duckdb/duckdb/pull/11133
• Merge main into feature by @Tishj in https://github.com/duckdb/duckdb/pull/11141
• Revert "Merge main into feature" by @Mytherin in https://github.com/duckdb/duckdb/pull/11145
• Fix upload assets script by @carlopi in https://github.com/duckdb/duckdb/pull/11144
• Bump spatial by @Maxxen in https://github.com/duckdb/duckdb/pull/11132
• Fix upload assets OSX/2 by @carlopi in https://github.com/duckdb/duckdb/pull/11148
• Add more vector type verification tests/settings by @Mytherin in https://github.com/duckdb/duckdb/pull/11138
• Allow for customization of catalog lookup behavior for different catalog types by @Mytherin in https://github.com/duckdb/duckdb/pull/11151
• [Python][Arrow] Don't deduplicate column names when outputting to Arrow by @Tishj in https://github.com/duckdb/duckdb/pull/11160
• More Array and Union fixes by @Maxxen in https://github.com/duckdb/duckdb/pull/11161
• Refactor upload logic (towards staged releases) by @carlopi in https://github.com/duckdb/duckdb/pull/11156
• Fuzzer #2490: Generate NULL TIMESTAMPTZ by @hawkfish in https://github.com/duckdb/duckdb/pull/11143
• Add folder parameter to upload logic and upload also twine artifacts by @carlopi in https://github.com/duckdb/duckdb/pull/11169
• CI: Find mirror issues among all issues, not just open issues by @szarnyasg in https://github.com/duckdb/duckdb/pull/11170
• Fix TupleDataCollection serialization of dictionary vectors containing nested data by @lnkuiper in https://github.com/duckdb/duckdb/pull/11174
• Allow overriding of git describe also in scripts (via OVERRIDE_GIT_DESCRIBE environment variable) by @carlopi in https://github.com/duckdb/duckdb/pull/11179
• Python staged releases: centralized staged upload by @carlopi in https://github.com/duckdb/duckdb/pull/11187
• Fix RevertAppendInternal by @Mytherin in https://github.com/duckdb/duckdb/pull/11177
• TwineUpload: Add awscli dependency + minor rework by @carlopi in https://github.com/duckdb/duckdb/pull/11193
• Fix issue in copy constructor of ExtraDropSecretInfo by @samansmink in https://github.com/duckdb/duckdb/pull/11190
• Unify CSV/JSON and Parquet Batch Writing Code - and fix memory management issues in CSV/JSON writing by @Mytherin in https://github.com/duckdb/duckdb/pull/11188
• More conservative dummy list entry estimation by @Maxxen in https://github.com/duckdb/duckdb/pull/11185
• retry on 500 error by @samansmink in https://github.com/duckdb/duckdb/pull/11184
• Fix warning on unused utf_type by @carlopi in https://github.com/duckdb/duckdb/pull/11198
• Remove outdated duckdb-node related scripts by @carlopi in https://github.com/duckdb/duckdb/pull/11180
• Add StagedUpload.yml by @carlopi in https://github.com/duckdb/duckdb/pull/11189
• Improving CSV Casting error message by @pdet in https://github.com/duckdb/duckdb/pull/11183
• Improve conversion error message in Parquet reader by @Mytherin in https://github.com/duckdb/duckdb/pull/11199
• Fix thread sanitizer issues by @Mytherin in https://github.com/duckdb/duckdb/pull/11200
• Internal #1564: Range Join DISTINCT by @hawkfish in https://github.com/duckdb/duckdb/pull/11205
• small fix secret autoloading, bump azure by @samansmink in https://github.com/duckdb/duckdb/pull/11182
• CSV reader - suggest enabling null_padding and ignore_errors in case of missing columns by @Mytherin in https://github.com/duckdb/duckdb/pull/11201
• CI: Create/label mirror issue job should list all internal issues by @szarnyasg in https://github.com/duckdb/duckdb/pull/11204
• [Python] Add IS NULL / IS NOT NULL support to Expression API by @cmdlineluser in https://github.com/duckdb/duckdb/pull/11175
• Remove old assertions in SegmentTree by @Mytherin in https://github.com/duckdb/duckdb/pull/11208
• [lambda] Fix for list_reduce giving the wrong result by @maiadegraaf in https://github.com/duckdb/duckdb/pull/11171
• [Dev] Fix various issues discovered by #11137 by @Tishj in https://github.com/duckdb/duckdb/pull/11210
• [Dev] Fix py override describe by @carlopi in https://github.com/duckdb/duckdb/pull/11209
• Sanitize CSV Newline identifier for writing CSV files by @pdet in https://github.com/duckdb/duckdb/pull/11106
• Fix persistent secret file permissions by @samansmink in https://github.com/duckdb/duckdb/pull/11172
• Retry Binding Prior To Execution by @Mytherin in https://github.com/duckdb/duckdb/pull/11149
• Avoid copying LogicalType in FlatVector::SetNull. by @yiyuanliu in https://github.com/duckdb/duckdb/pull/11214
• Review of CI on tags + add R extensions CI to InvokeCI.yml by @carlopi in https://github.com/duckdb/duckdb/pull/11212
• Fix python and apply patches + bump extensions by @carlopi in https://github.com/duckdb/duckdb/pull/11217
• Disable jemalloc on arm in Python package as well by @Mytherin in https://github.com/duckdb/duckdb/pull/11218

Full Changelog: https://github.com/duckdb/duckdb/compare/v0.10.0...v0.10.1

This is a bug fix release for various issues discovered after we released 0.9.1. There are no new features, just bug fixes. Database files created by DuckDB v0.9.0 or v0.9.1 can be read by DuckDB v0.9.2 (i.e. v0.9.2 is backwards compatible with both v0.9.0 and 0.9.1 and vice versa).

What's Changed

• [Dev] Fix Wasm.yml by @carlopi in https://github.com/duckdb/duckdb/pull/9303
• [Dev] Fix Wasm.yml, hardcoding extension config to latest duckdb-wasm by @carlopi in https://github.com/duckdb/duckdb/pull/9307
• Fix R CMD check script by @Tmonster in https://github.com/duckdb/duckdb/pull/9326
• [Dev] Remove unused tools/wasm folder by @carlopi in https://github.com/duckdb/duckdb/pull/9328
• [ODBC] SQLColAttribute fix by @maiadegraaf in https://github.com/duckdb/duckdb/pull/9316
• Fix typo by @shreeve in https://github.com/duckdb/duckdb/pull/9313
• [Dev] Trigger R.yml only only if there are changes to R.yml itself by @carlopi in https://github.com/duckdb/duckdb/pull/9304
• Add thread limit to test by @lnkuiper in https://github.com/duckdb/duckdb/pull/9305
• fix typing_extensions ImportError in experimental spark api by @Mause in https://github.com/duckdb/duckdb/pull/9346
• HTTPFS: Move from HTTPException to base class IOException by @carlopi in https://github.com/duckdb/duckdb/pull/9351
• fix for System.Data.ODBC GetSchema() by @bucweat in https://github.com/duckdb/duckdb/pull/9336
• Removes some static global variables by @TinyTinni in https://github.com/duckdb/duckdb/pull/9310
• Bump Julia to 0.9.1 by @Mytherin in https://github.com/duckdb/duckdb/pull/9354
• [Optimizer] Fix transitive filter issue by @Tishj in https://github.com/duckdb/duckdb/pull/9337
• Julia - v0.9 by @Mytherin in https://github.com/duckdb/duckdb/pull/9359
• fix time_bucket_tz(day): don't truncate input to a day boundary in https://github.com/duckdb/duckdb/pull/9320
• Increase the minimum cmake version to 3.5 by @taniabogatsch in https://github.com/duckdb/duckdb/pull/9364
• [PyArrow] Fix bug in timestamp pushdown by @Tishj in https://github.com/duckdb/duckdb/pull/9377
• Satisfy GCC's LTO checks by @krlmlr in https://github.com/duckdb/duckdb/pull/9386
• New generate_query_graph tool. by @Tmonster in https://github.com/duckdb/duckdb/pull/9212
• Fix LIST aggregate prepare statement exception by @taniabogatsch in https://github.com/duckdb/duckdb/pull/9370
• [Python] Throw explicit error for misuse of execute by @Tishj in https://github.com/duckdb/duckdb/pull/9394
• update R CMD workflow to apply patches in .github/patches/duckdb-r by @Tmonster in https://github.com/duckdb/duckdb/pull/9412
• [UnionVerify] Properly deal with SelectionVectors by @Tishj in https://github.com/duckdb/duckdb/pull/9409
• [ART] Improve error message for zero bytes in BLOBs by @taniabogatsch in https://github.com/duckdb/duckdb/pull/9415
• Enable serialization of LogicalCopyToFile by @Maxxen in https://github.com/duckdb/duckdb/pull/9418
• Nits for storage and Python API comments by @szarnyasg in https://github.com/duckdb/duckdb/pull/9414
• Issue #9416: Windowed Peer Functions by @hawkfish in https://github.com/duckdb/duckdb/pull/9425
• [Python] Adjust relation.df() to output microsecond precision for DATE types. by @Tishj in https://github.com/duckdb/duckdb/pull/9362
• [Python] Support PEP 563 by @Tishj in https://github.com/duckdb/duckdb/pull/9385
• Fix #8185 - avoid infinite recursion in AddTransitiveFilters by @Mytherin in https://github.com/duckdb/duckdb/pull/9440
• Fix 9447: SIGSEGV when executing read_csv() query for struct with empty VARCHAR by @ryderblue in https://github.com/duckdb/duckdb/pull/9448
• Fuzzer #1294: Non-Constant NULL Format by @hawkfish in https://github.com/duckdb/duckdb/pull/9450
• GitHub Actions bot: Prune search space with '--search' by @szarnyasg in https://github.com/duckdb/duckdb/pull/9445
• Issue #9396: AsOf Inequality Optimisation by @hawkfish in https://github.com/duckdb/duckdb/pull/9449
• Add bot for the 'Needs Documentation' label by @szarnyasg in https://github.com/duckdb/duckdb/pull/9444
• Fix field ids in LogicalCopyToFile:Deserialize by @Maxxen in https://github.com/duckdb/duckdb/pull/9424
• [Export Database] Produce up-to-date query for ViewCatalogEntry by @Tishj in https://github.com/duckdb/duckdb/pull/9375
• include csv_rejects_table headers for amalgamation by @Maxxen in https://github.com/duckdb/duckdb/pull/9454
• feat(jdbc): result streaming by @Mause in https://github.com/duckdb/duckdb/pull/9437
• [Arrow] Add support for dictionary's in child arrays (i.e list of ENUM) by @Tishj in https://github.com/duckdb/duckdb/pull/9331
• Detect AppleClang in cmake, add defines for DUCKDB_MAJOR/MINOR/PATCH_VERSION by @Maxxen in https://github.com/duckdb/duckdb/pull/9457
• [Dev] Fix build for extension-upload-wasm to fix (avoiding manual copy) by @carlopi in https://github.com/duckdb/duckdb/pull/9467
• Fix #9459 - remove unused qualified name parsing by @Mytherin in https://github.com/duckdb/duckdb/pull/9472
• Add license to Swift client by @szarnyasg in https://github.com/duckdb/duckdb/pull/9446
• Issue #8937: Window Order Collation by @hawkfish in https://github.com/duckdb/duckdb/pull/9477
• adding System.Data.ODBC testing to Windows.yml CI. by @bucweat in https://github.com/duckdb/duckdb/pull/9372
• fix(jdbc): support decimal arrays by @Mause in https://github.com/duckdb/duckdb/pull/9489
• Needs documentation workflow: Use correct event by @szarnyasg in https://github.com/duckdb/duckdb/pull/9464
• Needs documentation label: Add PR number in backlink by @szarnyasg in https://github.com/duckdb/duckdb/pull/9491
• Fix 9399 by @lnkuiper in https://github.com/duckdb/duckdb/pull/9411
• Enable option to skip building duckdb shell in extension distribution CI by @Maxxen in https://github.com/duckdb/duckdb/pull/9483
• fix confusing variable name by @SkyFan2002 in https://github.com/duckdb/duckdb/pull/9503
• Add MySQL Scanner Aliases + Enable Autoloading by @Mytherin in https://github.com/duckdb/duckdb/pull/9505
• Fix #9498: Amalgamation to properly define DUCKDB_VERSION by @carlopi in https://github.com/duckdb/duckdb/pull/9500
• Issue #582: Greenland TimeZone Change by @hawkfish in https://github.com/duckdb/duckdb/pull/9508
• [Union] Fix issue with keyword/quoted UNION member names. by @Tishj in https://github.com/duckdb/duckdb/pull/9432
• Dev: Avoid adding name_extension for extensions with DONT_LINK by @carlopi in https://github.com/duckdb/duckdb/pull/9496
• Implement array-based JDBC ResultSet by @elefeint in https://github.com/duckdb/duckdb/pull/8972
• Fix #9360, fix #9466: grab a lock before creating directories to fix race condition on Windows in partitioned write by @Mytherin in https://github.com/duckdb/duckdb/pull/9473
• Internal #582: Remove utc_offset Dependency by @hawkfish in https://github.com/duckdb/duckdb/pull/9521
• [ART] Don't allow index creation in readonly mode by @taniabogatsch in https://github.com/duckdb/duckdb/pull/9527
• Remove redundant class by @ccfelius in https://github.com/duckdb/duckdb/pull/9511
• Hive partitioning: Fix preprocessing of CreateDirectories by @carlopi in https://github.com/duckdb/duckdb/pull/9535
• fix: check for IsRowId before accessing column name by @stephaniewang526 in https://github.com/duckdb/duckdb/pull/9542
• Commit drop of index memory by @taniabogatsch in https://github.com/duckdb/duckdb/pull/9540
• [Catalog] Fix locking issues + identify problem in MappingValue by @Tishj in https://github.com/duckdb/duckdb/pull/9523
• JDBC - Add append method for LocalDateTime by @Jens-H in https://github.com/duckdb/duckdb/pull/9435
• Use run_tests_one_by_one to fix CI by @Mytherin in https://github.com/duckdb/duckdb/pull/9570
• pin run-vcpkg action version by @samansmink in https://github.com/duckdb/duckdb/pull/9579
• Add rowsort to test_window_order_collate.test by @carlopi in https://github.com/duckdb/duckdb/pull/9574
• Fix exploding Delim Joins by @Tmonster in https://github.com/duckdb/duckdb/pull/9564
• HivePartition: Add also lock on partition_state by @carlopi in https://github.com/duckdb/duckdb/pull/9576
• Fix typo by @lnkuiper in https://github.com/duckdb/duckdb/pull/9587
• [C-API] fix duckdb_parameter_name declaration by @suketa in https://github.com/duckdb/duckdb/pull/9566
• Fix incorrect template specialization by @jhammer in https://github.com/duckdb/duckdb/pull/9529
• fix(jdbc): allow use of nested result values after close by @Mause in https://github.com/duckdb/duckdb/pull/9592
• Allow pausing pipeline in NextBatch call by @ywelsch in https://github.com/duckdb/duckdb/pull/9562
• Optimize performance of jaccard function by @ucasfl in https://github.com/duckdb/duckdb/pull/9560
• [Python] Add missing default values to stubs of aggregate functions. by @Tishj in https://github.com/duckdb/duckdb/pull/9595
• Fix symbol leakage check by @Mytherin in https://github.com/duckdb/duckdb/pull/9604
• Issue: #8867 Fix: remove unused variables for logical_root. by @Light-City in https://github.com/duckdb/duckdb/pull/8866
• CI: Add job for 'needs maintainer approval' PR tag by @szarnyasg in https://github.com/duckdb/duckdb/pull/8853
• Ci: Fix trigger of 'needs maintainer approval' job by @szarnyasg in https://github.com/duckdb/duckdb/pull/9610
• fix(jdbc): combine jar publish steps by @Mause in https://github.com/duckdb/duckdb/pull/9484
• Increment postgres_scanner version by @Mytherin in https://github.com/duckdb/duckdb/pull/9504
• Improve linear probing performance of GroupedAggregateHashTable by @lnkuiper in https://github.com/duckdb/duckdb/pull/9575
• Expose InterruptState in NextBatch by @ywelsch in https://github.com/duckdb/duckdb/pull/9606
• [Arrow] Support LargeString and LargeList by @Tishj in https://github.com/duckdb/duckdb/pull/9471
• Issue #9589: Prefer strict TIMESTAMPs by @hawkfish in https://github.com/duckdb/duckdb/pull/9600
• Fix issue with streaming query results by @samansmink in https://github.com/duckdb/duckdb/pull/9619
• bump extension versions as prep for 0.9.2 by @samansmink in https://github.com/duckdb/duckdb/pull/9621
• feat: duckdb_api and custom_user_agent options by @elefeint in https://github.com/duckdb/duckdb/pull/9603
• Revert "fix(jdbc): combine jar publish steps" by @Mause in https://github.com/duckdb/duckdb/pull/9620
• Read JSON bugfix by @lnkuiper in https://github.com/duckdb/duckdb/pull/9623
• Fix #9548 - Throw a more clear error when using parameters inside of the source of a top-level PIVOT statement by @Mytherin in https://github.com/duckdb/duckdb/pull/9626
• Add SQL:2016 listagg by @renevdzee in https://github.com/duckdb/duckdb/pull/9613
• Bump spatial by @Maxxen in https://github.com/duckdb/duckdb/pull/9633
• [ODBC] Reorganize the SQLColAttribute Tests by @maiadegraaf in https://github.com/duckdb/duckdb/pull/9580
• Fix #9584: Correctly bail-out on committing appends of 0 rows, which can happen in certain edge cases by @Mytherin in https://github.com/duckdb/duckdb/pull/9640
• Add log(b,x) function by @hannes in https://github.com/duckdb/duckdb/pull/9637
• allow dbgen to be interrupted by user by @elefeint in https://github.com/duckdb/duckdb/pull/9624
• Fix httpfs CI by @samansmink in https://github.com/duckdb/duckdb/pull/9649
• fix 9232 by @samansmink in https://github.com/duckdb/duckdb/pull/9647
• Shell: Set globalDb to NULL after closing database by @Flogex in https://github.com/duckdb/duckdb/pull/9655
• Fix #9308 - avoid pruning plan for ANTI join with filter that is always true by @Mytherin in https://github.com/duckdb/duckdb/pull/9654
• Serialize decimal quantiles by @carlopi in https://github.com/duckdb/duckdb/pull/9653
• Partial revert of #9624: test seemed to cause some memory leaks in CI by @carlopi in https://github.com/duckdb/duckdb/pull/9660

Full Changelog: https://github.com/duckdb/duckdb/compare/v0.9.1...v0.9.2

This is a bug fix release for various issues discovered after we released 0.9.0. There are no new features, just bug fixes. Database files created by DuckDB v0.9.0 can be read by DuckDB v0.9.1 (i.e. v0.9.1 is backwards compatible with v0.9.0 and vice versa).

What's Changed

• Fix missing header in nightly GCC build by @Maxxen in https://github.com/duckdb/duckdb/pull/9109
• Add scripts for cancelling/rerunning workflows by @Mytherin in https://github.com/duckdb/duckdb/pull/9120
• Update R-CMD-Check workflow by @Tmonster in https://github.com/duckdb/duckdb/pull/9128
• CSV error message fix by @pdet in https://github.com/duckdb/duckdb/pull/9132
• Throw SerializationException instead of InternalException by @Maxxen in https://github.com/duckdb/duckdb/pull/9130
• Radix HT: Get max_threads from config instead of system by @lnkuiper in https://github.com/duckdb/duckdb/pull/9129
• Wrapping CSV State Machine by @pdet in https://github.com/duckdb/duckdb/pull/9131
• [CSV] Properly skip new lines mid csv file by @pdet in https://github.com/duckdb/duckdb/pull/9139
• [PythonDev] Rework duckdb_cursor fixture in pytest by @Tishj in https://github.com/duckdb/duckdb/pull/9140
• Update logo in README by @szarnyasg in https://github.com/duckdb/duckdb/pull/9147
• Bump uncovered lines by @carlopi in https://github.com/duckdb/duckdb/pull/9102
• Python: Uniform DuckDB SQL version to v0.X.Y by @carlopi in https://github.com/duckdb/duckdb/pull/9095
• [PythonDev] Don't dereference None when creating pandas dataframe by @Tishj in https://github.com/duckdb/duckdb/pull/9127
• fix: fix some typo by @shizuocheng in https://github.com/duckdb/duckdb/pull/9156
• [Swift] fix row count and index mapping by @tcldr in https://github.com/duckdb/duckdb/pull/9149
• Run Single-Threaded CSV Parser when only one thread is available by @pdet in https://github.com/duckdb/duckdb/pull/9148
• [ODBC] Add missing fields to SQLColAttribute by @maiadegraaf in https://github.com/duckdb/duckdb/pull/9146
• Merge main into feature by @Mause in https://github.com/duckdb/duckdb/pull/9163
• [Python] Pyarrow integer filter pushdown bug fix by @Tishj in https://github.com/duckdb/duckdb/pull/9155
• [CSV] Be sure to run header detection even if a header is defined by the user by @pdet in https://github.com/duckdb/duckdb/pull/9168
• Avoid (Try)AutoLoad logic if extension already loaded by @carlopi in https://github.com/duckdb/duckdb/pull/9177
• Fix fuzzer exclusion by @Tmonster in https://github.com/duckdb/duckdb/pull/9103
• [PythonDev] Fix #duckdb-internal/418 by @Tishj in https://github.com/duckdb/duckdb/pull/9184
• chore: skip arrow union tests on pyarrow<11 by @gforsyth in https://github.com/duckdb/duckdb/pull/9186
• Fix issue related to map() and Dictionary Vectors. by @Tishj in https://github.com/duckdb/duckdb/pull/9046
• Issue #9183: Arbitrary ASOF Conditions by @hawkfish in https://github.com/duckdb/duckdb/pull/9188
• Add instructions for jdk installed via brew by @nicku33 in https://github.com/duckdb/duckdb/pull/9192
• Fix nits in API comments by @szarnyasg in https://github.com/duckdb/duckdb/pull/8768
• Internal #445: Destruct All Aggregates by @hawkfish in https://github.com/duckdb/duckdb/pull/9202
• Don't initialize data chunk in ExpressionExecutor if it's just a BoundReferenceExpression by @lnkuiper in https://github.com/duckdb/duckdb/pull/9213
• [ODBC] Add info to fatal error in compiler by @maiadegraaf in https://github.com/duckdb/duckdb/pull/9218
• Rewrite filter remover arrow test by @lnkuiper in https://github.com/duckdb/duckdb/pull/9217
• [ODBC] Add Unittests to Windows CI Run by @maiadegraaf in https://github.com/duckdb/duckdb/pull/9216
• Add missing parameter defaults for create_function in duckdb-stubs by @earwig in https://github.com/duckdb/duckdb/pull/9224
• Several fixes related to vector_size=2 nightly build by @pdet in https://github.com/duckdb/duckdb/pull/9166
• Avoid keeping read-only transactions stored in old_transactions by @Mytherin in https://github.com/duckdb/duckdb/pull/9236
• Fix reusable workflow for OOTE building by @samansmink in https://github.com/duckdb/duckdb/pull/9229
• [Parquet] Implement reading byte stream split encoded data by @adamreeve in https://github.com/duckdb/duckdb/pull/9240
• Bug report template: ask for imports to be included by @szarnyasg in https://github.com/duckdb/duckdb/pull/9197
• Remove bundled sqlite, does not seem to be used anywhere by @hannes in https://github.com/duckdb/duckdb/pull/9245
• update azure extension by @samansmink in https://github.com/duckdb/duckdb/pull/9243
• Fix #8413: Avoid pushing collations to non-varchar columns, and cleanup around PushCollation by @Mytherin in https://github.com/duckdb/duckdb/pull/9242
• Fix #8624 - allow changing of schema and search_path parameters even if configuration is locked by @Mytherin in https://github.com/duckdb/duckdb/pull/9244
• [ODBC] SQLColAttribte: More tests by @maiadegraaf in https://github.com/duckdb/duckdb/pull/9200
• Fix for creating ephemeral schema on readonly by @nicku33 in https://github.com/duckdb/duckdb/pull/9261
• Wasm extensions Makefile changes by @carlopi in https://github.com/duckdb/duckdb/pull/9269
• Fix #9241 - avoid pushing filters through DISTINCT ON by @Mytherin in https://github.com/duckdb/duckdb/pull/9270
• Fix #7880 part 1 - rebind expression during alias replacement instead of copying the already bound expression by @Mytherin in https://github.com/duckdb/duckdb/pull/9274
• ICU: Remove unused variables by @carlopi in https://github.com/duckdb/duckdb/pull/9275
• Fix #9252 - avoid overwriting start value as part of INCREMENT BY in sequence creation by @Mytherin in https://github.com/duckdb/duckdb/pull/9272
• [Python] Add back value_counts by @Tishj in https://github.com/duckdb/duckdb/pull/9278
• [SparkAPI] Add read.json and read.parquet + some unhappy path testing by @Tishj in https://github.com/duckdb/duckdb/pull/9276
• [Arrow][Dev] Make each produced Array own its own memory. by @Tishj in https://github.com/duckdb/duckdb/pull/9254
• Properly register all JSON cast functions so the binder can disambiguate by @lnkuiper in https://github.com/duckdb/duckdb/pull/9209
• [Dev] Fix test_map_vector_types.test by @Tishj in https://github.com/duckdb/duckdb/pull/9277
• Issue #9280: Parquet TIME_TZ Reading by @hawkfish in https://github.com/duckdb/duckdb/pull/9283
• Update iceberg extension by @samansmink in https://github.com/duckdb/duckdb/pull/9284
• Fix prepare statement issue by @taniabogatsch in https://github.com/duckdb/duckdb/pull/9288
• [Arrow] Fix issue with scanning of UNION of STRUCTS by @Tishj in https://github.com/duckdb/duckdb/pull/9291
• Remove nodejs client by @hannes in https://github.com/duckdb/duckdb/pull/9287
• Clear cached buffers before emitting next chunk by @pdet in https://github.com/duckdb/duckdb/pull/9295
• [Dev] Restore _extension_client_tests.yml syntax by @carlopi in https://github.com/duckdb/duckdb/pull/9300
• Fix MacOS exception catching by @carlopi in https://github.com/duckdb/duckdb/pull/9286
• Unify replacement scan filename parsing by @lnkuiper in https://github.com/duckdb/duckdb/pull/9273
• Extension install fixes by @carlopi in https://github.com/duckdb/duckdb/pull/9294
• Re-add windows extension builds for R by @hannes in https://github.com/duckdb/duckdb/pull/9302

This preview release of DuckDB is named "Undulata" after the aptly named Yellow-billed duck native to Africa.

Note: Again, this release introduces a backwards-incompatible change to the on-disk storage format. We suggest you use the EXPORT DATABASE command with the old version followed by IMPORT DATABASE with the new version to migrate your data. See the documentation for details.

What's Changed

• [Dev] Merge master into feature by @Tishj in https://github.com/duckdb/duckdb/pull/7535
• Issue #7563: make_timestamptz by @hawkfish in https://github.com/duckdb/duckdb/pull/7597
• Add support for nested laterals by @arhamchopra in https://github.com/duckdb/duckdb/pull/7528
• Issue #7563: epoch_us(temporal) by @hawkfish in https://github.com/duckdb/duckdb/pull/7629
• Fix lingering clang-tidy issues by @Mytherin in https://github.com/duckdb/duckdb/pull/7670
• Add list_intersect, list_has_any, and list_has_all by @maiadegraaf in https://github.com/duckdb/duckdb/pull/7518
• Issue #7563: epoch_xs(temporal) by @hawkfish in https://github.com/duckdb/duckdb/pull/7648
• Pivot - dynamically switch between using filtered aggregates or the new pivot operator by @Mytherin in https://github.com/duckdb/duckdb/pull/7688
• Add wildcard to JSON Path by @lnkuiper in https://github.com/duckdb/duckdb/pull/7624
• [Dev] Add optional build flag to disable assertions in debug mode by @Tishj in https://github.com/duckdb/duckdb/pull/7618
• [DEV]: ICU C Casts by @hawkfish in https://github.com/duckdb/duckdb/pull/7715
• List_resize by @maiadegraaf in https://github.com/duckdb/duckdb/pull/7401
• Issue #7187: AsOf Join Performance by @hawkfish in https://github.com/duckdb/duckdb/pull/7607
• Some minor CI changes by @samansmink in https://github.com/duckdb/duckdb/pull/7763
• Binder coverage by @hawkfish in https://github.com/duckdb/duckdb/pull/7791
• Vacuum Completely Deleted Row Groups by @Mytherin in https://github.com/duckdb/duckdb/pull/7794
• Issue #7187: AsOf Coverage by @hawkfish in https://github.com/duckdb/duckdb/pull/7774
• Implement FIELD_IDS for parquet writes by @lnkuiper in https://github.com/duckdb/duckdb/pull/7696
• Optimize Regexp_matches to LIKE statements when possible by @Tmonster in https://github.com/duckdb/duckdb/pull/7264
• Jemalloc configuration, more buffer allocator, and remove redundant string copying in parquet dictionary by @lnkuiper in https://github.com/duckdb/duckdb/pull/7697
• Truncate Database File on Checkpoint by @Mytherin in https://github.com/duckdb/duckdb/pull/7824
• LEFT JOIN ON TRUE support by @taniabogatsch in https://github.com/duckdb/duckdb/pull/7821
• Issue #7809: Segment Tree Performance by @hawkfish in https://github.com/duckdb/duckdb/pull/7831
• C Data Interface: duckdb_arrow_scan and duckdb_arrow_array_scan by @angadn in https://github.com/duckdb/duckdb/pull/7570
• Update Julia to 0.8.1 by @Mytherin in https://github.com/duckdb/duckdb/pull/7932
• Add conn.interrupt() to DuckDB python API by @henrinikku in https://github.com/duckdb/duckdb/pull/7895
• renaming part of extension build refactor PR by @samansmink in https://github.com/duckdb/duckdb/pull/7926
• fix swapped x/y regression parameters by @MartinNowak in https://github.com/duckdb/duckdb/pull/7855
• [Docs] Aggregate function README.md by @hawkfish in https://github.com/duckdb/duckdb/pull/7881
• PhysicalPiecewiseMergeJoin improvement by @xuke-hat in https://github.com/duckdb/duckdb/pull/7832
• Initial set of commits to add support for zOS (an IBM mainframe operating system) by @v1gnesh in https://github.com/duckdb/duckdb/pull/7805
• test(nodejs): add test_all_types.test.ts by @Mause in https://github.com/duckdb/duckdb/pull/7740
• Issue #7879: Missing JDBC TIMESTAMP_TZ by @hawkfish in https://github.com/duckdb/duckdb/pull/7922
• Attempt to fix CI on Windows 32 and Python on Windows by @carlopi in https://github.com/duckdb/duckdb/pull/7961
• Fix 7947 by @lnkuiper in https://github.com/duckdb/duckdb/pull/7963
• test: patch test_7652 to skip on pyarrow<11 by @gforsyth in https://github.com/duckdb/duckdb/pull/7966
• NodeJS: Add columns() method to get type info from prepared statement by @Maxxen in https://github.com/duckdb/duckdb/pull/7948
• Fix: Don't free arrow children explicitly by @Maxxen in https://github.com/duckdb/duckdb/pull/7917
• CSV Rejects table by @Maxxen in https://github.com/duckdb/duckdb/pull/7681
• Issue #7809: Segment Tree Performance by @hawkfish in https://github.com/duckdb/duckdb/pull/7891
• Add tpch benchmark run exclusively on parquet files by @Tmonster in https://github.com/duckdb/duckdb/pull/7519
• Bidirectional check storage + minor CI fixes by @carlopi in https://github.com/duckdb/duckdb/pull/7955
• [Swift] fix #7985 by @tcldr in https://github.com/duckdb/duckdb/pull/7993
• Move @samansmink's extension_header_rename.patch by @carlopi in https://github.com/duckdb/duckdb/pull/8001
• [Python] Properly use NumPy array stride when scanning object arrays. by @Tishj in https://github.com/duckdb/duckdb/pull/7964
• CI - No longer run on PR synchronize, instead run on ready_for_review by @Mytherin in https://github.com/duckdb/duckdb/pull/8007
• Parallel pipeline execution should call NextBatch on first batch by @bleskes in https://github.com/duckdb/duckdb/pull/7978
• Micro-optimization for generating collation keys by @Krechals in https://github.com/duckdb/duckdb/pull/7983
• Multiple assignment for UPDATE SET by @nickgerrets in https://github.com/duckdb/duckdb/pull/7968
• CI job to move synchronized PRs to draft by @carlopi in https://github.com/duckdb/duckdb/pull/8010
• [ADBC] ConnectionGetTableSchema and StatementSetSubstraitPlan Functions by @pdet in https://github.com/duckdb/duckdb/pull/7914
• Issue #7852: Window Vectorisation by @hawkfish in https://github.com/duckdb/duckdb/pull/7996
• Moving JDBC Linux x64 builds to CentOS 7 by @hannes in https://github.com/duckdb/duckdb/pull/7991
• CI Draft - token is called GH_TOKEN by @Mytherin in https://github.com/duckdb/duckdb/pull/8016
• Add support for materialized CTEs by @kryonix in https://github.com/duckdb/duckdb/pull/7126
• Reduce memory usage of Parquet writer by @lnkuiper in https://github.com/duckdb/duckdb/pull/7995
• CI auto draft: pass token via environment + avoid wrapping action by @carlopi in https://github.com/duckdb/duckdb/pull/8024
• CI autodraft: use implicit variable [test] by @carlopi in https://github.com/duckdb/duckdb/pull/8027
• remove duplicate pivots declare by @douenergy in https://github.com/duckdb/duckdb/pull/7992
• Fix typo in fts indexing exception by @alexanderchiu in https://github.com/duckdb/duckdb/pull/8034
• Fix issue 7988 by @samansmink in https://github.com/duckdb/duckdb/pull/8023
• Delete DraftMe.yml by @Mytherin in https://github.com/duckdb/duckdb/pull/8048
• Fix 3eb9ab34db1: Remove unneeded move by @carlopi in https://github.com/duckdb/duckdb/pull/8038
• [CI] Skip many more CI jobs for pull requests, and add make coverage-check to run coverage locally by @Mytherin in https://github.com/duckdb/duckdb/pull/8046
• Extension build configuration refactor by @samansmink in https://github.com/duckdb/duckdb/pull/7735
• Compressed Materialization by @lnkuiper in https://github.com/duckdb/duckdb/pull/7644
• [Relation] Add support for creating an empty ValueRelation by @Tishj in https://github.com/duckdb/duckdb/pull/7967
• Join Order Optimizer has duplicate enumerations and lost some neighbors by @lokax in https://github.com/duckdb/duckdb/pull/7358
• Fix CI wasm by @carlopi in https://github.com/duckdb/duckdb/pull/8057
• [CI] More CI reduction and clean-up by @Mytherin in https://github.com/duckdb/duckdb/pull/8052
• Restore auto-draft functionality by @carlopi in https://github.com/duckdb/duckdb/pull/8058
• Move WebAssembly.yml to NightlyTests.yml by @carlopi in https://github.com/duckdb/duckdb/pull/8060
• Unskip, attach HTTPFS test, and create HTTPState when the opener is not available by @pdet in https://github.com/duckdb/duckdb/pull/8012
• CI fixes: Don't persist ccache for nightlies by @carlopi in https://github.com/duckdb/duckdb/pull/8075
• Fix regression & fix draft mechanism by @carlopi in https://github.com/duckdb/duckdb/pull/8071
• CI compliance feature branch by @carlopi in https://github.com/duckdb/duckdb/pull/8070
• Fix python flaky test (potentially GET requests gets back 403) by @carlopi in https://github.com/duckdb/duckdb/pull/8074
• [Arrow] Fix segfault in appending list data by @Tishj in https://github.com/duckdb/duckdb/pull/8042
• Issue #7852: Window Vectorisation by @hawkfish in https://github.com/duckdb/duckdb/pull/8050
• CONTRIBUTING.md by @carlopi in https://github.com/duckdb/duckdb/pull/8077
• Add ORDER BY clause to query in test_bool.test by @Flogex in https://github.com/duckdb/duckdb/pull/8082
• ART test and benchmark refactor by @taniabogatsch in https://github.com/duckdb/duckdb/pull/8055
• Update plan cost runner script to remove 20% threshold for cardinality estimates by @Tmonster in https://github.com/duckdb/duckdb/pull/7989
• Fix #8067 by @lnkuiper in https://github.com/duckdb/duckdb/pull/8090
• ART prefix refactor by @taniabogatsch in https://github.com/duckdb/duckdb/pull/7930
• Bump Substrait by @pdet in https://github.com/duckdb/duckdb/pull/8110
• Merge feature into master by @Mytherin in https://github.com/duckdb/duckdb/pull/8136
• Increase memory limit in test to prevent non-deterministic CI failures by @lnkuiper in https://github.com/duckdb/duckdb/pull/8138
• UNNEST binder fix by @taniabogatsch in https://github.com/duckdb/duckdb/pull/8111
• Out-of-Core Hash Aggregate by @lnkuiper in https://github.com/duckdb/duckdb/pull/7931
• Add Unittests for ODBC by @maiadegraaf in https://github.com/duckdb/duckdb/pull/7875
• Hive types by @lverdoes in https://github.com/duckdb/duckdb/pull/7674
• CppCheck & CodeQL on master by @carlopi in https://github.com/duckdb/duckdb/pull/8113
• Fix CI for Nodejs and OSX by @carlopi in https://github.com/duckdb/duckdb/pull/8148
• Skip failing test on R on CI by @carlopi in https://github.com/duckdb/duckdb/pull/8161
• Disable failing R tests for now, and disable test_arrow_progress on Windows by @Mytherin in https://github.com/duckdb/duckdb/pull/8155
• Allow disabling of extension loading (through a CMake flag) and allow selectively disabling specific file systems by @Mytherin in https://github.com/duckdb/duckdb/pull/8152
• Fix FTS + ATTACH by @lnkuiper in https://github.com/duckdb/duckdb/pull/8153
• fix: cli parser issue by @stephaniewang526 in https://github.com/duckdb/duckdb/pull/8107
• integrate with julia tables by @aplavin in https://github.com/duckdb/duckdb/pull/7984
• Add JoinReftype to Relational Joins (to add asof, positional, dependent joins) by @Tmonster in https://github.com/duckdb/duckdb/pull/7987
• Adjust the logic for adding type dependencies to temp tables by @jwills in https://github.com/duckdb/duckdb/pull/8073
• Add File filters to Logical Get / Physical Table Scan. by @Tmonster in https://github.com/duckdb/duckdb/pull/7986
• Issue #8119: TO_TIMESTAMP Returns TIMESTAMP by @hawkfish in https://github.com/duckdb/duckdb/pull/8127
• [Python] Start of DuckDB Spark API by @Tishj in https://github.com/duckdb/duckdb/pull/8083
• Create NamingConvention.md, with @samansmink by @carlopi in https://github.com/duckdb/duckdb/pull/8166
• Casts from and to BIT type by @nickgerrets in https://github.com/duckdb/duckdb/pull/7941
• [Python] Add Value class to explicitly set type of prepared parameter by @Tishj in https://github.com/duckdb/duckdb/pull/8114
• Use many linux image in several places by @samansmink in https://github.com/duckdb/duckdb/pull/8097
• Update tests broken after conflicting PRs by @samansmink in https://github.com/duckdb/duckdb/pull/8168
• Auto-generate FormatSerialize/FormatDeserialize code from JSON that defines the schema by @Mytherin in https://github.com/duckdb/duckdb/pull/8156
• Odbc Lambda Removal by @maiadegraaf in https://github.com/duckdb/duckdb/pull/8167
• fix: support case-insensitive lookup in SHOW TABLES by @stephaniewang526 in https://github.com/duckdb/duckdb/pull/8173
• Bump duckdb-wasm, remove patch, fix NightlyTests.yml triggers by @carlopi in https://github.com/duckdb/duckdb/pull/8176
• [Python] Add extra safeguards around join method by @Tishj in https://github.com/duckdb/duckdb/pull/8170
• Bump ubuntu to 18 for linux extensions build by @samansmink in https://github.com/duckdb/duckdb/pull/8179
• user CMAKE_CURRENT_SOURCE_DIR by @peterboncz in https://github.com/duckdb/duckdb/pull/8183
• Auto-generate type serialization + make enum generation deterministic by @Mytherin in https://github.com/duckdb/duckdb/pull/8175
• Fix #7863 - use LoadLibraryW to load extensions by @Mytherin in https://github.com/duckdb/duckdb/pull/8186
• [Python UDF] Disallow create_function as part of a transaction by @Tishj in https://github.com/duckdb/duckdb/pull/8169
• Arrow C API test - initialize result to nullptr by @Mytherin in https://github.com/duckdb/duckdb/pull/8184
• Issue #7969: Prefer Range Join by @hawkfish in https://github.com/duckdb/duckdb/pull/8092
• add verbose option to generate_grammar.py by @douenergy in https://github.com/duckdb/duckdb/pull/8181
• Make the Binder respect the max_expression_depth setting by @Tishj in https://github.com/duckdb/duckdb/pull/8188
• build: upload libduckdb_static.a too by @Mause in https://github.com/duckdb/duckdb/pull/8197
• Pragma platform by @carlopi in https://github.com/duckdb/duckdb/pull/8195
• Issue #7595: AsOf Inequalities by @hawkfish in https://github.com/duckdb/duckdb/pull/8196
• CI Job names to explicit platform they build for by @carlopi in https://github.com/duckdb/duckdb/pull/8202
• ODBC Small Issues fix #7918 #7890 #7653 by @maiadegraaf in https://github.com/duckdb/duckdb/pull/8205
• Enable vcpkg for extensions by @samansmink in https://github.com/duckdb/duckdb/pull/8210
• Remove unnecessary dbplyr fill method by @mgirlich in https://github.com/duckdb/duckdb/pull/8211
• Add union to test_all_types, and arrow and json R/W by @Mause in https://github.com/duckdb/duckdb/pull/7701
• R: Avoid crash when finalizing by @krlmlr in https://github.com/duckdb/duckdb/pull/8207
• Fix #8191 - build duckdb shell error with “DISABLE_UNITY=1” for link … by @zzachimed in https://github.com/duckdb/duckdb/pull/8192
• Chore: Bump duckdb-wasm AND move to emscripten latest by @carlopi in https://github.com/duckdb/duckdb/pull/8220
• Issue #7808: Partition Using PartitionedTupleData by @hawkfish in https://github.com/duckdb/duckdb/pull/8085
• some extensions (like motherduck) take an interest in SET and PRAGMA by @peterboncz in https://github.com/duckdb/duckdb/pull/8226
• Change join ref type to cross if join type is cross and join ref type is regular by @Tmonster in https://github.com/duckdb/duckdb/pull/8227
• Issue #8217: Test Lead/Lag Framing by @hawkfish in https://github.com/duckdb/duckdb/pull/8233
• ODBC: Reformat Diagnosics Function by @maiadegraaf in https://github.com/duckdb/duckdb/pull/8237
• ODBC: Fix for Issue #8190 by @maiadegraaf in https://github.com/duckdb/duckdb/pull/8223
• fix typos and spelling errors in https://github.com/duckdb/duckdb/pull/8244
• (julia) fix show for query result by @tbeason in https://github.com/duckdb/duckdb/pull/8256
• CI: Fix typo in LinuxRelease.yml by @carlopi in https://github.com/duckdb/duckdb/pull/8267
• Remove Node 15 from supported versions by @carlopi in https://github.com/duckdb/duckdb/pull/8251
• Reduce colreaders by @ccfelius in https://github.com/duckdb/duckdb/pull/8248
• Fix init value type in std::accumulate by @xuke-hat in https://github.com/duckdb/duckdb/pull/8275
• Allow parser extensions to use PostgresParser by @ywelsch in https://github.com/duckdb/duckdb/pull/8254
• Implement ROW_GROUP_SIZE_BYTES for Parquet writer by @lnkuiper in https://github.com/duckdb/duckdb/pull/8221
• use cmake_current_source_dir by @samansmink in https://github.com/duckdb/duckdb/pull/8278
• fix(jdbc): result/prepped stmt metadata by @Mause in https://github.com/duckdb/duckdb/pull/8280
• ART: inline row IDs into node pointers by @taniabogatsch in https://github.com/duckdb/duckdb/pull/8112
• Skip row group size test on vsize=2 by @Mytherin in https://github.com/duckdb/duckdb/pull/8292
• Update duckdb-wasm in CI & fix order of operations by @carlopi in https://github.com/duckdb/duckdb/pull/8288
• Issue #8086: Parallel Window Refactoring by @hawkfish in https://github.com/duckdb/duckdb/pull/8269
• [RLE] Emit constant vectors when possible by @Tishj in https://github.com/duckdb/duckdb/pull/8250
• Update R tests to run test_struct.R not on CRAN by @Tmonster in https://github.com/duckdb/duckdb/pull/8297
• Always initialize variables used by ParallelCSVGlobalState::MaxThreads() by @ywelsch in https://github.com/duckdb/duckdb/pull/8295
• [ODBC] Add Row-Wise Fetching and Bool-to-Char Tests by @maiadegraaf in https://github.com/duckdb/duckdb/pull/8306
• Print join_ref_type when explaining joins by @krlmlr in https://github.com/duckdb/duckdb/pull/8276
• Fix handling of cross joins by @krlmlr in https://github.com/duckdb/duckdb/pull/8274
• Remove dangerous overload of cpp11::warning() by @krlmlr in https://github.com/duckdb/duckdb/pull/8272
• add to_base function by @Maxxen in https://github.com/duckdb/duckdb/pull/8122
• Resolve the conflict between the CTE name and the referring table name. by @douenergy in https://github.com/duckdb/duckdb/pull/8302
• Compression for the INT128 type by @nickgerrets in https://github.com/duckdb/duckdb/pull/8277
• Fix some function json defs by @Mause in https://github.com/duckdb/duckdb/pull/8313
• Exposing InterruptState in Sink Combine & Finalize by @samansmink in https://github.com/duckdb/duckdb/pull/8296
• Add iceberg extension by @samansmink in https://github.com/duckdb/duckdb/pull/8317
• Serialization - Add Format(De)Serialize to almost everything by @Mytherin in https://github.com/duckdb/duckdb/pull/8323
• [Python] Add a top-level native python module by @Tishj in https://github.com/duckdb/duckdb/pull/8189
• CI WebAssembly: Avoid eagerly '--recurse-submodules' by @carlopi in https://github.com/duckdb/duckdb/pull/8327
• PR2 for zOS support by @v1gnesh in https://github.com/duckdb/duckdb/pull/7973
• fix(python): restore version field by @Mause in https://github.com/duckdb/duckdb/pull/8338
• Issue 8315: Window Null Order by @hawkfish in https://github.com/duckdb/duckdb/pull/8324
• Swap arguments for atan2 function to atan2(y, x) by @szarnyasg in https://github.com/duckdb/duckdb/pull/8308
• Add Black Python formatter by @Mause in https://github.com/duckdb/duckdb/pull/8335
• [ADBC] Add support for ingestion mode by @pdet in https://github.com/duckdb/duckdb/pull/8349
• feat: python scripts formatting by @Mause in https://github.com/duckdb/duckdb/pull/8354
• [Python] Correctly handle pandas DataFrames when copy_on_write is set to True by @Tishj in https://github.com/duckdb/duckdb/pull/8348
• [Arrow Appender] Clean up file/folder structure by @Tishj in https://github.com/duckdb/duckdb/pull/8289
• [CI] Fix test failure introduced by #8348 by @Tishj in https://github.com/duckdb/duckdb/pull/8361
• Pipeline scheduling issue by @samansmink in https://github.com/duckdb/duckdb/pull/8356
• Workaround for failing vcpkg openssl install by @samansmink in https://github.com/duckdb/duckdb/pull/8362
• Call pwrite/pread in a loop and reduce disk space usage of window_partition_paging.test_slow by @Mytherin in https://github.com/duckdb/duckdb/pull/8369
• Add format serialization for BoundFunction/Aggregate/Window and LogicalGet by @Mytherin in https://github.com/duckdb/duckdb/pull/8365
• Throw exception for encrypted Parquet files by @ccfelius in https://github.com/duckdb/duckdb/pull/8368
• Small out-of-tree extension fixes/features by @samansmink in https://github.com/duckdb/duckdb/pull/8375
• Path separator fix windows by @samansmink in https://github.com/duckdb/duckdb/pull/8345
• Compare scalar functions by name/args/return instead of function object target by @Maxxen in https://github.com/duckdb/duckdb/pull/8364
• [Python] Add support for +/- infinity datetime objects by @Tishj in https://github.com/duckdb/duckdb/pull/8294
• Format serialization - add missing serialization logic for DelimJoin, AsOfJoin, CreateIndex and enums by @Mytherin in https://github.com/duckdb/duckdb/pull/8378
• [CI Python] More 'copy_on_write' fixes by @Tishj in https://github.com/duckdb/duckdb/pull/8376
• fix end of file handling for gzip files by @igorcalabria in https://github.com/duckdb/duckdb/pull/8386
• Issue CI workflows by @lnkuiper in https://github.com/duckdb/duckdb/pull/8390
• [CI] Fix nightly tests (sqllogictests, asof join out of disk space) by @Mytherin in https://github.com/duckdb/duckdb/pull/8385
• use labels field instead of workflow for needs triage by @Mause in https://github.com/duckdb/duckdb/pull/8400
• [Python] Remove PyObject * where possible by @Tishj in https://github.com/duckdb/duckdb/pull/8393
• Fix CMake syntax on non defined variable by @carlopi in https://github.com/duckdb/duckdb/pull/8401
• [RLE] Fix problem created by #8250 by @Tishj in https://github.com/duckdb/duckdb/pull/8391
• [Arrow] Fix conversion from arrow -> duckdb for nested structs by @Tishj in https://github.com/duckdb/duckdb/pull/8383
• [ADBC] Python Tests and Fix for Arrow Schema call. by @pdet in https://github.com/duckdb/duckdb/pull/8366
• Use bot token for issue workflows and increase stale issue budget by @lnkuiper in https://github.com/duckdb/duckdb/pull/8404
• Nitpick: change case of "stale" issue label by @lnkuiper in https://github.com/duckdb/duckdb/pull/8407
• capi: duckdb_interrupt & duckdb_query_progress by @Virgiel in https://github.com/duckdb/duckdb/pull/8064
• Bind the children of a STRUCT alias type. by @Tishj in https://github.com/duckdb/duckdb/pull/8389
• [NanODBC] Fix run_nanodbc_tests.sh by @Tishj in https://github.com/duckdb/duckdb/pull/8388
• ODBC: Add remaining tests by @maiadegraaf in https://github.com/duckdb/duckdb/pull/8382
• fix minor ci failure by @samansmink in https://github.com/duckdb/duckdb/pull/8411
• Update bug_report.yml to ask a better master build question by @Mause in https://github.com/duckdb/duckdb/pull/8427
• Fix capi streaming test - this is not deterministic if there are background threads by @Mytherin in https://github.com/duckdb/duckdb/pull/8429
• bump spatial by @Maxxen in https://github.com/duckdb/duckdb/pull/8394
• read_csv_auto tests: Change 'delimiter' to 'delim' by @szarnyasg in https://github.com/duckdb/duckdb/pull/8409
• [Arrow] Add ChunkScanState interface to preserve chunk-offset when scanning by @Tishj in https://github.com/duckdb/duckdb/pull/8307
• Qualify macros only when called, and throw error on recursive macros by @lnkuiper in https://github.com/duckdb/duckdb/pull/8224
• Add instructions for installing black and clang-format by @Mause in https://github.com/duckdb/duckdb/pull/8373
• Get issue title safely in workflow by @lnkuiper in https://github.com/duckdb/duckdb/pull/8436
• [ADBC] [Python] Adding extra tests and small fixes by @pdet in https://github.com/duckdb/duckdb/pull/8431
• Set total_byte_size of Parquet row groups by @lnkuiper in https://github.com/duckdb/duckdb/pull/8405
• Python TIMESTAMPTZ support by @pdet in https://github.com/duckdb/duckdb/pull/8089
• Add "require noalternativeverify" to all FTS tests by @lnkuiper in https://github.com/duckdb/duckdb/pull/8448
• Check for duplicate member tag names in serialization generation by @Maxxen in https://github.com/duckdb/duckdb/pull/8449
• Issue #5610: Disallow Chained Frames by @hawkfish in https://github.com/duckdb/duckdb/pull/8442
• Issue #8416: Pre-Gregorian Timestamps by @hawkfish in https://github.com/duckdb/duckdb/pull/8418
• Issue #8399: ICU Epoch Offset by @hawkfish in https://github.com/duckdb/duckdb/pull/8415
• Finish specialization of the LIST aggregate function by @taniabogatsch in https://github.com/duckdb/duckdb/pull/8309
• Add Java format config to clang-format by @Mause in https://github.com/duckdb/duckdb/pull/8355
• List_slice adjusted NULL handling and added steps feature by @maiadegraaf in https://github.com/duckdb/duckdb/pull/8087
• DuckDB PySpark Types by @Tishj in https://github.com/duckdb/duckdb/pull/8165
• Fix issue 8230 by @samansmink in https://github.com/duckdb/duckdb/pull/8450
• Move all extensions to new build, remove legacy ci by @samansmink in https://github.com/duckdb/duckdb/pull/8465
• [Dev] Update uncovered files by @Tishj in https://github.com/duckdb/duckdb/pull/8476
• [Python Dev] Use pytest.mark.parametrize to make test logs easier to read in test_all_types.py by @Tishj in https://github.com/duckdb/duckdb/pull/8479
• [C-API + CLI] Add support for named parameters in prepared statements by @Tishj in https://github.com/duckdb/duckdb/pull/7113
• Fix issue 8422: date_part('isodow', timestamptz) to return correct iso day numbers. by @robert-manchester in https://github.com/duckdb/duckdb/pull/8432
• remove static loading extensions for node/python/r dev builds by @samansmink in https://github.com/duckdb/duckdb/pull/8473
• Add geomean macro by @szarnyasg in https://github.com/duckdb/duckdb/pull/8471
• Bump duckdb-wasm to 9f2f87b by @carlopi in https://github.com/duckdb/duckdb/pull/8470
• CI: Change clang-format version to 11 by @maiadegraaf in https://github.com/duckdb/duckdb/pull/8474
• Add list_reverse function by @maiadegraaf in https://github.com/duckdb/duckdb/pull/8477
• R: dbplyr_fill0() no longer exists by @krlmlr in https://github.com/duckdb/duckdb/pull/8480
• General ART improvements and memory pressure reduction by @taniabogatsch in https://github.com/duckdb/duckdb/pull/8437
• [Arrow (Dev)] Refactor arrow scan internals by @Tishj in https://github.com/duckdb/duckdb/pull/8430
• Expose lto and llvm folder compilation flags by @carlopi in https://github.com/duckdb/duckdb/pull/8357
• Documenting R release process by @hannes in https://github.com/duckdb/duckdb/pull/8081
• Remove assertion on empty linked list by @taniabogatsch in https://github.com/duckdb/duckdb/pull/8502
• Fix total_cardinality is zero will result in undefined-behavior by @zhouliqi in https://github.com/duckdb/duckdb/pull/8506
• Issue #8512: Negative Time Intervals by @hawkfish in https://github.com/duckdb/duckdb/pull/8515
• Rework Metadata Storage by @Mytherin in https://github.com/duckdb/duckdb/pull/8513
• Issue #8086: Window Work Stealing by @hawkfish in https://github.com/duckdb/duckdb/pull/8491
• Add android ifdefs by @Mause in https://github.com/duckdb/duckdb/pull/8526
• Fuzzer #590: MAKE_TIMESTAMPTZ Extreme Paranoia by @hawkfish in https://github.com/duckdb/duckdb/pull/8514
• R: Update duckplyr tests by @krlmlr in https://github.com/duckdb/duckdb/pull/8482
• R: Add test for disconnect behavior by @krlmlr in https://github.com/duckdb/duckdb/pull/8483
• [ADBC] Addings more tests and small fixes. by @pdet in https://github.com/duckdb/duckdb/pull/8478
• Refactoring the Join Order Optimizer by @Tmonster in https://github.com/duckdb/duckdb/pull/8468
• [Dev] Fix CI failure caused by #7113 by @Tishj in https://github.com/duckdb/duckdb/pull/8533
• fix query hang in Jetbrains programs (IntelliJ, DataGrip, etc) by @Mause in https://github.com/duckdb/duckdb/pull/8511
• Add PendingExecutionResult::ALL_TASKS_BLOCKED by @samansmink in https://github.com/duckdb/duckdb/pull/8497
• [R] Fix retention of time component of TIMESTAMPS when converting time zones #8547 by @ateucher in https://github.com/duckdb/duckdb/pull/8548
• Add "field ID's" to new serialization by @Maxxen in https://github.com/duckdb/duckdb/pull/8536
• Fix #3170: Get old value when update on rows with big row_id by @zippond in https://github.com/duckdb/duckdb/pull/8520
• Silence warnings on thread sanitizer for CanHave[No]Null by @carlopi in https://github.com/duckdb/duckdb/pull/8552
• Issue #6027: Explicit ROW_GROUP_SIZE no longer breaks IMPORT/EXPORT round-trip by @jmeulemans in https://github.com/duckdb/duckdb/pull/8559
• fix: remove unused ForwardRef import by @Mause in https://github.com/duckdb/duckdb/pull/8543
• [Python] Enable use of CUBE / ROLLUP in groups parameter of DuckDBPyRelation aggregate methods. by @Tishj in https://github.com/duckdb/duckdb/pull/8510
• Adding explicit errors for cascade/set null/set default by @hannes in https://github.com/duckdb/duckdb/pull/8572
• Throw exception on type error in JsonDeserializer by @Maxxen in https://github.com/duckdb/duckdb/pull/8291
• Remove packaging for Python 3.6 by @carlopi in https://github.com/duckdb/duckdb/pull/8577
• Fix gcc weird behaviour around template deduction (#8533) by @carlopi in https://github.com/duckdb/duckdb/pull/8576
• Fix: Remove undefined behaviour in frame-of-reference bitpacking by @nickgerrets in https://github.com/duckdb/duckdb/pull/8569
• Issue #8461: Null Hive Typing by @hawkfish in https://github.com/duckdb/duckdb/pull/8540
• [Python] Don't clog the tools/pythonpkg/duckdb folder on build by @Tishj in https://github.com/duckdb/duckdb/pull/8534
• Add Mold Linker Support for Linux by @douenergy in https://github.com/duckdb/duckdb/pull/8517
• Fuzzer #572: Lead Lag Overflow by @hawkfish in https://github.com/duckdb/duckdb/pull/8538
• Fuzzer #668: Window List NULLs by @hawkfish in https://github.com/duckdb/duckdb/pull/8557
• Update R readme to add instructions on how to load the httpfs extension by @Tmonster in https://github.com/duckdb/duckdb/pull/8567
• [ADBC] Finish ADBC spec compliance by @Tishj in https://github.com/duckdb/duckdb/pull/8417
• fix(#8412): forbid topn optimization when there are scalar subquery in limit or offset clause by @Reminiscent in https://github.com/duckdb/duckdb/pull/8519
• R: Update duckplyr tests by @krlmlr in https://github.com/duckdb/duckdb/pull/8608
• R: Allow microsecond precision for timestamps by @krlmlr in https://github.com/duckdb/duckdb/pull/8597
• R: Fix core dump when failing to evaluate ALTREP query by @krlmlr in https://github.com/duckdb/duckdb/pull/8600
• Fuzzer #583: Orders Nary Aggregates by @hawkfish in https://github.com/duckdb/duckdb/pull/8598
• Add register functions for AggregateFunction used by extensions by @ttanay in https://github.com/duckdb/duckdb/pull/8607
• R: Full support of lists and structs in R by @krlmlr in https://github.com/duckdb/duckdb/pull/8503
• R: Avoid leaking format specifiers in cpp11::stop() calls by @krlmlr in https://github.com/duckdb/duckdb/pull/8614
• [R] Add ADBC integration with the adbcdrivermanager package by @paleolimbot in https://github.com/duckdb/duckdb/pull/8172
• fix(#8441): some filter expressions can not be pushed down by @Reminiscent in https://github.com/duckdb/duckdb/pull/8532
• format.py: add checks (and suggestion) to install needed tools by @carlopi in https://github.com/duckdb/duckdb/pull/8629
• R: Fix warning on mismatched integer comparison by @carlopi in https://github.com/duckdb/duckdb/pull/8626
• Rename branch from master to main by @hannes in https://github.com/duckdb/duckdb/pull/8639
• Second round of branch renames by @hannes in https://github.com/duckdb/duckdb/pull/8643
• Fix: Unimplemented type for TryAddOperator by @nickgerrets in https://github.com/duckdb/duckdb/pull/8566
• typo by @hannes in https://github.com/duckdb/duckdb/pull/8644
• Wrap ALTREP methods with BEGIN_CPP11 and END_CPP11 by @krlmlr in https://github.com/duckdb/duckdb/pull/8647
• Fix test_csv_httpfs.test_slow by @carlopi in https://github.com/duckdb/duckdb/pull/8637
• [Python] Add support for datetime64 columns with a time-unit that is not ns by @Tishj in https://github.com/duckdb/duckdb/pull/8620
• PR3 for zOS by @v1gnesh in https://github.com/duckdb/duckdb/pull/8625
• [Dev] Add explicit expected error for test/sql/storage/multiple_clients_checkpoint_pending_updates.test by @Tishj in https://github.com/duckdb/duckdb/pull/8654
• Extension sha256: Avoid full copies by updating sha context by @carlopi in https://github.com/duckdb/duckdb/pull/8636
• Expose window functions in the Python API by @jarandaf in https://github.com/duckdb/duckdb/pull/8568
• Issue #2827: Julian Day Parts by @hawkfish in https://github.com/duckdb/duckdb/pull/8523
• Issue #8659: Non-Invertible Casts by @hawkfish in https://github.com/duckdb/duckdb/pull/8661
• Fix CI failure with test/sql/copy/s3/glob_s3_paging.test_slow by @samansmink in https://github.com/duckdb/duckdb/pull/8670
• ADBC: Use new(std::nothrow) + check on null by @carlopi in https://github.com/duckdb/duckdb/pull/8676
• Issue #8674: Interrupt Work Stealing by @hawkfish in https://github.com/duckdb/duckdb/pull/8679
• Add fix for substrait CI failure by @pdet in https://github.com/duckdb/duckdb/pull/8545
• fix cpp11 issue in r api by @hannes in https://github.com/duckdb/duckdb/pull/8664
• [Dev] Fix sporadically failing test window-rows-overflow.test by @Tishj in https://github.com/duckdb/duckdb/pull/8678
• [Dev] Use our parquet writer in test_filter_pushdown_2145 test instead by @Tishj in https://github.com/duckdb/duckdb/pull/8694
• fix: typo in comment by @SkyFan2002 in https://github.com/duckdb/duckdb/pull/8696
• CI: skip test/fuzzer/sqlsmith/window-rows-overflow.test by @carlopi in https://github.com/duckdb/duckdb/pull/8693
• Makefile extension config by @carlopi in https://github.com/duckdb/duckdb/pull/8692
• Remove deprecated experimental_parallel_csv configuration option by @szarnyasg in https://github.com/duckdb/duckdb/pull/8669
• [Dev] Fix CI failure related to pandas and timezones by @Tishj in https://github.com/duckdb/duckdb/pull/8665
• Fix for #3789, separate updates into storage backends individually by @hannes in https://github.com/duckdb/duckdb/pull/8618
• [Internals] Fix key/value name in MAP produced by map_entries by @Tishj in https://github.com/duckdb/duckdb/pull/8460
• C-API: Fix duckdb_arrow_scan API by @k-anshul in https://github.com/duckdb/duckdb/pull/8653
• [PythonDev] Fix failing test_statement_bind.py test by @Tishj in https://github.com/duckdb/duckdb/pull/8711
• Issue #3409: Time TZ Storage by @hawkfish in https://github.com/duckdb/duckdb/pull/8650
• [Parquet] Fall back to VARCHAR for unsupported types in EXPORT DATABASE by @Tishj in https://github.com/duckdb/duckdb/pull/8710
• [Parquet reader] support reading small decimals with DBP encoding by @samansmink in https://github.com/duckdb/duckdb/pull/8715
• When projecting to the R client, use GetName instead of ToString() by @Tmonster in https://github.com/duckdb/duckdb/pull/8717
• Custom indexes: Step 0 by @Maxxen in https://github.com/duckdb/duckdb/pull/8367
• Add reusable workflows for out-of-tree extensions by @samansmink in https://github.com/duckdb/duckdb/pull/8714
• feat(jdbc): read struct, map, and unions by @Mause in https://github.com/duckdb/duckdb/pull/8686
• Slight refactor to silence a gcc13 warning by @hannes in https://github.com/duckdb/duckdb/pull/8727
• Change parquet_write_memory_limit.test_slow to not preserve order by @lnkuiper in https://github.com/duckdb/duckdb/pull/8746
• [Python] Pandas 2.1.0 update by @Tishj in https://github.com/duckdb/duckdb/pull/8738
• bump codecov by @Maxxen in https://github.com/duckdb/duckdb/pull/8751
• Order Describe table with column id by @pdet in https://github.com/duckdb/duckdb/pull/8729
• CSV Read: move buffer initialisation to thread local by @pdet in https://github.com/duckdb/duckdb/pull/8672
• Distinct/order modifier column deduplication by @lnkuiper in https://github.com/duckdb/duckdb/pull/8748
• Autoloading mechanism for extensions by @samansmink in https://github.com/duckdb/duckdb/pull/8732
• duckspark, implement createOrReplaceTempView by @hannes in https://github.com/duckdb/duckdb/pull/8759
• Extension load tests: fix-up b014b6919 by @carlopi in https://github.com/duckdb/duckdb/pull/8775
• Apply patches and bump extensions by @carlopi in https://github.com/duckdb/duckdb/pull/8765
• Fuzzer #936: Sort Key Exceptions by @hawkfish in https://github.com/duckdb/duckdb/pull/8773
• CSV Sniffer - State Machine by @pdet in https://github.com/duckdb/duckdb/pull/8253
• [Dev] Untangle some really obfuscated code in ReorderTableEntries by @Tishj in https://github.com/duckdb/duckdb/pull/8707
• Use manylinux_2_24 image for Linux aarch64 Python builds by @Mause in https://github.com/duckdb/duckdb/pull/8770
• Radix Partitioned Hash Table Rework by @lnkuiper in https://github.com/duckdb/duckdb/pull/8475
• Issue #7809: Parallel Partition Sorting by @hawkfish in https://github.com/duckdb/duckdb/pull/8593
• Add the ability to access file_path in FileOpener by @stephaniewang526 in https://github.com/duckdb/duckdb/pull/8484
• CAPI: Make it possible to create struct types by @alnkesq in https://github.com/duckdb/duckdb/pull/8455
• Serialization pt 3: mega follow-up by @Maxxen in https://github.com/duckdb/duckdb/pull/8752
• Remove patches and bump dependecies (aws & iceberg) by @carlopi in https://github.com/duckdb/duckdb/pull/8777
• [Python] DuckDB -> Pandas | NULL -> str becomes None instead of 'NaN' by @Tishj in https://github.com/duckdb/duckdb/pull/8745
• [PythonDev] Add timeout to test_multithread.py by @Tishj in https://github.com/duckdb/duckdb/pull/8747
• Bump uncovered_files.csv by @carlopi in https://github.com/duckdb/duckdb/pull/8790
• Avoid rounding down buffer block sizes to uint32_t by @lnkuiper in https://github.com/duckdb/duckdb/pull/8785
• Duckdb wasm loadable fixes by @carlopi in https://github.com/duckdb/duckdb/pull/8766
• [Dev] Handle SKIP_EXTENSIONS as early return in duckdb_extension_load by @carlopi in https://github.com/duckdb/duckdb/pull/8781
• Fix R ci by @Tmonster in https://github.com/duckdb/duckdb/pull/8783
• Switching to twine token and remove cleanup job by @hannes in https://github.com/duckdb/duckdb/pull/8792
• Moving R client out of main source tree by @hannes in https://github.com/duckdb/duckdb/pull/8793
• Re-add pypi-cleanup script and use pypi-cleanup package for deleting dev packages by @Mytherin in https://github.com/duckdb/duckdb/pull/8795
• Fix #8797: Fix off-by-one in varchar -> list conversion code causing out-of-bounds access by @Mytherin in https://github.com/duckdb/duckdb/pull/8799
• Add "ends_with" as an alias of "suffix" by @holdenmatt in https://github.com/duckdb/duckdb/pull/8807
• [Dev] Pass explicitly USE_MERGED_VCPKG_MANIFEST by @carlopi in https://github.com/duckdb/duckdb/pull/8806
• #7412 add sha256 scalar function by @jdnvn in https://github.com/duckdb/duckdb/pull/8723
• Extension docs by @carlopi in https://github.com/duckdb/duckdb/pull/8784
• Fix Python Release Clean-up: need to install requests module by @Mytherin in https://github.com/duckdb/duckdb/pull/8811
• Very minor fixes of CI problems by @carlopi in https://github.com/duckdb/duckdb/pull/8809
• Fix "Too many open files" issues by @lnkuiper in https://github.com/duckdb/duckdb/pull/8812
• Add list_cosine_similarity, list_distance, list_inner_product by @Maxxen in https://github.com/duckdb/duckdb/pull/8750
• Towards stable storage of indexes and the ART by @taniabogatsch in https://github.com/duckdb/duckdb/pull/8703
• JSON bugfixes by @lnkuiper in https://github.com/duckdb/duckdb/pull/8810
• Issue template: Ask contributors to avoid using screenshots in issue reports by @szarnyasg in https://github.com/duckdb/duckdb/pull/8829
• [PythonDev] Remove version lock on adbc_driver_manager by @Tishj in https://github.com/duckdb/duckdb/pull/8725
• Internal #215: Serial Unordered Scans by @hawkfish in https://github.com/duckdb/duckdb/pull/8824
• [Generated Column] Return stringified generated expression in duckdb_columns by @Tishj in https://github.com/duckdb/duckdb/pull/8835
• Extension API: Allow autoloading of extensions dependencies & use it for duckdb_aws by @carlopi in https://github.com/duckdb/duckdb/pull/8839
• Remove references to duckdb_query_graph by @szarnyasg in https://github.com/duckdb/duckdb/pull/8826
• DuckDB-Wasm fixes related to (auto)loadable extensions by @carlopi in https://github.com/duckdb/duckdb/pull/8827
• Revert "Use manylinux_2_24 image for Linux aarch64 Python builds" by @Mause in https://github.com/duckdb/duckdb/pull/8849
• fix(nodejs): thread safety between node instances in single process by @Mause in https://github.com/duckdb/duckdb/pull/8862
• fix: remove TODO's in Node docs by @Mause in https://github.com/duckdb/duckdb/pull/8861
• Switch over to new Serialization Framework by @Mytherin in https://github.com/duckdb/duckdb/pull/8863
• Fixes to error messages: An error occurred ... by @carlopi in https://github.com/duckdb/duckdb/pull/8855
• Attempt at fixing OSX Extensions Release nightly build failures by @carlopi in https://github.com/duckdb/duckdb/pull/8847
• Internal #164: Single Partition Sorting by @hawkfish in https://github.com/duckdb/duckdb/pull/8791
• [Python] Add Expression class by @Tishj in https://github.com/duckdb/duckdb/pull/8469
• Partial Blocks for Index Serialization by @taniabogatsch in https://github.com/duckdb/duckdb/pull/8825
• Update create_package.py for new extension defines by @Mause in https://github.com/duckdb/duckdb/pull/8870
• Wasm extension signing by @carlopi in https://github.com/duckdb/duckdb/pull/8881
• DuckDB-Wasm workflow: Fix syntax by @carlopi in https://github.com/duckdb/duckdb/pull/8883
• Expose SeekPosition in HTTPFS by @Maxxen in https://github.com/duckdb/duckdb/pull/8876
• DuckDB-Wasm workflow: fixes by @carlopi in https://github.com/duckdb/duckdb/pull/8885
• DuckDB-Wasm workflow: Pass on token and secret by @carlopi in https://github.com/duckdb/duckdb/pull/8886
• Use lock when accessing the http metadata cache by @pdet in https://github.com/duckdb/duckdb/pull/8882
• DuckDB-Wasm workflow: Uncomment line by @carlopi in https://github.com/duckdb/duckdb/pull/8887
• Rework Storage of Deletions - Allow for lazy loading and incremental re-writing of deletions by @Mytherin in https://github.com/duckdb/duckdb/pull/8869
• Fix for #8440 by @pdet in https://github.com/duckdb/duckdb/pull/8879
• Issue #8316: Time Cast Statistics by @hawkfish in https://github.com/duckdb/duckdb/pull/8888
• Sqlite commands fixes by @Tmonster in https://github.com/duckdb/duckdb/pull/8848
• Fuzzer #838: Julian DATE Overflow by @hawkfish in https://github.com/duckdb/duckdb/pull/8677
• Remove support for NodeJS 10 by @Mause in https://github.com/duckdb/duckdb/pull/8872
• DuckDB-Wasm workflow: Add credentials explicitly by @carlopi in https://github.com/duckdb/duckdb/pull/8889
• fix some nodejs tests in some envs by @jraymakers in https://github.com/duckdb/duckdb/pull/8774
• Fix link in extension/README.md by @isaacbrodsky in https://github.com/duckdb/duckdb/pull/8904
• [Fix] Verification that CSV File exceed line sizes. by @pdet in https://github.com/duckdb/duckdb/pull/8892
• Add R CMD Check workflow back for duckdb src PRs by @Tmonster in https://github.com/duckdb/duckdb/pull/8845
• DuckDB-Wasm workflow: moving to official repo by @carlopi in https://github.com/duckdb/duckdb/pull/8918
• Fix #8895: Reading .csv.zst files depends on parquet extension (check… by @carlopi in https://github.com/duckdb/duckdb/pull/8906
• ART fixes - no more empty buffers and correctly serializing parsed expressions by @taniabogatsch in https://github.com/duckdb/duckdb/pull/8912
• fix(jdbc): uniform exception handling by @Mause in https://github.com/duckdb/duckdb/pull/8685
• Wrap failing shell-test so it is not tested on windows. by @Tmonster in https://github.com/duckdb/duckdb/pull/8923
• Fix R CMD BUILD script. by @Tmonster in https://github.com/duckdb/duckdb/pull/8921
• Point to R package repo for new issues by @krlmlr in https://github.com/duckdb/duckdb/pull/8919
• [Dev] Only emit ConstantVectors when scan_vector is invoked by @Tishj in https://github.com/duckdb/duckdb/pull/8916
• [Dev] Fix signing scripts so they can be called from arbitrary locations by @carlopi in https://github.com/duckdb/duckdb/pull/8935
• Detect Header columns with nullpadding by @pdet in https://github.com/duckdb/duckdb/pull/8915
• [Parquet | ExportDatabase] Deal with unsupported parquet types in EXPORT DATABASE. by @Tishj in https://github.com/duckdb/duckdb/pull/8798
• Issue: #8932 Fix description in empty_needle_removal.hpp by @Light-City in https://github.com/duckdb/duckdb/pull/8933
• Fuzzer fixes by @Tmonster in https://github.com/duckdb/duckdb/pull/8920
• Add ordering to to underspecified tests by @lnkuiper in https://github.com/duckdb/duckdb/pull/8819
• Add rowcount property for Python cursor objects by @hannes in https://github.com/duckdb/duckdb/pull/8911
• Various fixes for very large (overflow) strings by @Mytherin in https://github.com/duckdb/duckdb/pull/8943
• [PythonDev] Protect test_replacement_scan.py from side effects by @Tishj in https://github.com/duckdb/duckdb/pull/8953
• remove redundant code by @gitccl in https://github.com/duckdb/duckdb/pull/8946
• fix(nodejs): wait to write all data to disk before calling back by @Mause in https://github.com/duckdb/duckdb/pull/8843
• [Python Arrow] Fix issue related to TIMESTAMP_TZ and filter pushdown into PyArrow by @Tishj in https://github.com/duckdb/duckdb/pull/8856
• Add PRAGMA metadata_info that displays info about the storage of metadata, and correctly write free metadata blocks by @Mytherin in https://github.com/duckdb/duckdb/pull/8956
• DuckDB-Wasm: Custom repository to be served over https by @carlopi in https://github.com/duckdb/duckdb/pull/8960
• [PythonDev] Merge pyduckdb module into duckdb by @Tishj in https://github.com/duckdb/duckdb/pull/8959
• [Python] Extend show with keyword arguments to set BoxRenderer options by @Tishj in https://github.com/duckdb/duckdb/pull/8954
• Bump aws (removing patches) & spatial to latest commits by @carlopi in https://github.com/duckdb/duckdb/pull/8936
• [Python] Fix issue with dtype parameter in the read_csv method. by @Tishj in https://github.com/duckdb/duckdb/pull/8387
• Update logo by @szarnyasg in https://github.com/duckdb/duckdb/pull/8970
• [Python] Add 'names' option to read_csv by @Tishj in https://github.com/duckdb/duckdb/pull/8967
• Allow JSON reader to sample across multiple files by @lnkuiper in https://github.com/duckdb/duckdb/pull/8891
• Fix typos and update variable type info in Contributing.md by @thfmn in https://github.com/duckdb/duckdb/pull/8975
• Fix outdated C API docs by @ocadaruma in https://github.com/duckdb/duckdb/pull/8973
• CSV Parallel Tests CI by @pdet in https://github.com/duckdb/duckdb/pull/8910
• Truncate the db file before the WAL for differential storage by @Y-- in https://github.com/duckdb/duckdb/pull/8980
• Fix #8592: correctly deal with torn writes by ignoring SerializationException during initial read by @Mytherin in https://github.com/duckdb/duckdb/pull/8982
• Fixes for CSV And Aggregate Nightly Build Issues by @pdet in https://github.com/duckdb/duckdb/pull/8852
• Internal #317: Fix foreach Label by @hawkfish in https://github.com/duckdb/duckdb/pull/8987
• httpfs: Avoid corruptions with servers sending more data than asked for by @carlopi in https://github.com/duckdb/duckdb/pull/8940
• Move arrow, postgres_scanner and sqlite_scanner to be autoloadable by @carlopi in https://github.com/duckdb/duckdb/pull/8966
• Fix some fuzzer issues by @lnkuiper in https://github.com/duckdb/duckdb/pull/8871
• ART fixes by @taniabogatsch in https://github.com/duckdb/duckdb/pull/8995
• [ODBC] Error Management Improvement by @maiadegraaf in https://github.com/duckdb/duckdb/pull/8939
• fix(nodejs): cpp exception handling by @Mause in https://github.com/duckdb/duckdb/pull/8994
• [PythonDev][Docs] Add missing docs for Expression methods. by @Tishj in https://github.com/duckdb/duckdb/pull/8991
• [Python][DuckSpark] Add Column and a bunch of DataFrame methods by @Tishj in https://github.com/duckdb/duckdb/pull/8990
• [JSON] Support escaping quotes in VARCHAR -> LIST cast by @Tishj in https://github.com/duckdb/duckdb/pull/8655
• Rework row matching by @lnkuiper in https://github.com/duckdb/duckdb/pull/8979
• Issue #7581: Epoch Returns Doubles by @hawkfish in https://github.com/duckdb/duckdb/pull/8963

This is a bug fix release for various issues discovered after we released 0.8.0. There are no new features, just bug fixes. Database files created by DuckDB v0.8.0 can be read by DuckDB v0.8.1 (i.e. v0.8.1 is backwards compatible with v0.8.0). Note that database files created by v0.8.1 cannot be read by DuckDB v0.8.0 (i.e. v0.8.0 is not forwards compatible with v0.8.1).

Changes

• [Julia] Update DuckDB_jll to v0.8.0 by @Mytherin in https://github.com/duckdb/duckdb/pull/7568
• CSV reader - allow parallel option to be set in COPY statement as well by @Mytherin in https://github.com/duckdb/duckdb/pull/7579
• shell: Remove .dbinfo command. by @omo in https://github.com/duckdb/duckdb/pull/7569
• Catalog::LookupEntry(): Remove unused code. by @omo in https://github.com/duckdb/duckdb/pull/7557
• Add the default scheme to the CREATE TYPE's type search path. by @omo in https://github.com/duckdb/duckdb/pull/7555
• Use std::all_of instead of raw loop in Disjoint. by @ttsugriy in https://github.com/duckdb/duckdb/pull/7549
• feat: introduce a common grammar/types file for libpgquery parser and update Python scripts to take source/target directory paths as argument by @stephaniewang526 in https://github.com/duckdb/duckdb/pull/7574
• Fix #7582 - correctly set "last_offset" in InitializeScanWithOffset and turn assertion into run-time check by @Mytherin in https://github.com/duckdb/duckdb/pull/7586
• Partially fix #7551 - throw internal exception in case of type mismatch in ExpressionExecutor by @Mytherin in https://github.com/duckdb/duckdb/pull/7587
• Fix #7602 - allow reserved keywords in named parameters by @Mytherin in https://github.com/duckdb/duckdb/pull/7604
• Fix #7599 - output a clear error message when a subquery is used in a table function that does not support it by @Mytherin in https://github.com/duckdb/duckdb/pull/7603
• Rework Code Coverage CI - Remove CodeCov and instead track uncovered lines explicitly + turn lack of coverage into a CI failure by @Mytherin in https://github.com/duckdb/duckdb/pull/7611
• Use unordered_set insert range overload. by @ttsugriy in https://github.com/duckdb/duckdb/pull/7615
• Reserve expression_costs storage. by @ttsugriy in https://github.com/duckdb/duckdb/pull/7608
• [ADBC] Testing Unhappy Paths, Fixing Memory Leaks from Error Setting, Removing Macros by @pdet in https://github.com/duckdb/duckdb/pull/7589
• Windows - path is only absolute if path starts with a single back-slash by @Mytherin in https://github.com/duckdb/duckdb/pull/7623
• Fix #7564 - if the auto-complete extension is not enabled, inline it into the shell by @Mytherin in https://github.com/duckdb/duckdb/pull/7621
• Remove 2 extra bytes from magic string pattern. by @ttsugriy in https://github.com/duckdb/duckdb/pull/7626
• Avoid unnecessary table lookup. by @ttsugriy in https://github.com/duckdb/duckdb/pull/7630
• Reserve enough storage for unbound_expressions. by @ttsugriy in https://github.com/duckdb/duckdb/pull/7627
• Increment code coverage by @Mytherin in https://github.com/duckdb/duckdb/pull/7636
• Remove all C-style casts and add clang-tidy rule to forbid them by @Mytherin in https://github.com/duckdb/duckdb/pull/7656
• Fix sql auto complete extension CI issue by @Mytherin in https://github.com/duckdb/duckdb/pull/7650
• Add missing entries to ParquetDecodeUtils::BITPACK_MASKS by @Tishj in https://github.com/duckdb/duckdb/pull/7658
• Fix: allow distinct and order by in list aggregates by @taniabogatsch in https://github.com/duckdb/duckdb/pull/7638
• Rework the AggregateExecutor interface to no longer have unnecessary pointers and arrays by @Mytherin in https://github.com/duckdb/duckdb/pull/7671
• Fix #7660 - avoid exporting the same catalog multiple times in EXPORT by @Mytherin in https://github.com/duckdb/duckdb/pull/7676
• Move BindUpdateConstraints into a virtual function that is implemented by the DuckTableEntry by @Mytherin in https://github.com/duckdb/duckdb/pull/7679
• Fix #7567 - when setting the schema to a different schema within another catalog, keep the correct catalog by @Mytherin in https://github.com/duckdb/duckdb/pull/7678
• Fix exception fmt by @carlopi in https://github.com/duckdb/duckdb/pull/7683
• Fix amalgamation build by avoiding overloading multiplication by @carlopi in https://github.com/duckdb/duckdb/pull/7661
• Fix #7659 - use correct catalog when replaying a CREATE TABLE in the WAL by @Mytherin in https://github.com/duckdb/duckdb/pull/7675
• Implement #7662 - add the "lock_configuration" setting which allows configurations to be locked down by @Mytherin in https://github.com/duckdb/duckdb/pull/7682
• Fix #7663 - add in_search_path function, correctly show temporary views in SHOW TABLES, and show views in SHOW ALL TABLES by @Mytherin in https://github.com/duckdb/duckdb/pull/7680
• expose the StripUnicodeSpaces parser utility method by @stephaniewang526 in https://github.com/duckdb/duckdb/pull/7705
• Add FuzzyDuck fuzzer - and move fuzzer CI to separate repo by @Mytherin in https://github.com/duckdb/duckdb/pull/7712
• Add missing std::move for old GCCs by @Mytherin in https://github.com/duckdb/duckdb/pull/7714
• [Dev] Fix failing assertion in python debug by @Tishj in https://github.com/duckdb/duckdb/pull/7722
• Fix crash in ArrowTableFunction::GetArrowLogicalType on Linux by @Tishj in https://github.com/duckdb/duckdb/pull/7718
• Allow core duckdb to handle unrecognized JDBC configuration by @elefeint in https://github.com/duckdb/duckdb/pull/7713
• [ADBC] Transactions and explicitly not-supporting Partition Reading/Execution by @pdet in https://github.com/duckdb/duckdb/pull/7639
• Verify that Parallel CSV Reader skips lines mid-threads by @pdet in https://github.com/duckdb/duckdb/pull/7637
• Fix issue with setup.py builds without dependencies by @samansmink in https://github.com/duckdb/duckdb/pull/7695
• [Python] Fix tests for Pandas 2.0.2 by @Tishj in https://github.com/duckdb/duckdb/pull/7726
• Code Coverage CI check - allow one uncovered line by @Mytherin in https://github.com/duckdb/duckdb/pull/7724
• Generate default_types from json files by @Tishj in https://github.com/duckdb/duckdb/pull/7646
• Fix fuzzer issues found by new fuzzer CI runs by @Mytherin in https://github.com/duckdb/duckdb/pull/7736
• [Python] Fix conversion of deeply nested dictionaries by @Tishj in https://github.com/duckdb/duckdb/pull/7739
• Fix TupleDataCollection List serialization by @lnkuiper in https://github.com/duckdb/duckdb/pull/7741
• Fuzzer #156: Copy Before Swizzle by @hawkfish in https://github.com/duckdb/duckdb/pull/7747
• Minor fixes to failing CI runs by @carlopi in https://github.com/duckdb/duckdb/pull/7768
• Fix more fuzzer issues found by new fuzzer CI by @Mytherin in https://github.com/duckdb/duckdb/pull/7759
• Add option to disable serialization by @stephaniewang526 in https://github.com/duckdb/duckdb/pull/7745
• fix(httpfs): correct listobjectv2_url for strict s3/http servers by @Mause in https://github.com/duckdb/duckdb/pull/7761
• Fuzzer #209: Multiple Scalar Blocks by @hawkfish in https://github.com/duckdb/duckdb/pull/7764
• Fuzzer #206: Fix Cast Overflow by @hawkfish in https://github.com/duckdb/duckdb/pull/7770
• More minor CI fixes by @Mytherin in https://github.com/duckdb/duckdb/pull/7779
• Add Exception on dependency verification for Enum Types and Temp Tables by @pdet in https://github.com/duckdb/duckdb/pull/7641
• Add fuzz_all_functions fuzzer, and add support for varargs to test_vector_types by @Mytherin in https://github.com/duckdb/duckdb/pull/7754
• JSON fixes by @lnkuiper in https://github.com/duckdb/duckdb/pull/7762
• [Julia] Fix issue related to table function callbacks and IO by @Tishj in https://github.com/duckdb/duckdb/pull/7783
• [Dev] Use sql in the python_regression_test.py. by @Tishj in https://github.com/duckdb/duckdb/pull/7787
• Allow core duckdb to handle unrecognized C API configuration by @elefeint in https://github.com/duckdb/duckdb/pull/7804
• Fuzzer #214: ROWS BETWEEN Overflow by @hawkfish in https://github.com/duckdb/duckdb/pull/7767
• Add tests to cover issue 5132 and enable force reload by @taniabogatsch in https://github.com/duckdb/duckdb/pull/7800
• Fuzzer #215: Timestamp Arithmetic Overflow by @hawkfish in https://github.com/duckdb/duckdb/pull/7769
• Remove grammar support for CREATE/DROP DATABASE by @stephaniewang526 in https://github.com/duckdb/duckdb/pull/7806
• Serialize: fix some uncovered cases, part 1 by @carlopi in https://github.com/duckdb/duckdb/pull/7810
• CodeCov tweaks by @carlopi in https://github.com/duckdb/duckdb/pull/7815
• fix(jdbc): arrow error handling by @Mause in https://github.com/duckdb/duckdb/pull/7814
• Fix duck fuzzer #218 and #220 by @carlopi in https://github.com/duckdb/duckdb/pull/7818
• Add msan and ubsan to cifuzz (+ fix zstd + msan) by @carlopi in https://github.com/duckdb/duckdb/pull/7813
• Art bug fixes by @taniabogatsch in https://github.com/duckdb/duckdb/pull/7801
• Check GlobalSortState for external scan in PhysicalWindow by @lnkuiper in https://github.com/duckdb/duckdb/pull/7827
• remove un-used PGNodeTag by @stephaniewang526 in https://github.com/duckdb/duckdb/pull/7833
• refactor(fsspec): remove seekable flag by @Mause in https://github.com/duckdb/duckdb/pull/6585
• Unnest_rewriter fixes by @taniabogatsch in https://github.com/duckdb/duckdb/pull/7836
• [Julia] Fix comments on #7783 by @Tishj in https://github.com/duckdb/duckdb/pull/7843
• Disable attaching on-disk DuckDB databases if external access is disabled by @Mytherin in https://github.com/duckdb/duckdb/pull/7850
• Fix #7711 - disallow detaching the currently USEd database by @Mytherin in https://github.com/duckdb/duckdb/pull/7851
• [Python] only execute in DuckDBPyRelation::Close if it was never executed before by @Tishj in https://github.com/duckdb/duckdb/pull/7844
• Add rel_from_table_function to R relational API by @hannes in https://github.com/duckdb/duckdb/pull/7823
• [Python] Fix __exit__ signature by @Tishj in https://github.com/duckdb/duckdb/pull/7849
• Several minor DuckFuzz/OssFuzz fixes by @Mytherin in https://github.com/duckdb/duckdb/pull/7848
• Enhance the generation of random floating point by PCG by @GHamrouni in https://github.com/duckdb/duckdb/pull/7842
• Fix #7795 - provide explicit alias for unnamed subquery as unpivot parameter by @Mytherin in https://github.com/duckdb/duckdb/pull/7858
• Grab Mark Join lock when using shared correlated_mark_join_info by @lnkuiper in https://github.com/duckdb/duckdb/pull/7859
• JSON Contains - correctly handle constant NULL by @Mytherin in https://github.com/duckdb/duckdb/pull/7861
• Serialize: more fixes, part 2 by @carlopi in https://github.com/duckdb/duckdb/pull/7830
• Regression.yml to check agaist GITHUB_BASE_REF by @carlopi in https://github.com/duckdb/duckdb/pull/7877
• More UNNEST fixes by @taniabogatsch in https://github.com/duckdb/duckdb/pull/7872
• Bump spatial by @Maxxen in https://github.com/duckdb/duckdb/pull/7866
• Rework test_plan_serialization_bwc to do roundtrip by @carlopi in https://github.com/duckdb/duckdb/pull/7862
• Serialize: rework signature, part 3 by @carlopi in https://github.com/duckdb/duckdb/pull/7867
• [Python] UDFs now produce the correct result when used together with range by @Tishj in https://github.com/duckdb/duckdb/pull/7876
• CI: Bump up uncovered_files.csv by @carlopi in https://github.com/duckdb/duckdb/pull/7884
• Build Python wheels for aarch64 using QEMU by @adavis444 in https://github.com/duckdb/duckdb/pull/7864
• Spurious CSV reader CI fix by @Mytherin in https://github.com/duckdb/duckdb/pull/7889
• Minor CIFixes: flatten.test, rowsort, ctz UBs by @carlopi in https://github.com/duckdb/duckdb/pull/7899
• Upgrade to latest substrait version by @pdet in https://github.com/duckdb/duckdb/pull/7886
• feat: update parser exception handling for extensions by @stephaniewang526 in https://github.com/duckdb/duckdb/pull/7868
• fix(nodejs): http state by @Mause in https://github.com/duckdb/duckdb/pull/7883
• fix pivotref comments by @douenergy in https://github.com/duckdb/duckdb/pull/7885
• Arrow buffer Size Option by @pdet in https://github.com/duckdb/duckdb/pull/7784
• Fix for table in function binding by @hannes in https://github.com/duckdb/duckdb/pull/7857
• Implement DatabaseManager::SetDefaultDatabase by @Flogex in https://github.com/duckdb/duckdb/pull/7878
• Fix #7902 - add support for blob to approx count distinct by @Mytherin in https://github.com/duckdb/duckdb/pull/7907
• Fix Issue 7278 by @lnkuiper in https://github.com/duckdb/duckdb/pull/7916
• Lift update binding logic from DuckTableEntry to TableCatalogEntry by @bleskes in https://github.com/duckdb/duckdb/pull/7874

Full Changelog: https://github.com/duckdb/duckdb/compare/v0.8.0...v0.8.1

This is a bug fix release for various issues discovered after we released 0.7.0. There are no new features, just bug fixes. Notably, there is no incompatibility with database files created with v0.7.0

Changes

• When building extensions we need to add _storage_init to the whitelist on MacOS by @Mytherin in https://github.com/duckdb/duckdb/pull/6243
• Some more read_json_auto bugfixes by @lnkuiper in https://github.com/duckdb/duckdb/pull/6244
• Fix for Thrift.h: std::iterator is deprecated by @hannes in https://github.com/duckdb/duckdb/pull/6250
• Add missing shell mode descriptions by @papparapa in https://github.com/duckdb/duckdb/pull/6256
• Fix #6255: Shell should be installed in INSTALL_BIN_DIR by @Mytherin in https://github.com/duckdb/duckdb/pull/6266
• Bump Julia to v0.7.0 by @Mytherin in https://github.com/duckdb/duckdb/pull/6280
• Skip headers in read_csv functions as well by @pdet in https://github.com/duckdb/duckdb/pull/6267
• Correctly compute Windows terminal width, and add a .maxwidth option to the shell for duckbox mode by @Mytherin in https://github.com/duckdb/duckdb/pull/6274
• Fix lateral join bug by @taniabogatsch in https://github.com/duckdb/duckdb/pull/6268
• fix: add storage_version_info entry for v0.7.0 by @Mause in https://github.com/duckdb/duckdb/pull/6279
• Fix to #5461 by @annnei in https://github.com/duckdb/duckdb/pull/6265
• CI fixes by @Mytherin in https://github.com/duckdb/duckdb/pull/6289
• [Fuzzer] Fixes fuzzer issue 11 by @Tishj in https://github.com/duckdb/duckdb/pull/6191
• Partially Fix #6253: Improve handling of timezones in the regular VARCHAR -> TIMESTAMP cast by @Mytherin in https://github.com/duckdb/duckdb/pull/6283
• Error message on no content-length header by @samansmink in https://github.com/duckdb/duckdb/pull/6293
• fixes #6238 by @rpbouman in https://github.com/duckdb/duckdb/pull/6239
• fixes #6236 by @rpbouman in https://github.com/duckdb/duckdb/pull/6252
• Missing extension exceptions by @lverdoes in https://github.com/duckdb/duckdb/pull/6294
• feat: allow extensions to implement CREATE/DROP DATABASE by @rjatwal in https://github.com/duckdb/duckdb/pull/6115
• fix(python): python object types in stubs by @Mause in https://github.com/duckdb/duckdb/pull/5732
• Fix UPSERT binding issue related to the source table_index by @Tishj in https://github.com/duckdb/duckdb/pull/6275
• fix: DESCRIBE does not show primary key by @gkaretka in https://github.com/duckdb/duckdb/pull/6068
• Fix #6276: avoid transforming the root arg of a case expression multiple times by @Mytherin in https://github.com/duckdb/duckdb/pull/6300
• More read_json(_auto) bugfixes by @lnkuiper in https://github.com/duckdb/duckdb/pull/6281
• JDBC: Expand Blob, add UUID support by @MariusVolkhart in https://github.com/duckdb/duckdb/pull/6302
• CMake: Move from GREATER_EQUAL to GREATER, fixing #5528 by @carlopi in https://github.com/duckdb/duckdb/pull/6310
• Implement #6003 - add names option to CSV reader by @Mytherin in https://github.com/duckdb/duckdb/pull/6308
• CI: Test for cron based workflows by @carlopi in https://github.com/duckdb/duckdb/pull/6311
• CI Fix + match tests on less specific error messages by @Mytherin in https://github.com/duckdb/duckdb/pull/6320
• Fix #6314: select correct block index in IEJoin - and fix issues with left/right IE join resuming in case of multiple matches by @Mytherin in https://github.com/duckdb/duckdb/pull/6323
• CI: all workflows moved to nightly by @carlopi in https://github.com/duckdb/duckdb/pull/6334
• Fixes #6315: keep names/types around so description can be used after result is closed by @Mytherin in https://github.com/duckdb/duckdb/pull/6326
• Fix #5800: add missing Copy() calls, and add ALTERNATE_VERIFY method to verify Copy of INSERT/UPDATE/DELETE/COPY statements by @Mytherin in https://github.com/duckdb/duckdb/pull/6327
• Apply lower casing to extension aliases by @Mytherin in https://github.com/duckdb/duckdb/pull/6331
• Fix #6304: correctly handle NULL partitions and constant vectors, plus handle default parameters in COPY by @Mytherin in https://github.com/duckdb/duckdb/pull/6336
• [Python] DuckDBPyRelation: Change explain method and add sql method by @Tishj in https://github.com/duckdb/duckdb/pull/6287
• Fix Polars CI and properly implement check_ methods in the dataframes by @pdet in https://github.com/duckdb/duckdb/pull/6347
• Fixing a clang16 problem that slipped through by @hannes in https://github.com/duckdb/duckdb/pull/6345
• Fix #6341: LEFT/RIGHT/OUTER join on condition that is always true is only equal to a cross product if the other side is not empty by @Mytherin in https://github.com/duckdb/duckdb/pull/6342
• CI: Skip any CI on branches named 'feature' or 'master' by @carlopi in https://github.com/duckdb/duckdb/pull/6350
• Add correct bail-out to CSV auto-detection on oddly/inconsistently formatted CSV files by @Mytherin in https://github.com/duckdb/duckdb/pull/6330
• CI: Invert path-ignore for tools folders by @carlopi in https://github.com/duckdb/duckdb/pull/6353
• NULLs sort last in relational by @krlmlr in https://github.com/duckdb/duckdb/pull/5994
• Properly deal with Star (*) expressions in COPY ... (FORMAT JSON) by @lnkuiper in https://github.com/duckdb/duckdb/pull/6319
• fixes #6227 by @rpbouman in https://github.com/duckdb/duckdb/pull/6230
• fix typos in dictionary_store_worst_case.benchmark by @hnjylwb in https://github.com/duckdb/duckdb/pull/6371
• Julia: Support change timezone config by @xcaptain in https://github.com/duckdb/duckdb/pull/6358
• Paths-ignore on push by @carlopi in https://github.com/duckdb/duckdb/pull/6363
• JDBC - Add separate treatment for timestamptz values by @Jens-H in https://github.com/duckdb/duckdb/pull/6364
• bugfix: switch to fsspec's strip protocol impl by @Mause in https://github.com/duckdb/duckdb/pull/6361
• Disable tidy on ODBC for now by @Mytherin in https://github.com/duckdb/duckdb/pull/6379
• Implements function "sqlite3_column_table_name" for the sqlite3 wrapper by @TinyTinni in https://github.com/duckdb/duckdb/pull/6385
• [Python] No jemalloc for successful build on android by @papparapa in https://github.com/duckdb/duckdb/pull/6383
• throw BinderException on empty list in percentile by @samansmink in https://github.com/duckdb/duckdb/pull/6378
• Add optimizer flag to R and Python Substrait api by @LindsayWray in https://github.com/duckdb/duckdb/pull/6097
• fixes #6269 by @rpbouman in https://github.com/duckdb/duckdb/pull/6291
• Java: Use automatic resource management for AutoCloseable types by @MariusVolkhart in https://github.com/duckdb/duckdb/pull/6377
• Fix progress bar in (parallel) CSV reader by @Mytherin in https://github.com/duckdb/duckdb/pull/6397
• Fix #6393: for DESCRIBE order by column_index instead of column_name by @Mytherin in https://github.com/duckdb/duckdb/pull/6398
• ART (bug) fixes by @taniabogatsch in https://github.com/duckdb/duckdb/pull/6396
• [NodeJS] Support multi-statement prepare by @Tishj in https://github.com/duckdb/duckdb/pull/6278
• Java: Use StringBuilder where appropriate by @MariusVolkhart in https://github.com/duckdb/duckdb/pull/6373
• Bitpacking bug by @samansmink in https://github.com/duckdb/duckdb/pull/6402
• bugfix(fsspec): missing fs methods by @Mause in https://github.com/duckdb/duckdb/pull/6395
• Auto-load HTTPFS extension when http(s)/s3 files are queried and it is not loaded + upgrade SQLite scanner version/other extension fixes by @Mytherin in https://github.com/duckdb/duckdb/pull/6401
• Add helpful error message if a setting from an extension is attempted to be set when the extension is not loaded by @Mytherin in https://github.com/duckdb/duckdb/pull/6406
• namespace typos in blocking concurrent queue by @csruiliu in https://github.com/duckdb/duckdb/pull/6408
• Java: Implement DatabaseMetaData#isReadOnly() by @MariusVolkhart in https://github.com/duckdb/duckdb/pull/6375
• CI fixes by @carlopi in https://github.com/duckdb/duckdb/pull/6414
• Parquet: for DELTA_BYTE_ARRAY encoding verify that lengths of subsequent arrays do not exceed length of BYTE_ARRAY by @Mytherin in https://github.com/duckdb/duckdb/pull/6412
• Fix #6235: correctly return catalog for views in information_schema by @Mytherin in https://github.com/duckdb/duckdb/pull/6413
• Enable CMAKE_EXPORT_COMPILE_COMMANDS ON default by @JackDrogon in https://github.com/duckdb/duckdb/pull/6394
• Fix #5878: only delete the temp directory if we created it, otherwise delete only our temp files by @Mytherin in https://github.com/duckdb/duckdb/pull/6425
• Fix under-specified test by @Mytherin in https://github.com/duckdb/duckdb/pull/6419
• fix: logic fix to allow storage extension to implement DROP DATABASE by @stephaniewang526 in https://github.com/duckdb/duckdb/pull/6430
• Map bug combo of const & non-const lists by @LindsayWray in https://github.com/duckdb/duckdb/pull/6354
• Issue #6272: Window Scaled Repartitioning by @hawkfish in https://github.com/duckdb/duckdb/pull/6366
• respect column order for partitioned write by @samansmink in https://github.com/duckdb/duckdb/pull/6436
• Properly initialize string vector when reading large JSON arrays of strings by @lnkuiper in https://github.com/duckdb/duckdb/pull/6437
• Fix #6420 - correctly delete temporary files that are not explicitly read back but just dropped by @Mytherin in https://github.com/duckdb/duckdb/pull/6424
• Julia: support Pkg.test() by @chris-b1 in https://github.com/duckdb/duckdb/pull/6431
• fixes sqlite3_column_bytes nullptr access on some call ordering by @TinyTinni in https://github.com/duckdb/duckdb/pull/6409
• Write struct fields as optionally quoted in EXPORT DATABASE by @Tishj in https://github.com/duckdb/duckdb/pull/6416
• Enables sqlite3 wrapper tests for win32 builds by @TinyTinni in https://github.com/duckdb/duckdb/pull/6427
• Adding separate extension_directory configuration setting by @hannes in https://github.com/duckdb/duckdb/pull/6355
• Preserving replacement_open functionality by @rjatwal in https://github.com/duckdb/duckdb/pull/6449
• [Dev] Add documentation for s3 tests to the extensions/httpfs folder by @Tishj in https://github.com/duckdb/duckdb/pull/6418
• [Python] Fix bug that caused a crash on conversion to arrow by @Tishj in https://github.com/duckdb/duckdb/pull/6441
• Disable operator cache for pull by @samansmink in https://github.com/duckdb/duckdb/pull/6435
• [Python] Add to_table and to_view alias by @Tishj in https://github.com/duckdb/duckdb/pull/6455
• Improve error message similarity score by using a weighted levenshtein that penalizes non-equal characters more than additions/deletions by @Mytherin in https://github.com/duckdb/duckdb/pull/6457
• Fix cardinality estimation memoization bug by @jniewerth in https://github.com/duckdb/duckdb/pull/6456
• R: Fix protection errors for relational API by @krlmlr in https://github.com/duckdb/duckdb/pull/6469
• R: Reenable and stabilize tests by @krlmlr in https://github.com/duckdb/duckdb/pull/6474
• Fix multipart upload by @samansmink in https://github.com/duckdb/duckdb/pull/6439
• Fix #6062 (UBSan) by changing order of operations by @carlopi in https://github.com/duckdb/duckdb/pull/6472
• Add split_part function (from Postgres) by @Alex-Monahan in https://github.com/duckdb/duckdb/pull/6471
• Auto Install Extensions when opening a database that requires certain extensions by @Mytherin in https://github.com/duckdb/duckdb/pull/6479

This preview release of DuckDB is named "Labradorius" after the Labrador duck (Camptorhynchus labradorius) which was native to North America and went extinct in 1878 despite its reportedly bad taste.

Again, @Mytherin has written a blog post explaining the exciting list of new features in this release.

Binary builds are listed at the bottom of this post. Please note that it can take a couple of hours until binary builds for all platforms and environments are available.

Note: Again, this release introduces a backwards-incompatible change to the on-disk storage format. We suggest you use the EXPORT DATABASE command with the old version followed by IMPORT DATABASE with the new version to migrate your data. See the documentation for details.

What's Changed

• Use structs to avoid confusing C pointer wrappers by @krlmlr in https://github.com/duckdb/duckdb/pull/4961
• Enum type added to the types metadata table by @LindsayWray in https://github.com/duckdb/duckdb/pull/5290
• R: code format by @krlmlr in https://github.com/duckdb/duckdb/pull/5185
• Add starts_with function and operator by @papparapa in https://github.com/duckdb/duckdb/pull/5334
• Feature: Allow binary-formatted strings to be cast to integers by @Maxxen in https://github.com/duckdb/duckdb/pull/5337
• For range joins use NL join when the LHS or RHS side is tiny by @Mytherin in https://github.com/duckdb/duckdb/pull/5399
• Add support for LATERAL joins by @Mytherin in https://github.com/duckdb/duckdb/pull/5393
• [Julia] Add support for consuming a UNION vector into a DataFrame by @Tishj in https://github.com/duckdb/duckdb/pull/5360
• Issue #5314: At Time Zone by @hawkfish in https://github.com/duckdb/duckdb/pull/5341
• Decimal values now round when the value given has more decimals than the scale of the target by @Tishj in https://github.com/duckdb/duckdb/pull/5362
• Shell: add individual SQL queries to the history, instead of individual lines by @Mytherin in https://github.com/duckdb/duckdb/pull/5414
• Shell: add support for history search by @Mytherin in https://github.com/duckdb/duckdb/pull/5415
• Parallelise scanning result of ORDER_BY by @lnkuiper in https://github.com/duckdb/duckdb/pull/5403
• Add translate function by @zhouliqi in https://github.com/duckdb/duckdb/pull/5212
• Enable cmake to recognize AppleClang by @changhiskhan in https://github.com/duckdb/duckdb/pull/5432
• Support enum_code() function by @lokax in https://github.com/duckdb/duckdb/pull/5408
• Fix binder error and produce more informative error message. by @Tmonster in https://github.com/duckdb/duckdb/pull/5302
• Parquet Reader: Re-use (de)compression and dictionary buffers and allocate powers of two by @Mytherin in https://github.com/duckdb/duckdb/pull/5445
• Support RLE, DELTA_BYTE_ARRAY and DELTA_LENGTH_BYTE_ARRAY Parquet encodings by @Mytherin in https://github.com/duckdb/duckdb/pull/5457
• print profiling output for deserialized logical query plans by @ila in https://github.com/duckdb/duckdb/pull/5448
• Issue #5277: Sorted Aggregate Sorting by @hawkfish in https://github.com/duckdb/duckdb/pull/5456
• Add internal flag to duckdb_functions, and correctly set internal flag for internal functions by @Mytherin in https://github.com/duckdb/duckdb/pull/5462
• Add experimental R String passthrough support by @hannes in https://github.com/duckdb/duckdb/pull/5479
• Issue #5258: Quantile Negative Fractions by @hawkfish in https://github.com/duckdb/duckdb/pull/5463
• Arrow stream ingestion for JDBC client by @hannes in https://github.com/duckdb/duckdb/pull/5449
• PER_THREAD_OUTPUT flag for COPY by @hannes in https://github.com/duckdb/duckdb/pull/5412
• Feature: skip broken tests for now by @Mytherin in https://github.com/duckdb/duckdb/pull/5532
• Add Union All support to R extention by @Tmonster in https://github.com/duckdb/duckdb/pull/5484
• [Python] Add from_parquet features by @papparapa in https://github.com/duckdb/duckdb/pull/5492
• Add ExtractStatements to C API by @LindsayWray in https://github.com/duckdb/duckdb/pull/5524
• Improve http retry by @samansmink in https://github.com/duckdb/duckdb/pull/5549
• Issue #5277: Sorted Aggregate Window by @hawkfish in https://github.com/duckdb/duckdb/pull/5571
• Issue #5422: QUANTILE_DESC Decimals by @hawkfish in https://github.com/duckdb/duckdb/pull/5572
• Issue #5559: 2022g Time Zones by @hawkfish in https://github.com/duckdb/duckdb/pull/5570
• [Dev] Clean up of the python pkg folder structure by @Tishj in https://github.com/duckdb/duckdb/pull/5436
• httpfs: check environment vars for AWS Credentials by @satotake in https://github.com/duckdb/duckdb/pull/5419
• Misc union-type improvements by @Maxxen in https://github.com/duckdb/duckdb/pull/5617
• Fix so Left inner join doesn't re-optimize nodes by @Tmonster in https://github.com/duckdb/duckdb/pull/5620
• [Substrait] C API + from_substrait_json + bump on substrait version. by @pdet in https://github.com/duckdb/duckdb/pull/5613
• Allow strings in ColumnDataCollection to be written to disk by @lnkuiper in https://github.com/duckdb/duckdb/pull/5543
• [PythonDEV] Let clean.sh be run from anywhere, not just tools/pythonpkg by @Tishj in https://github.com/duckdb/duckdb/pull/5625
• Reorganize Join order optimizer code by @Tmonster in https://github.com/duckdb/duckdb/pull/5621
• [Catalog] Grab missing write_locks in a couple places by @Tishj in https://github.com/duckdb/duckdb/pull/5601
• Parquet info to Substrait by @pdet in https://github.com/duckdb/duckdb/pull/5627
• HTTP parquet optimizations by @samansmink in https://github.com/duckdb/duckdb/pull/5405
• Adding delta compression to Bitpacking compression by @samansmink in https://github.com/duckdb/duckdb/pull/5491
• [Python] Changed use of DuckDBPyConnection to shared_ptr by @Tishj in https://github.com/duckdb/duckdb/pull/5635
• Merge feature branch into master by @Mytherin in https://github.com/duckdb/duckdb/pull/5645
• [Python] Display progress bar by default in an interactive environment by @Tishj in https://github.com/duckdb/duckdb/pull/5596
• Add support for RESET statement on configuration options by @Tishj in https://github.com/duckdb/duckdb/pull/5603
• httpfs: Encode url path on request by @satotake in https://github.com/duckdb/duckdb/pull/5587
• Fix broken CI because of RESET statement by @Tishj in https://github.com/duckdb/duckdb/pull/5671
• Don't automatically set the bug label on issues by @Mytherin in https://github.com/duckdb/duckdb/pull/5680
• Add support for CREATE VIEW IF NOT EXISTS by @Mytherin in https://github.com/duckdb/duckdb/pull/5682
• Issue #5622: Validate Timezone Characters by @hawkfish in https://github.com/duckdb/duckdb/pull/5658
• Issue 5630 fix. by @Tmonster in https://github.com/duckdb/duckdb/pull/5644
• Adding COLUMN_TYPES option for read_csv_auto by @pdet in https://github.com/duckdb/duckdb/pull/5552
• [Python] Get rid of DuckDBPyResult (merged functionality into DuckDBPyRelation) by @Tishj in https://github.com/duckdb/duckdb/pull/5597
• feat: port nodejs tests to typescript by @Mause in https://github.com/duckdb/duckdb/pull/5632
• Improve nodejs README by @Tishj in https://github.com/duckdb/duckdb/pull/5688
• [Python] Add (partial) support for numpy.datetime64 objects by @Tishj in https://github.com/duckdb/duckdb/pull/5659
• retry on all httplib errors by @samansmink in https://github.com/duckdb/duckdb/pull/5684
• Return false if file doesn't exist by @Y-- in https://github.com/duckdb/duckdb/pull/5701
• Adding context option to not run replacement scans and exporting namespace of json substrait function - R by @pdet in https://github.com/duckdb/duckdb/pull/5689
• Issue #5609: Scope CTE Windows by @hawkfish in https://github.com/duckdb/duckdb/pull/5690
• Attempt to fix random NodeJS CI failure by @Tishj in https://github.com/duckdb/duckdb/pull/5710
• [Python] duckdb.execute() == duckdb.default_connection.execute() by @Tishj in https://github.com/duckdb/duckdb/pull/5650
• NodeJS: switch to using package_build, and add support to BUILD_NODE to Makefile by @Mytherin in https://github.com/duckdb/duckdb/pull/5691
• JDBC SNAPSHOT Jars by @hannes in https://github.com/duckdb/duckdb/pull/5687
• Fix NodeJS 19 CI for Windows by @Tishj in https://github.com/duckdb/duckdb/pull/5719
• Fix issue 5664 by @lokax in https://github.com/duckdb/duckdb/pull/5667
• Issue #5712: CURRENT_TIMESTAMP and CURRENT_TIME by @hawkfish in https://github.com/duckdb/duckdb/pull/5713
• [CSVReader] Catch a user error in supplying 'columns' option by @Tishj in https://github.com/duckdb/duckdb/pull/5721
• Improve suggestions when LOAD of an extension fails by @Mytherin in https://github.com/duckdb/duckdb/pull/5722
• doc(nodejs): amend arrow stream type docs by @Mause in https://github.com/duckdb/duckdb/pull/5731
• Fix for TSV throwing during sniffing by @pdet in https://github.com/duckdb/duckdb/pull/5555
• Statically link extensions on Linux with Clang by @jkub in https://github.com/duckdb/duckdb/pull/5653
• [Python] Add support for named parameters by @Tishj in https://github.com/duckdb/duckdb/pull/5611
• fix: nodejs source releases should be standalone by @Mause in https://github.com/duckdb/duckdb/pull/5734
• build: don't install python from chocolatey by @Mause in https://github.com/duckdb/duckdb/pull/5740
• fix: use non-string-splitting variable interpolation in binding.gyp.in by @Mause in https://github.com/duckdb/duckdb/pull/5745
• Equalizing DBConfig constructors by @nicku33 in https://github.com/duckdb/duckdb/pull/5747
• We should not treat replacement open paths as disk paths by @nicku33 in https://github.com/duckdb/duckdb/pull/5748
• Allow table in-out functions to be used in correlated subqueries and as LATERAL queries by @Mytherin in https://github.com/duckdb/duckdb/pull/5485
• Issue #5750: clangd std::move by @hawkfish in https://github.com/duckdb/duckdb/pull/5751
• Always parallelize CSV reader when run over multiple files, and several other fixes by @Mytherin in https://github.com/duckdb/duckdb/pull/5757
• Add C++ ODBC tests framework by @Mytherin in https://github.com/duckdb/duckdb/pull/5755
• Fix #5730: document older DuckDB versions internally, and state which DuckDB version a specific file came from by @Mytherin in https://github.com/duckdb/duckdb/pull/5758
• Add support for non-order preserving parallel writing to the CSV and Parquet writers by @Mytherin in https://github.com/duckdb/duckdb/pull/5756
• Don't compute SHA if we allow unsigned extensions by @Y-- in https://github.com/duckdb/duckdb/pull/5760
• Maintain BlockHandle of meta blocks by BlockManager by @Hzc492 in https://github.com/duckdb/duckdb/pull/5699
• Imdb benchmark validation and benchmark improvements by @Tmonster in https://github.com/duckdb/duckdb/pull/5693
• Add support for attaching multiple DuckDB Databases by @Mytherin in https://github.com/duckdb/duckdb/pull/5764
• Fix #5744: Correctly read "compressed" flag in Parquet V2 header by @Mytherin in https://github.com/duckdb/duckdb/pull/5767
• Fix issue 5646 by @lokax in https://github.com/duckdb/duckdb/pull/5652
• Remove icu from ignored directories when formatted by @papparapa in https://github.com/duckdb/duckdb/pull/5765
• Correctly throw an error when attaching over HTTPFS by @Mytherin in https://github.com/duckdb/duckdb/pull/5773
• JDBC add getLong method for timestamp columns by @Jens-H in https://github.com/duckdb/duckdb/pull/5783
• Issue #5776: ISO Year Corrections by @hawkfish in https://github.com/duckdb/duckdb/pull/5796
• Issue #5669: Advance NULL Pointers by @hawkfish in https://github.com/duckdb/duckdb/pull/5793
• Issue #5791: TIMESTAMP/TIMESTAMPTZ Casting by @hawkfish in https://github.com/duckdb/duckdb/pull/5801
• Issue #4121: INTERVAL List Search by @hawkfish in https://github.com/duckdb/duckdb/pull/5805
• Fix incorrect file name in icu-timezone.hpp comment by @papparapa in https://github.com/duckdb/duckdb/pull/5784
• Fully Qualified s3url request with globs by @LindsayWray in https://github.com/duckdb/duckdb/pull/5774
• Map restructure by @LindsayWray in https://github.com/duckdb/duckdb/pull/5768
• Issue #5806: Count Star Window by @hawkfish in https://github.com/duckdb/duckdb/pull/5810
• S3 uploader fixes by @samansmink in https://github.com/duckdb/duckdb/pull/5769
• fix for FSST segfault by @samansmink in https://github.com/duckdb/duckdb/pull/5824
• Issue: #5717: SetValue TIMESTAMP Case by @hawkfish in https://github.com/duckdb/duckdb/pull/5804
• Remove unnecessary code modifying the validity mask of the child vectors of a struct by @Mytherin in https://github.com/duckdb/duckdb/pull/5844
• Add date part specifier synonyms by @papparapa in https://github.com/duckdb/duckdb/pull/5845
• Add non ICU time_bucket function by @papparapa in https://github.com/duckdb/duckdb/pull/5835
• Fix list_sort segmentation fault regression by @taniabogatsch in https://github.com/duckdb/duckdb/pull/5823
• Add support for specifying timestamp precision using standard modifiers by @Mytherin in https://github.com/duckdb/duckdb/pull/5848
• Fix #5836: generate unique oid for attached databases as well by @Mytherin in https://github.com/duckdb/duckdb/pull/5851
• Fix #5782 and #5794: in strict mode do not accept leading zeros when parsing numbers by @Mytherin in https://github.com/duckdb/duckdb/pull/5850
• Fix #5781: add missing flatten call to list_aggregate by @Mytherin in https://github.com/duckdb/duckdb/pull/5854
• Fix #5788: improve error message when referencing an alias that contains a subquery (not supported yet) by @Mytherin in https://github.com/duckdb/duckdb/pull/5855
• Fix #5853: fully qualify function names inside macros during the binding process by @Mytherin in https://github.com/duckdb/duckdb/pull/5856
• CSV Auto Detection: disallow leading + when parsing numbers in strict mode by @Mytherin in https://github.com/duckdb/duckdb/pull/5857
• Additional quote handling for string to list cast by @LindsayWray in https://github.com/duckdb/duckdb/pull/5859
• Parser: add support for unicode space characters by @Mytherin in https://github.com/duckdb/duckdb/pull/5858
• Adding std:: to every move by @hannes in https://github.com/duckdb/duckdb/pull/5873
• MinGW Warning Fixes for R by @Mytherin in https://github.com/duckdb/duckdb/pull/5881
• Issue #5887: ICU DateAdd Overflow by @hawkfish in https://github.com/duckdb/duckdb/pull/5888
• NodeJS replacement scans by @whscullin in https://github.com/duckdb/duckdb/pull/5825
• Further parallelize index creation by @taniabogatsch in https://github.com/duckdb/duckdb/pull/5812
• Added the 'GetExpectedParameterTypes' method to the PreparedStatement… by @AlexR2D2 in https://github.com/duckdb/duckdb/pull/5792
• Extend GenericExecutor by @Maxxen in https://github.com/duckdb/duckdb/pull/5863
• Add signbit function for floating point values by @carlopi in https://github.com/duckdb/duckdb/pull/5862
• Nested/Outer lambda parameters in rhs of inner lambda expressions by @taniabogatsch in https://github.com/duckdb/duckdb/pull/5860
• Issue #5826: ICUDateFunc SubtractField Fix by @hawkfish in https://github.com/duckdb/duckdb/pull/5869
• Reset schema setting when the default schema is dropped by @Tishj in https://github.com/duckdb/duckdb/pull/5874
• Issue #5870: Nested ArgMinMax Results by @hawkfish in https://github.com/duckdb/duckdb/pull/5879
• Fix #5779: Parquet writer - when writing lists write only the required subsection of a child entry to the Parquet file by @Mytherin in https://github.com/duckdb/duckdb/pull/5875
• Change AddString to AddBlob in update_segment.cpp by @Maxxen in https://github.com/duckdb/duckdb/pull/5837
• Support UNION_BY_NAME option in parquet_scan read_parquet by @douenergy in https://github.com/duckdb/duckdb/pull/5716
• Minor fixes for cran by @hannes in https://github.com/duckdb/duckdb/pull/5904
• [Julia] Use best practices for locking strategies by @Tishj in https://github.com/duckdb/duckdb/pull/5905
• More GCC 13 issues by @hannes in https://github.com/duckdb/duckdb/pull/5907
• read_csv_auto column_types improvements by @Mytherin in https://github.com/duckdb/duckdb/pull/5911
• feat: add parser support for CREATE DATABASE to allow extensions to provide the functionality by @stephaniewang526 in https://github.com/duckdb/duckdb/pull/5898
• Fix #5903: ICU addition overflow by @papparapa in https://github.com/duckdb/duckdb/pull/5908
• Export set operations to relational API by @Tmonster in https://github.com/duckdb/duckdb/pull/5872
• Join Order + EXPLAIN Improvements by @lnkuiper in https://github.com/duckdb/duckdb/pull/5891
• fixed bug in generating grammar script by @ila in https://github.com/duckdb/duckdb/pull/5917
• Fix implicit conversion by @carlopi in https://github.com/duckdb/duckdb/pull/5892
• Issue 5660 - do not allow unnest with alias in groupby by @Tmonster in https://github.com/duckdb/duckdb/pull/5918
• Parquet: correctly output TIMESTAMP_TZ type when isAdjustedToUTC is set by @Mytherin in https://github.com/duckdb/duckdb/pull/5916
• Parquet reader: Fix an issue reading boolean values that cross column pages by @Mytherin in https://github.com/duckdb/duckdb/pull/5926
• Allow hive columns to be present in parquet files by @samansmink in https://github.com/duckdb/duckdb/pull/5901
• Fix #5936 - in the Pragma parser, avoid calling ToString() on column references because it might add quotes to keywords by @Mytherin in https://github.com/duckdb/duckdb/pull/5939
• Add option to limit parallel compile by @ashish01 in https://github.com/duckdb/duckdb/pull/5935
• Avoid writing .tmp file when redirecting stdout to a file by @Mytherin in https://github.com/duckdb/duckdb/pull/5930
• [Macro] Remove limitation for types of expressions accepted as named arguments by @Tishj in https://github.com/duckdb/duckdb/pull/5876
• Benchmarks by @carlopi in https://github.com/duckdb/duckdb/pull/5942
• Fix non-deterministic test failure of parquet_scan by @papparapa in https://github.com/duckdb/duckdb/pull/5954
• [Binder] Throw exception for aggregate function modifiers applied to non-aggregate functions by @lnkuiper in https://github.com/duckdb/duckdb/pull/5951
• Add logical plan serialization for LOAD, DROP and ALTER by @ywelsch in https://github.com/duckdb/duckdb/pull/5934
• Fix trainbenchmark non-determinism adding ordering by @carlopi in https://github.com/duckdb/duckdb/pull/5952
• Add missing include to duckdb.hpp by @Tishj in https://github.com/duckdb/duckdb/pull/5953
• httpfs: remove unneded include by @carlopi in https://github.com/duckdb/duckdb/pull/5945
• [jemalloc] Detect LG_PAGE by @lnkuiper in https://github.com/duckdb/duckdb/pull/5949
• String to map cast by @LindsayWray in https://github.com/duckdb/duckdb/pull/5838
• Add time bucket function by @papparapa in https://github.com/duckdb/duckdb/pull/5665
• [Python] Add UNION_BY_NAME to from_parquet arguments by @papparapa in https://github.com/duckdb/duckdb/pull/5913
• Ci partial rework by @carlopi in https://github.com/duckdb/duckdb/pull/5943
• Issue #3423: Positional Join Operator by @hawkfish in https://github.com/duckdb/duckdb/pull/5867
• docs: add nodejs connection args to docs by @tshauck in https://github.com/duckdb/duckdb/pull/5780
• [SQL Logic Test] Add support for environment variables by @Tishj in https://github.com/duckdb/duckdb/pull/5877
• Ci: scope / remove env variables by @carlopi in https://github.com/duckdb/duckdb/pull/5967
• Restore node-pre-gyp credentials by @carlopi in https://github.com/duckdb/duckdb/pull/5970
• Python: Allow replacement scans on pyrelations, move to BoxRenderer and use pending query API for relations by @Mytherin in https://github.com/duckdb/duckdb/pull/5962
• Issue #5023: Window Radix Partitions by @hawkfish in https://github.com/duckdb/duckdb/pull/5909
• Update copyright year by @sjaenick in https://github.com/duckdb/duckdb/pull/5974
• Fix #5968: ignore repetition type of root schema by @Mytherin in https://github.com/duckdb/duckdb/pull/5969
• Fix #5971: addition and subtraction on infinity of TIMESTAMPTZ by @papparapa in https://github.com/duckdb/duckdb/pull/5978
• Regression ci by @carlopi in https://github.com/duckdb/duckdb/pull/5961
• Add support for UPSERT (INSERT .. ON CONFLICT DO ..) syntax by @Tishj in https://github.com/duckdb/duckdb/pull/5866
• Removing Arrow ABI Testing by @pdet in https://github.com/duckdb/duckdb/pull/5980
• Remove LogicalTypeId::JSON and implement read_json_objects by @lnkuiper in https://github.com/duckdb/duckdb/pull/5544
• Make sqlsmith extension compile by @PedroTadim in https://github.com/duckdb/duckdb/pull/5963
• Issue #5023: Radix Partition Cardinality by @hawkfish in https://github.com/duckdb/duckdb/pull/5989
• Added UUID case to GetTypeToPython by @maclockard in https://github.com/duckdb/duckdb/pull/5885
• Export right left and full joins by @Tmonster in https://github.com/duckdb/duckdb/pull/5822
• Decimal separator option for CSV reader by @eeroel in https://github.com/duckdb/duckdb/pull/5958
• feat(python): fsspec filesystems by @Mause in https://github.com/duckdb/duckdb/pull/5829
• Fix amalgamation build: returning (std::)move will otherwise be flagg… by @carlopi in https://github.com/duckdb/duckdb/pull/5991
• Fix issue 5675 by @samansmink in https://github.com/duckdb/duckdb/pull/6001
• Only copy relevant list children in column data collection by @taniabogatsch in https://github.com/duckdb/duckdb/pull/5982
• Many Parallel CSV Reader Fixes by @pdet in https://github.com/duckdb/duckdb/pull/5950
• [python] Use duck typing for arrow dataset by @changhiskhan in https://github.com/duckdb/duckdb/pull/5998
• [Import/Export] Exported databases can now be safely moved by @Tishj in https://github.com/duckdb/duckdb/pull/5965
• Add count_if as a macro function by @ashish01 in https://github.com/duckdb/duckdb/pull/6007
• Rcpp17 by @carlopi in https://github.com/duckdb/duckdb/pull/6022
• [Dev] Fix #6020: Fix failure of CI with pyarrow by @papparapa in https://github.com/duckdb/duckdb/pull/6023
• Format script: enforce same varargs formatting by @Mytherin in https://github.com/duckdb/duckdb/pull/6014
• fixed fsst issue with size calculation check by @samansmink in https://github.com/duckdb/duckdb/pull/6016
• Fix Node.js Windows CI jobs by @carlopi in https://github.com/duckdb/duckdb/pull/6041
• fix 5923 - convert float16 column in pandas to float32 column by @wordhardqi in https://github.com/duckdb/duckdb/pull/6028
• Add support for JDBC Metadata for the nested typess List, Struct, Map by @jonathanswenson in https://github.com/duckdb/duckdb/pull/6029
• move block checksum from FileBuffer to BlockManager by @jkub in https://github.com/duckdb/duckdb/pull/6033
• Optimize SELECT UNNEST in lateral joins by @taniabogatsch in https://github.com/duckdb/duckdb/pull/6035
• Fix Python CI: numpy added before-build by @carlopi in https://github.com/duckdb/duckdb/pull/6056
• Track exact ART size and many ART improvements by @taniabogatsch in https://github.com/duckdb/duckdb/pull/5893
• Use back-up to download unixODBC by @carlopi in https://github.com/duckdb/duckdb/pull/6063
• Copy into partition by by @samansmink in https://github.com/duckdb/duckdb/pull/5964
• Add support for a pluggable storage and catalog back-end, and add support for a SQLite back-end storage by @Mytherin in https://github.com/duckdb/duckdb/pull/6066
• Various fixes by @carlopi in https://github.com/duckdb/duckdb/pull/6036
• out of tree extension improvements by @samansmink in https://github.com/duckdb/duckdb/pull/6049
• Fix checks on R-devel by @krlmlr in https://github.com/duckdb/duckdb/pull/6025
• Update editor config by @Tmonster in https://github.com/duckdb/duckdb/pull/6065
• Implement read_json and improve JSON parse errors by @lnkuiper in https://github.com/duckdb/duckdb/pull/5992
• [Python] Add read_csv method by @Tishj in https://github.com/duckdb/duckdb/pull/6015
• Add bar function by @papparapa in https://github.com/duckdb/duckdb/pull/5993
• Remove console.log from UDF catch by @chrisbrain in https://github.com/duckdb/duckdb/pull/6082
• Fix performance regression in read_csv_auto auto detection by @Mytherin in https://github.com/duckdb/duckdb/pull/6078
• Allowing lambdas in table functions by @taniabogatsch in https://github.com/duckdb/duckdb/pull/6039
• Add relational tests back by @Tmonster in https://github.com/duckdb/duckdb/pull/6038
• Force-enabling DEBUG_MOVE for debug builds by @hannes in https://github.com/duckdb/duckdb/pull/6099
• [Python] Make pyarrow.dataset optional by @Tishj in https://github.com/duckdb/duckdb/pull/6106
• Fuzzer issue #5984 no 25 by @LindsayWray in https://github.com/duckdb/duckdb/pull/6107
• [ParquetWriter] Prevent creating broken parquet files by @Tishj in https://github.com/duckdb/duckdb/pull/6104
• [Fuzzer] Fix issue related to dropping a generated column by @Tishj in https://github.com/duckdb/duckdb/pull/6113
• Implement md alias for motherduck and add motherduck to list of known extensions by @Mytherin in https://github.com/duckdb/duckdb/pull/6111
• Map extract bug by @LindsayWray in https://github.com/duckdb/duckdb/pull/6109
• [Dev] Fix some unqualified move's that snuck in by @Tishj in https://github.com/duckdb/duckdb/pull/6117
• Ccaching2 by @carlopi in https://github.com/duckdb/duckdb/pull/6101
• Making CSV Parallel tests more robust by @pdet in https://github.com/duckdb/duckdb/pull/6122
• [Julia] Fix execute deadlock by @Tishj in https://github.com/duckdb/duckdb/pull/6123
• [Python] Check overflow in DATE -> datetime conversion by @Tishj in https://github.com/duckdb/duckdb/pull/6125
• Python box rendering: limit rendering to 10K rows by @Mytherin in https://github.com/duckdb/duckdb/pull/6121
• Correctly setting the validity of constant struct vector references by @taniabogatsch in https://github.com/duckdb/duckdb/pull/6118
• Fix #6092 - retain casing for keywords by @Mytherin in https://github.com/duckdb/duckdb/pull/6112
• Fuzzer issue 9 and 40 from #5984 by @samansmink in https://github.com/duckdb/duckdb/pull/6126
• fix(python): fix gil error in fsspec integration by @Mause in https://github.com/duckdb/duckdb/pull/6140
• Fuzzer issue #5984 no.43. Substring generating an invalid string by @LindsayWray in https://github.com/duckdb/duckdb/pull/6139
• Remove sporadically failing Windows CI CSV reader test by @Mytherin in https://github.com/duckdb/duckdb/pull/6147
• issue 5984 #42 disable nan as random seed by @Tmonster in https://github.com/duckdb/duckdb/pull/6128
• [Python] Add read_parquet, to_parquet and to_csv by @Tishj in https://github.com/duckdb/duckdb/pull/6129
• Make ATTACH work over HTTP(S), and fix ATTACH for databases with custom types by @Mytherin in https://github.com/duckdb/duckdb/pull/6141
• Replace replacement_opens with storage_init by @Mytherin in https://github.com/duckdb/duckdb/pull/6132
• Fix to Fuzzer 5 item #30, plus various very marginal fixes by @carlopi in https://github.com/duckdb/duckdb/pull/6137
• Improve read_json transform errors and fix some read_json related bugs by @lnkuiper in https://github.com/duckdb/duckdb/pull/6145
• [Fuzzer] ArgMax Segfault by @Tishj in https://github.com/duckdb/duckdb/pull/6144
• Fix #6136: fix issue with SINGLE JOIN where NULL values of a struct were not correctly set by @Mytherin in https://github.com/duckdb/duckdb/pull/6148
• Fix fuzzer issue 35: correctly check overflows on casts from float/double to unsigned integers by @Mytherin in https://github.com/duckdb/duckdb/pull/6151
• [Fuzzer] Unset 'swizzled' flag in SortedData by @lnkuiper in https://github.com/duckdb/duckdb/pull/6143
• Introduces Bit type by @LindsayWray in https://github.com/duckdb/duckdb/pull/5990
• Fix issue related to NodeJS UDF not returning constant vectors by @Tishj in https://github.com/duckdb/duckdb/pull/5697
• 6055 column alias in where clause results in binder error by @Tmonster in https://github.com/duckdb/duckdb/pull/6162
• Skip concurrent index/grouping sets tests for now by @Mytherin in https://github.com/duckdb/duckdb/pull/6164
• Skip attach over HTTPFS test by @Mytherin in https://github.com/duckdb/duckdb/pull/6167
• 5982 (8, 12, 15) binder error when group by all & having clause both refer to column from correlated subquery by @Tmonster in https://github.com/duckdb/duckdb/pull/6163
• More minor fixes to warnings by @carlopi in https://github.com/duckdb/duckdb/pull/6138
• Fix fuzzer issue 14: correctly switch between deleting from transaction local storage and main table based on ids by @Mytherin in https://github.com/duckdb/duckdb/pull/6166
• fix(nodejs): error as object instead of string by @Mause in https://github.com/duckdb/duckdb/pull/6174
• Fixing Parallel CSV Reader over multiple files by @pdet in https://github.com/duckdb/duckdb/pull/6131
• Issue 6157 duckdbj database meta data supports like escape clause by @rpbouman in https://github.com/duckdb/duckdb/pull/6178
• Fuzzer issue: Grapheme function overflow by @LindsayWray in https://github.com/duckdb/duckdb/pull/6171
• Fix fuzzer issue 31 (again) by @lnkuiper in https://github.com/duckdb/duckdb/pull/6172
• Wiring storage_info into attach and create_transaction_manager calls by @rjatwal in https://github.com/duckdb/duckdb/pull/6161
• Try to auto-cast list_filter input and throw exception when failing by @taniabogatsch in https://github.com/duckdb/duckdb/pull/6119
• Pass unrecognized configuration options to storage by @Mytherin in https://github.com/duckdb/duckdb/pull/6177
• Art fuzzer issues by @taniabogatsch in https://github.com/duckdb/duckdb/pull/6168
• Fix Python deadlock - execute all PyRelations through the shared execute loop, and throw exception if Pandas Scan is called while GIL is held by @Mytherin in https://github.com/duckdb/duckdb/pull/6186
• No lambdas in CHECK constraint and generated columns by @taniabogatsch in https://github.com/duckdb/duckdb/pull/6190
• fixes #6159 by @rpbouman in https://github.com/duckdb/duckdb/pull/6183
• Fix lambda warning on building by @taniabogatsch in https://github.com/duckdb/duckdb/pull/6195
• Python: Make duckdb.sql return results for non-select queries in the form of a ValueRelation by @Mytherin in https://github.com/duckdb/duckdb/pull/6196
• Fix #6204: fix buffer management in ColumnDataRowCollection construction used in BoxRenderer by @Mytherin in https://github.com/duckdb/duckdb/pull/6205
• Python: make imports lazy, add .sql as an alias for .query, and add integration functions with polars by @Mytherin in https://github.com/duckdb/duckdb/pull/6181
• bugfix(python): fsspec file modes by @Mause in https://github.com/duckdb/duckdb/pull/6207
• Fix #6182: add DESCRIBE to the set of table name keywords by @Mytherin in https://github.com/duckdb/duckdb/pull/6206
• Fix #5983: avoid serializing type as part of numeric statistics (de)serialization by @Mytherin in https://github.com/duckdb/duckdb/pull/6197
• Fuzzer 16: Between type mismatch by @LindsayWray in https://github.com/duckdb/duckdb/pull/6194
• [Fuzzer] Fixes fuzzer issue 27 by @Tishj in https://github.com/duckdb/duckdb/pull/6193
• Fuzzer fixes 2, 3 and 5 of #5984 by @samansmink in https://github.com/duckdb/duckdb/pull/6187
• DuckDBJ: sanitize values of tableTypes argument in DatabaseMetadata.getTables() by @rpbouman in https://github.com/duckdb/duckdb/pull/6180
• Add more tests for fetch* functions, and add support for Pandas-style .describe() by @Mytherin in https://github.com/duckdb/duckdb/pull/6212
• More descriptive error message if we are using a table function as a scalar function by @Mytherin in https://github.com/duckdb/duckdb/pull/6201
• Make NumPy dependency optional by @Mytherin in https://github.com/duckdb/duckdb/pull/6215
• Implement FORMAT JSON for COPY/IMPORT/EXPORT by @lnkuiper in https://github.com/duckdb/duckdb/pull/6170
• Fix ODBC CI by @Mytherin in https://github.com/duckdb/duckdb/pull/6216
• [Python] Add read_json method by @Tishj in https://github.com/duckdb/duckdb/pull/6165
• [C-API] Add struct list_entry, ListVector::reserve and ListVector::set_size by @eddyxu in https://github.com/duckdb/duckdb/pull/6155
• Disable the Node build cache in the CI for now by @Mytherin in https://github.com/duckdb/duckdb/pull/6220
• [Java] BigDecimal scale > precision bug fix by @Tishj in https://github.com/duckdb/duckdb/pull/6110
• Fix #6044: in Value::DECIMAL, switch on the width instead of assuming the width is correctly set with the corresponding integer type by @Mytherin in https://github.com/duckdb/duckdb/pull/6219
• Fix #6184: skip unused column removal right after a filter with entries in the projection map by @Mytherin in https://github.com/duckdb/duckdb/pull/6221
• Bump postgres scanner by @hannes in https://github.com/duckdb/duckdb/pull/6226
• Add support for "show" to py relation objects by @Mytherin in https://github.com/duckdb/duckdb/pull/6224

Full Changelog: https://github.com/duckdb/duckdb/compare/v0.6.1...v0.7.0