Sign inTry Free

Maintenance Release Changelog

On this page

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: November 10, 2023

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