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
On this page
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_
engine variable was added.error_ handling_ level This variable controls the behaviour of error handling for regexp operations. -
Enhancement: Added a new engine variable,
ssl_
, for client certification.ca_ for_ client_ cert -
Enhancement: Added knob to disable cardinality estimates on JSON/BSON columns during analyze.
-
Enhancement: Added the
MV_
information schema view that provides visbiility into active metadata transaction read versions.ACTIVE_ METADATA_ VERSIONS -
Enhancement: Added the
MV_
information schema view that provides visibility into garbage collection passes.GC_ EVENTS 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_
togeneral_ ci 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
-
Enhancement: Added the
SEQUENCE
modifier forAUTO_
.INCREMENT Refer to AUTO_ INCREMENT AS SEQUENCE for more information.
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_
onBAD_ TABLE_ ERROR UPDATE
orDELETE
queries with a specific shape.
Last modified: August 27, 2025