v3.36.1

payloadcms/payloadv3.36.1Apr 30, 2025by denolfe

AI Summary

A hotfix release addressing critical database crashes, specifically a Postgres count query issue with subqueries, and fixes for virtual relationship fields with the 'select' property.

Key Highlights

Fix 'count' query crash when subqueries are used
Fix virtual relationship fields with 'select'
Update email regex to support special characters

Full Release Notes

## [v3.36.1](https://github.com/payloadcms/payload/compare/v3.36.0...v3.36.1) (2025-04-30)


### 🐛 Bug Fixes

* duplicate with orderable ([#12274](https://github.com/payloadcms/payload/issues/12274)) ([710fe09](https://github.com/payloadcms/payload/commit/710fe09))
* virtual relationship fields with `select` ([#12266](https://github.com/payloadcms/payload/issues/12266)) ([564fdb0](https://github.com/payloadcms/payload/commit/564fdb0))
* update email regex to support special characters ([#12181](https://github.com/payloadcms/payload/issues/12181)) ([8fee016](https://github.com/payloadcms/payload/commit/8fee016))
* **db-postgres:** `count` crashes when query contains subqueries and doesn't return any rows ([#12273](https://github.com/payloadcms/payload/issues/12273)) ([4a56597](https://github.com/payloadcms/payload/commit/4a56597))
* **plugin-import-export:** csv export column order ([#12258](https://github.com/payloadcms/payload/issues/12258)) ([47a1eee](https://github.com/payloadcms/payload/commit/47a1eee))
* **richtext-lexical:** ensure state is up-to-date on inline-block restore ([#12128](https://github.com/payloadcms/payload/issues/12128)) ([1b17df9](https://github.com/payloadcms/payload/commit/1b17df9))

### ⚡ Performance

* optimize file access promises ([#12275](https://github.com/payloadcms/payload/issues/12275)) ([6133a1d](https://github.com/payloadcms/payload/commit/6133a1d))
* **db-postgres:** skip pagination overhead if `limit: 0` is passed ([#12261](https://github.com/payloadcms/payload/issues/12261)) ([27d644f](https://github.com/payloadcms/payload/commit/27d644f))

### 🤝 Contributors

- Dan Ribbens (@DanRibbens)
- Sasha (@r1tsuu)
- Mattias Grenhall (@grenhall)
- Tobias Odendahl (@tak-amboss)