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