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