SingleStore DB

Maintenance Release Changelog
2021-11-22 Version 7.6.5
  • Removed the disk space check that occurred when ALTER TABLE ADD INDEX is run. The check occurred prior to altering a columnstore table in an unlimited storage database.

  • Fixed an issue with reoccurring timeout failures when running DETACH DATABASE.

  • Fixed an issue with a crash occurring when an incremental backup was performed on an empty database.

  • Clarified error messaging when invalid data is inserted into a utf8 charset datatype column.

  • Fixed an issue with an aggregator results table checking INSERT privileges.

  • Fixed an issue where results data is incorrectly blank in particular columns when querying information_schema.mv_plancache.

  • Enhancement: Improved the performance of columnstore UPDATE queries that do not modify unique key columns.

  • Fixed an issue with a crash occurring when DDL is run inside a stored procedure that is executed within a resource pool on a child aggregator.

  • Block the DROP TEMPORARY TABLE command from running in a transaction that writes to the temporary table being dropped. The DROP TEMPORARY TABLE command result will display an error.

2021-11-10 Version 7.6.4
  • Initial GA release of version 7.6.

  • New Feature: Point-in-time recovery (PITR) has moved from preview to production status, and is now supported for production use cases.

2021-10-29 Version 7.6.3
  • New Feature: Added support for unlimited storage in Azure.

  • Enhancement: Added password_expiration column to information_schema.USERS table. If the password_expiration_seconds engine variable is not enabled, the password_expiration column will be NULL. If the password_expiration_seconds engine variable is enabled, the password_expiration column will display the number of seconds remaining for the password to expire.

  • Enhancement: Improved the performance of selective filters using string columns in columnstore tables.

2021-10-21 Version 7.6.2
  • New Feature: Added support on Azure for unlimited storage databases and PITR.

  • New Feature: Added support for Google Cloud Storage (GCS) for unlimited storage databases and PITR, as a preview feature.

  • Enhancement: By default, all backups are now lock-free. Distributed write transactions no longer have to wait when a backup starts.

  • Enhancement: Allow spilling to disk of hash join output rows.

  • Fixed an issue with possible connection crashes on disaster recovery clusters when DDL queries are forwarded to the master aggregator and a database has not been selected.

  • Fixed a crash caused by a check on the maximum number of partitions allowed on a leaf node. An error message is displayed when this threshold is exceeded.

2021-10-13 Version 7.6.1
  • Enhancement: Improved fulltext filter performance when used with other secondary hash index filters. For highly selective fulltext filters, the improvement in execution speed can be 10 times faster.

  • Fixed a regression in recovery performance for databases using remote storage.

  • New feature: Introduced row-level decompression for the string data type which will increase performance on reads against columnstore tables.  Before this improvement, decompression occurred on the order of blocks of data which consists of 4096 rows.

  • Fixed an issue with unexpected database writes on databases not written to. This behavior is disabled if the database does not have unlimited storage.

  • New Feature: Added support for cross-database INSERT...SELECT into columnstore temporary tables.

  • New Feature: Added support for new vector functions, namely JSON_ARRAY_UNPACK, SCALAR_VECTOR_MUL, VECTOR_ADD, and VECTOR_MUL.

    Each of these vector operations can be suffixed with _I8, _I16, _I32, _I64, _F32, _F64. If you leave the suffix off, it is equivalent to suffixing with _F32. EUCLIDEAN_DISTANCE(a, b) is equivalent in semantics to (DOT_PRODUCT(VECTOR_SUB(a, b), VECTOR_SUB(a, b)). All operations are performed within the data type specified. For example, DOT_PRODUCT_I8(a, a) will be the sum of the squares of a with the sum and the squares being 8-bit integers. This update also removes the requirement of the machine to have AVX2 to use vector functions.

  • New Feature: Added support for transactions in Kafka pipelines.

  • Enhancement: Introduced new logic to determine when to evict a compiled image of a query plan. The logic will sort on the oldest number of plans while considering the explicitly set memory limit usage of each plan. The feature is disabled by default. To enable the logic, the engine variable enable_compiled_images_eviction must be set to ON. The engine variable compiled_images_eviction_memory_limit_mb  is used to set the memory limit.

2021-10-05 Version 7.6.0
  • New Feature: Added a new function, JSON_KEYS, which returns the top-level keys of a JSON object in the form of a JSON array. Optionally, if a keypath is defined, returns the top-level keys from the keypath.JSON_KEYS

  • Enhancement: Added support for more query shapes with FULL JOIN or correlated subselects when reference tables are involved.  Prior to this release, these query shapes would hit a lockdown error.

  • Enhancement: Improved selectivity estimate for RIGHT JOIN query shapes when doing BloomFilter decision. See Query Plan Operations for a detailed explanation of BloomFilter and other filtering methods.

  • New Feature: Added support for the current user security model in stored procedures. In this model, when the current user executes a stored procedure, the stored procedure is executed using the security permissions of that user.

  • New Feature: Added support for query shapes that include repartitioned subqueries containing SELECT statements with aggregated column(s) without a GROUP BY clause. Prior to this release, these query shapes would hit a lockdown error.

  • New Feature: Added support for LEFT JOIN when the left table is a reference table without a primary key.  Prior to this release, this query shape would hit a lockdown error.

  • Enhancement: Improved query performance using SORT KEY() and KEY () WITH CLUSTERED COLUMNSTORE columns with integer data types.

  • New Feature: Added support for UNION between reference and sharded tables.  Prior to this, this query shape would hit a lockdown error.

  • New Feature: Added support for SELECT ... INTO AZURE. This command supports the WITH COMPRESSION option, which is described in the next release note.

  • New Feature: Added the WITH COMPRESSION option to SELECT … INTO FS, SELECT … INTO GCS , and SELECT … INTO S3. WITH COMPRESSION writes the SELECT query results, in compressed .gzip files, to an object store.

  • Enhancement: Improved EXPLAIN output to clarify a result table for a broadcast LEFT JOIN or for a MATERIALIZE_CTE as they can have the same result table name. For broadcast LEFT JOIN, a branch operator is added so that the branching operation on the shared result table is reflected. See Query Plan Operations for a detailed explanation of broadcasts and other distributed data movement.

  • Enhancement: Improved query execution for repartition DELETE FROM ...LIMIT and broadcast LEFT JOIN.

  • New Feature: Added support for external functions, as a preview feature. An external function calls code that is executed outside of a SingleStore database. For more information, see CREATE [OR REPLACE] EXTERNAL FUNCTION.