# DuckDB v0.10.2 — Release & Upgrade Intelligence
- **Product:** DuckDB (https://duckdb.org)
- **Version:** v0.10.2
- **Released:** Apr 17, 2024
- **Impact Score:** 5/10
- **Breaking Changes:** Not verified
- **Canonical Analysis:** https://changelogs.us/duckdb/updates/v0.10.2/

## Executive Summary (TL;DR)
DuckDB v0.10.2. Source highlight: 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.

## New Features
- Add support for HEX(BLOB)
- add TRIM support to virtual filesystem, and implementation on linux
- Add support for materialized CTEs in INSERT/UPDATE/DELETE statements
- Rework `FileSystem::OpenFile` call, and add `FILE_FLAGS_NULL_IF_NOT_EXISTS`
- File System: Add `optional_ptr<FileOpener>` to various calls, and add support for attaching DuckDB files over S3
- Add logical_type to parameters of format_pg_type

## Improvements
- Perform direct write operation if input data are larger than buffer size
- Improve binding of CTEs
- Avoid performing Apple codesign on extensions
- Improve hive type auto-casting so that it looks at all files instead of only the first file

## Bug Fixes
- Bump julia version & fix release script for sub-versions > 9
- Fix differences to implementation for to_parquet, write_parquet, to_csv, write_csv, Expression.alias, DuckDBPyRelation.map
- Fix #11211 - correctly fill in string_t padding for bit type
- Fix #3391: Stop creating background threads if the thread constructor throws an exception
- [Python] Fix error caused by looking up a TypeCatalogEntry without an active transaction.
- [Fix] Fuzzer issue in list_select