> ## Documentation Index
> Fetch the complete documentation index at: https://docs.paradedb.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 0.22.6

## New Features 🎉

* Support expressions in JoinScan DISTINCT target lists (e.g., `upper(name)`, `name IS NULL`).

## Stability Improvements 💪

* Fix JoinScan `DISTINCT` planning for deferred keys.
* Fix JoinScan pushdown with outer-only `ORDER BY` pathkeys.
* Fix `pdb.score()` with `SELECT` subquery in `WHERE` clause.
* Handle `IN (SELECT ...) OR IS NULL` via LeftMark JoinScan.
* Fix score filter for joins and cases without other quals.
* Handle pruned columns in nested semi/anti join keys.
* Handle aliased indexed expressions in search resolution and top-k order by.
* Lower x86\_64 target-cpu from x86-64-v3 to x86-64-v2 for broader hardware compatibility.
* Prevent DSM buffer overflow in PG18 parallel index scans.
* Fix `PlaceHolderVar found where not expected` error.
* Restore `pdb.agg(jsonb)` if accidentally removed by an upgrade script.

The full changelog is available [on the GitHub Release](https://github.com/paradedb/paradedb/releases/tag/v0.22.6).