DuckDB: v0.10.2 Bugfix Release

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