DuckDB v0.6.1stable Released Dec 06, 2022
Impact Score: 5/10

DuckDB: 0.6.1 Bugfix Release

Source available โ€” automated, not human-reviewed

Component: duckdb ยท Channel: stable. Automated analysis, not a compatibility certification. How this works.

Analysis updated: 2026-11-01.

Compatibility not verified โ€” check source notes
๐Ÿ“„ .MD
โšก Executive Summary (TL;DR)

DuckDB v0.6.1. Source highlight: This is a bug fix release for various issues discovered after we released 0.6.0. There are no new features, just bug fixes.

Who Does This Impact? (Role-Based Analysis)

๐Ÿ’ป Software Engineers & Devs

Check the source notes against the package and APIs you use before upgrading.

๐Ÿ“Š Product & Engineering Leads

Use the documented changes to assess relevance to your product; release frequency alone is not a quality measure.

โš™๏ธ DevOps & Security

Verify the target version, runtime requirements and rollback procedure in the official documentation.

โœจ New Features & Capabilities (6)

  • Add reference to cleanup function for duckdb_result_get_chunk
  • Add support for reading JSON type columns from Parquet files
  • Add initializer for queue_insertions
  • Add deserialization to custom operators
  • Add in the pg_database, pg_proc, and pg_settings views to pg_catalog
  • Add feature request link

๐Ÿ”ง Bug Fixes & Patches (6)

  • [julia] fix docstring of `load!` and relax type restriction
  • Fix #5390: in filter pull-up optimizer avoid adding columns to one side of a set operation
  • Fix #5371: correctly use instance cache in JDBC and ODBC connector
  • [Dev] Fix compilation issues related to MSVC and Windows.h
  • fix: upgrade npm's internal node-gyp
  • Fix bug causing loss of order preservation in insert
๐Ÿ“„ View Raw Release Notes (Original Developer Log)
This is a bug fix release for various issues discovered after we released 0.6.0. There are no new features, just bug fixes. ## What's Changed * Correctly accept BUILD_JEMALLOC_EXTENSION on Linux by @Mytherin in https://github.com/duckdb/duckdb/pull/5343 * [julia] fix docstring of `load!` and relax type restriction by @jfb-h in https://github.com/duckdb/duckdb/pull/5354 * Bump DuckDB_jll compat to v0.6 by @jeremiahpslewis in https://github.com/duckdb/duckdb/pull/5356 * Issue #5342: DATE_PART Struct Indexing by @hawkfish in https://github.com/duckdb/duckdb/pull/5382 * Add reference to cleanup function for duckdb_result_get_chunk by @ak-coram in https://github.com/duckdb/duckdb/pull/5389 * Fix #5390: in filter pull-up optimizer avoid adding columns to one side of a set operation by @Mytherin in https://github.com/duckdb/duckdb/pull/5400 * Fix #5371: correctly use instance cache in JDBC and ODBC connector by @Mytherin in https://github.com/duckdb/duckdb/pull/5398 * Add support for reading JSON type columns from Parquet files by @Mytherin in https://github.com/duckdb/duckdb/pull/5401 * [Dev] Fix compilation issues related to MSVC and Windows.h by @Tishj in https://github.com/duckdb/duckdb/pull/5386 * fix: upgrade npm's internal node-gyp by @Mause in https://github.com/duckdb/duckdb/pull/5402 * [Appender] Appender can now properly append to DECIMAL columns by @Tishj in https://github.com/duckdb/duckdb/pull/5364 * Fix bug causing loss of order preservation in insert by @lnkuiper in https://github.com/duckdb/duckdb/pull/5427 * Allocator: throw std::bad_alloc if a malloc allocation fails by @Mytherin in https://github.com/duckdb/duckdb/pull/5439 * Fix the use of COLUMNS(...) in ORDER BY clause by @lokax in https://github.com/duckdb/duckdb/pull/5444 * Adding lazy relation -> data.frame conversion for R client by @hannes in https://github.com/duckdb/duckdb/pull/5181 * Fix #5450, don't crash on integer dates in R by @hannes in https://github.com/duckdb/duckdb/pull/5451 * Issue #5366: QUANTILE_DISC Intervals by @hawkfish in https://github.com/duckdb/duckdb/pull/5442 * Remove the f off by @hatvik in https://github.com/duckdb/duckdb/pull/5475 * Fix many fuzzer issues by @Mytherin in https://github.com/duckdb/duckdb/pull/5482 * Allow column references in constant table functions by @Mytherin in https://github.com/duckdb/duckdb/pull/5483 * Node register arrow ipc buffer fix by @samansmink in https://github.com/duckdb/duckdb/pull/5433 * Add initializer for queue_insertions by @hannes in https://github.com/duckdb/duckdb/pull/5504 * Disabling per-value materialization of r altrep strings in results by @hannes in https://github.com/duckdb/duckdb/pull/5454 * Correctly set delim_offset in flatten dependent join and disable linux arrow test by @Mytherin in https://github.com/duckdb/duckdb/pull/5509 * update arrow extension by @samansmink in https://github.com/duckdb/duckdb/pull/5506 * [Python] Correct stub for DuckDBPyConnection::df by @Tishj in https://github.com/duckdb/duckdb/pull/5385 * Add deserialization to custom operators by @rjatwal in https://github.com/duckdb/duckdb/pull/5496 * [Python] No longer truncate ByteArray values by nullbytes by @Tishj in https://github.com/duckdb/duckdb/pull/5517 * Add in the pg_database, pg_proc, and pg_settings views to pg_catalog by @jwills in https://github.com/duckdb/duckdb/pull/5526 * Fix various BufferManager issues by @lnkuiper in https://github.com/duckdb/duckdb/pull/5476 * Add feature request link by @Mause in https://github.com/duckdb/duckdb/pull/5324 * [Python] Fix `relation.query()` not accepting non-select statements by @Tishj in https://github.com/duckdb/duckdb/pull/5531 * fix issue #5488 by @samansmink in https://github.com/duckdb/duckdb/pull/5519 * [Python] Adding back Query interrupt support (through Ctrl+C) by @Tishj in https://github.com/duckdb/duckdb/pull/5487 * Adding dummy user/username/password settings by @hannes in https://github.com/duckdb/duckdb/pull/5530 * Add memory leak tests, and fix memory leaks related to repeated table creation/destruction by @Mytherin in https://github.com/duckdb/duckdb/pull/5537 * DuckBox renderer fixes by @Mytherin in https://github.com/duckdb/duckdb/pull/5539 * Fix #5533: correctly use timestamp logical type unit in Parquet stats reader by @Mytherin in https://github.com/duckdb/duckdb/pull/5540 * Disable the extended code coverage tests for now by @Mytherin in https://github.com/duckdb/duckdb/pull/5542 * NLJoin is not always terrible by @pdet in https://github.com/duckdb/duckdb/pull/5538 * naming mismatch for linux arm extension upload by @samansmink in https://github.com/duckdb/duckdb/pull/5556 * Deprecate 'sprintf' usage using MacOSX SDK 13 by @darrenfu in https://github.com/duckdb/duckdb/pull/5545 * Fix #5546: allow foldable scalar expressions in standard table functions by @Mytherin in https://github.com/duckdb/duckdb/pull/5550 * Upgrade sqlite scanner hash by @Mytherin in https://github.com/duckdb/duckdb/pull/5551 * [Python] Fixed bug where creating a cursor from a closed connection caused a segfault by @Tishj in https://github.com/duckdb/duckdb/pull/5565 * Fsst pull bugfix from upstream by @samansmink in https://github.com/duckdb/duckdb/pull/5567 * Parquet: Not setting num_children for primitive types as per spec by @hannes in https://github.com/duckdb/duckdb/pull/5579 * [Python] Fix accidental dependency on `pandas` by @Tishj in https://github.com/duckdb/duckdb/pull/5581 * Throw error when sorting or using indexes on big endian architecture by @Mytherin in https://github.com/duckdb/duckdb/pull/5588 * fix: separate artifacts for 32bit and 64bit builds by @Mause in https://github.com/duckdb/duckdb/pull/5592 * Bug fix for 5523 by @taniabogatsch in https://github.com/duckdb/duckdb/pull/5554 * Disabling truncating of temporary buffer manager files on Windows by @hannes in https://github.com/duckdb/duckdb/pull/5600 * Removed FSST unused global that triggered compiler warning by @hannes in https://github.com/duckdb/duckdb/pull/5602 * Copy JDBC Properties to not lose readonly setting by @hannes in https://github.com/duckdb/duckdb/pull/5594 **Full Changelog**: https://github.com/duckdb/duckdb/compare/v0.6.0...v0.6.1