Sign inTry Free

Warning

SingleStore 9.0 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

On this page

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.

  • Enhancement: Renamed bottomless_plancache_* engine variables to distributed_plancache_*.

  • 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: June 24, 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