# Maintenance Release Changelog

## 2025-04-07 Version 1.0.109

* Added support for `MULTI VALUE` and Flat indexes on the same path.
* Enabled server-side TCP keepalive.
* Removed EPD sandwich optimization.
* Fixed a bug in the `MULTI VALUE` index on `ObjectID` types.

## 2025-02-01 Version 1.0.105

* Added support for ignoring the `max` option in the `createCollection` command.
* Optimized query generation for `distinct` queries.
* Optimized `distinct` queries using flattened tables, including queries with filters.
* Fixed a bug in `$merge`.
* Fixed schema refresh for `$lookup` tables.
* Fixed `TEXT` to `BSON` conversion.
* Fixed a bug in `$first` optimization on indexed fields.

## 2025-01-23 Version 1.0.98

* Added support for ignoring the `capped` and `size` options in the `createCollection` command.
* Added the `{recommend:1}` syntax to recommend indexes based on query shape.
* Fixed a bug in the `$$NOW` aggregation variable when used in the `$ifNull` operator.

## 2025-01-14 Version 1.0.97

* Added support for profiling failed commands.
* Fixed a bug in `$trunc`.
* Fixed a bug where views with a large number of rows failed schema inference.

## 2025-01-08 Version 1.0.96

* Added support for multikey indexes (multi-value indexes). Refer to [Multi-Value Hash Index (BSON)](https://docs.singlestore.com/cloud/reference/sql-reference/bson-functions/multi-value-hash-index-bson.md) for more information.
* Fixed a bug in retryable writes for long-running queries.
* Fixed an error in `$match` operation followed by the `$last` operation in the `$group` aggregation.
* Included other reliability and performance improvements.

## 2023-09-02 Version 1.0.14

* Added support for the following functions/operators:
  | `$box`       | `$geoIntersects` | `$geometry`    |
  | ------------ | ---------------- | -------------- |
  | `$geoWithin` | `$maxDistance`   | `$minDistance` |
  | `$near`      | `$nearSphere`    | `$polygon`     |
  **Note**: SingleStore Helios only supports Polygons and Point types for geospatial operators.
* Improved support and compatibility for BSON type.
* Included other reliability and performance improvements.

## 2023-08-04 Version 1.0.9

* Added support for the following functions/operators:
  | `$avg`            | `$first`      | `$last`      |
  | ----------------- | ------------- | ------------ |
  | `$min`            | `$max`        | `$sum`       |
  | `$stdDevPop`      | `$stdDevSamp` | `$denseRank` |
  | `$documentNumber` | `$rank`       |              |
* Added support for the `$setWindowFields` stage operator. However, SingleStore Kai does not support [range](https://www.mongodb.com/docs/manual/reference/operator/aggregation/setWindowFields/#std-label-setWindowFields-range) window with this operator.
* Included other reliability and performance improvements.

## 2023-07-13 Version 1.0.8

* Added support for the following operators:
  | `$setField` | `$unsetField` | `$getField` |
  | ----------- | ------------- | ----------- |
* Added support for the `$merge` (operator) extension command.
* Included other reliability and performance improvements.

## 2023-06-23 Version 1.0.6

* Added support for the following functions/operators:
  | `$sin`              | `$cos`              | `$tan`           |
  | ------------------- | ------------------- | ---------------- |
  | `$asin`             | `$acos`             | `$atan`          |
  | `$degreesToRadians` | `$radiansToDegrees` | `$setDifference` |
  | `$setIsSubset`      | `$topN`             | `$bottomN`       |
  | `$firstN`           | `$lastN`            | `$replaceOne`    |
  | `$replaceAll`       | `$documents`        |                  |
* Optimized queries with no projections or some other type of projections.
* Optimized performance of queries that use `$elemMatch`.
* Included other reliability and performance improvements.

## 2023-06-13 Version 1.0.5

* Added support for the following functions/operators:
  | `$out` | `$top` | `$bottom`   |
  | ------ | ------ | ----------- |
  | `$exp` | `$pow` | `$setUnion` |
* Added support for a third parameter for specifying the vector size to the `$dotProduct` and `$euclideanDistance` functions. The following sizes are supported: "F32" (default), "F64", "I8", "I16", "I32", "I64".
* Optimized MongoDB® database schema inference by the proxy service.
* Included other reliability and performance improvements.

## 2023-05-24 Version 1.0.4

* Added support for the following functions/operators:
  | `$bsonSize` | `$sampleRate` |   |
  | ----------- | ------------- | - |
* Optimized the `$elemMatch` operator.
* Optimized date-related queries and some array-related queries.
* Fixed resource consumption issues with connections that are frequently opened or closed.
* Included other reliability and performance improvements.

***

Modified at: July 30, 2025

Source: [/cloud/reference/singlestore-kai/maintenance-release-changelog/](https://docs.singlestore.com/cloud/reference/singlestore-kai/maintenance-release-changelog/)

(An index of the documentation is available at /llms.txt)