# DuckDB v0.6.0 — Release & Upgrade Intelligence
- **Product:** DuckDB (https://duckdb.org)
- **Version:** v0.6.0
- **Released:** Nov 14, 2022
- **Impact Score:** 7/10
- **Breaking Changes:** Source flagged
- **Canonical Analysis:** https://changelogs.us/duckdb/updates/v0.6.0/

## Executive Summary (TL;DR)
DuckDB v0.6.0. Source highlight: This preview release of DuckDB is named "Oxyura" after the White-headed duck (Oxyura leucocephala) which is an endangered species native to Eurasia.

## Breaking Changes & Deprecations
- Fix breaking CI on unused variable errors by @Tishj in https://github.com/duckdb/duckdb/pull/4916

## New Features
- Add auto-complete support to the shell
- Add json_contains
- feat: support passing all db config to jdbc driver
- Julia: add support for handling errors in replacement scans
- Extension build: turn IGNORE_WARNINGS into generic OPTIONS field, and add --main-only field
- Join order regression test: add 20% threshold to cardinalities before we care about regressions

## Improvements
- Improve memory management of ART indexes
- Improvements to Out-of-Core Hash Join
- Improve rendering of result sets for the shell
- Enhance duckdb_constraints()
- Improve sorting for strings and push projections into sort operator
- Various CI Improvements/Speed Ups

## Bug Fixes
- Fix #4747: Handle pandas num categories between 128 and 256
- Fix #3595: avoid using system hash for floating point values
- Fix #4704. Correct the column name for pragma_storage_info with generated column
- Fix some typo in code comments
- Fix #4152: create base table reference in returning clause so generated columns are correctly resolved
- Fix Exists and ANY correlated subquerys