DuckDB 0.9.2 release notes

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