Important

The SingleStore 9.0 release candidate (RC) gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.

Maintenance Release Changelog v9.0

2025-08-20 Version 9.0.7

  • Enhancement: Changed the approach for delimited batch sets. Delimited batch sets now return and accept original rowIDs.

  • Enhancement: Improved performance of full-text index.

  • Enhancement: Added support for metadata garbage collection for Azure pipelines.

  • Enhancement: Improved error handling for regular expressions: errors are now properly raised instead of returning SQL NULL. To avoid breaking existing apps the regexp_error_handling_level engine variable was added. This variable controls the behaviour of error handling for regexp operations.

  • Enhancement: Added a new engine variable, ssl_ca_for_client_cert, for client certification.

  • Enhancement: Added knob to disable cardinality estimates on JSON/BSON columns during analyze.

  • Enhancement: Added the MV_ACTIVE_METADATA_VERSIONS information schema view that provides visbiility into active metadata transaction read versions.

  • Enhancement: Added the MV_GC_EVENTS information schema view that provides visibility into garbage collection passes. This view is gated behind the preview feature and engine variable enable_gc_events.

  • Bugfix: Fixed query performance issue caused by heuristic estimate selectivity being overwritten.

  • Bugfix: Fixed an issue where monitoring pipelines would sometimes fail to produce data for large source clusters.

  • Bugfix: Fixed row count estimation for union subquery containing Materialized Common Table Expression(MCTE)s.

  • Bugfix: Updated third party libraries to fix security vulnerabilities.

  • Bugfix: Bumped the _bt timeout from 60 seconds to 180 seconds.

  • Bugfix: Fixed incorrect aggregation of leaf query stats in Query_completion tracing.

  • Bugfix: Fixed an issue where certain commands (e.g. DROP TABLE) could hang due to aborted queries caused by stuck collocated services triggered by external functions.

  • Bugfix: Resolved an issue where the regular expression engine would return SQL NULL when hitting the memory limit during execution. It now raises an appropriate error instead.

  • Bugfix: Implemented shallow copy of a table with a dropped index, the shallow copy now includes the in-memory segment.

2025-06-24 Version 9.0.6

  • Enhancement: Enabled synchronous Distributed Plancache lookup during query execution.

  • Enhancement: Added Lucene logs to the cluster report.

  • Enhancement: Added statistics related to AWS S3 lookup latency.

  • Bugfix: Prevented the drop of Distributed Plancache files on regular Persistent Plancache GC.

  • Bugfix: Fixed a bug in lateral join.

2025-06-18 Version 9.0.5

  • Enhancement: Distributed Plancache pool size adjustment fails gracefully.

  • Enhancement: Changed the default collation from utf8mb4_general_ci to utf8mb4_bin.

  • Bugfix: Fixed an issue where periodic autostats was disabled when it should not have been.

  • Bugfix: Fixed a crash in lockfree hashtable when the engine is under high memory pressure. Reports an "out of memory" error instead.

  • Bugfix: Fixed an issue in CTE query rewrites caused when a CTE referenced a recursive CTE.

  • Bugfix: Fixed the predicate pushdown logic for materialized common table expressions.

2025-06-13 Version 9.0.4

2025-06-12 Version 9.0.3

  • Enhancement: Added support for file filtering based on the WHERE clause in the pipeline declaration. For more details, refer to Iceberg Ingest.

  • Bugfix: Fixed an error named ER_BAD_TABLE_ERROR on UPDATE or DELETE queries with a specific shape.

Last modified: August 27, 2025

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