Sign inTry Free

Maintenance Release Changelog

On this page

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) 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 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.

Last modified: July 30, 2025

Was this article helpful?

On this page

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

  1. (Optional) Run the following command to view the associated signature files.

    curl undefined

  2. Download the signature file from the SingleStore release server.

    • Option 1: Click the Download Signature button next to the SingleStore file.

    • Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.

    • Option 3: Run the following command to download the signature file.

      curl -O undefined

  3. After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

    echo -n undefined |
        cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
          --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
          --bundle undefined \
          --new-bundle-format -
    Verified OK