# Release - Federate 8.7.0 - 31.0

**URL:** <https://community.siren.io/t/release-federate-8-7-0-31-0/625>\
**Category:** Announcements\
**Created:** [April 19, 2023, 3:54pm UTC](https://community.siren.io/t/release-federate-8-7-0-31-0/625 "2023-04-19T15:54:48Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Issac\_Garcia](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/issac_garcia/32/263_2.png) [@Issac\_Garcia](https://community.siren.io/u/Issac_Garcia)\
**Post date:** [April 19, 2023, 3:54pm UTC](https://community.siren.io/t/release-federate-8-7-0-31-0/625/1 "2023-04-19T15:54:48Z")

</div>

We’re happy to announce today the release of Siren Federate version 31 for Elasticsearch version 8.7.0. This release includes the following enhancements and fixes:

Features

- Added multi-conditional join capabilities.
- Added new binary operators to be used in a join (`gt`, `lt`, `gte` and `lte`).

Improvements

- Upgraded to Elasticsearch 8.7.0
- Adapted `ROUTING_JOIN` to work on Adaptive Query Planner (AQP).
- Adapted runtime fields to work on AQP.
- Adapted Point in Time (PIT) to work on AQP.
- Enhanced performance by removing several blocking Java calls.
- Improved documentation on `Query DSL` and PIT limitations.

Bugs fixes

- Resolved a race condition involving job cleanup requests and data packet release.
- Fixed an integer overflow issue with batch size computation.
- Fixed ArrowBuf initialization to be in a privileged block.

Breaking changes

- Plugin initialization will fail if memory is incorrectly configured.
  - Java Max Direct Memory (`XX:MaxDirectMemorySize`) must be greater than Siren memory root limit (`siren.memory.root.limit`).

Known issues

- When performing a multi-conditional join on a single node cluster, it is necessary to explicitly specify the INDEX\_JOIN strategy.

Download it [here](https://siren.io/downloads/?product=siren-federate).