SingleStore Managed Service

Maintenance Release Changelog

2021-08-30 Version 7.5.9
  • New Feature: Added support for alias references in WHERE clauses and as column expressions. See SELECT for more information.

  • Fixed an issue where Disaster Recovery of a non-unlimited storage database was not blocked if a cluster was configured to use remote storage.

  • The AGGREGATOR SYNC AUTO_INCREMENT command now can be performed by anyone with the ability to update the target database(s) or table in any way.

    This makes the command available to Managed Service customers.

  • Fixed an issue that could cause defunct processes for pipelines or code generation in a rare race condition.

  • Fixed issues with the S2 Managed Service monitoring infrastructure by improving the performance of querying against the information_schema.mv_activities_cumulative view.

  • Increased batch deletions from unlimited storage to improve the performance of GCing files from remote storage.

  • Improved JSON built-in functions to better handle out of memory errors.

  • Improved the cardinality estimates for columns with an equality predicate.

2021-08-16 Version 7.5.8
  • Fixed per-predicate PROFILE statistics on columnstore filter operations.

  • Fixed a crash that could occur when running CREATE PIPELINE or REPLACE PIPELINE on a pipeline that already exists.

  • Removed truncation of the query text in query.log when general_log=on.

  • Fixed a crash that could occur when ALTER TABLE COMPRESSION=SPARSE is run in the same ALTER statement with an operation that doesn’t require data movement (ie., AUTOSTATS_ENABLED = ON).

2021-08-09 Version 7.5.7
  • New Feature: Added anonymous code blocks which are unnamed blocks of SingleStore (MemSQL) Procedural SQL (MPSQL) code that are executed immediately. They allow you to create a code block without defining and calling a stored procedure and are useful in situations such as testing or debugging.

  • Added a new system variable called parametrizer_query_max_params which allows users to set the maximum number of scalar constants a single query can contain. Any query with more than parametrizer_query_max_params will be failed with an error. The default value is 1048576.

  • Fixed an issue where the exporter process was not being cleaned up when memsqld is shut down.

  • Fixed an issue where modifying the case of a column via ALTER TABLE could cause a pipeline using that table to crash.

  • Improved usability of various JSON-builtins to support utf8mb4 charset arguments.

  • Increased frequency of merging during load for unique keys on columnstores.

  • Added information_schema.mv_bt which shows backtrace information for all nodes in the cluster.

  • Added information_schema.mv_plancache which shows plancache information for all nodes in the cluster (cluster-wide version of information_schema.plancache).

  • Added support for the transaction_read_only and tx_read_only session variables for MySQL compatible client drivers that query them.

  • Fixed a performance regression establishing SSL connections introduced in 7.5.

  • Fixed a deadlock which can occur if a failover happens during an ALTER TABLE.

  • Changed the SET PASSWORD statement to query forward from the child aggregator to the master aggregator.

2021-07-20 Version 7.5.6
  • Initial GA release of version 7.5.5

2021-07-07 Version 7.5.5
  • Stability improvements to version 7.5.4

2021-06-28 Version 7.5.4
  • Fixed an "invalid LSN" error when restoring a local storage database into a remote storage database.

2021-06-24 Version 7.5.3
  • Fixed an issue that could cause DETACH DATABASE to hang while a pipeline that is attempting to load batches is failing.

  • Fixed an issue that could generate incorrect out of memory errors when using a remote storage database.

2021-06-22 Version 7.5.2
  • Beta release of SingleStore DB 7.5