Maintenance Release Changelog
On this page
2024-08-21 Version 8. 1. 51
-
Enhancement: Update to certificate loading behavior.
Prior to this change, only the first certificate was loaded from a server's . pem file specified via the server configuration. Now all certificates are loaded, so if a . pem file contains a certificates chain, then intermediate CA certificates will be returned by the server. -
Enhancement: Updated the distributed OpenSSL license file to to 1.
0. 2zj.
2024-08-08 Version 8. 1. 50
-
Enhancement: Added a new engine variable:
assume_
.udfs_ deterministic This variable controls behavior where SingleStore will do extra work to avoid issues caused by UDFs that return different values when repeatedly invoked (e. g. , are non-deterministic). This variable defaults to false, preserving the existing behavior (since SingleStore version 8. 0), where SingleStore will ensure these computations take place once on an aggregator node. When set to true, SingleStore will avoid this extra layer of coordination (and bottleneck) allowing leaf nodes to independently coordinate. -
Bugfix: Fixed a rare race condition where PITR would incorrectly operate on an unrecoverable database.
-
Bugfix: Fixed a wrong results issue in the combination of ShuffleGroupBy and EncodedGroupBy query plan operations.
-
Enhancement: Added a new engine variable,
sampling_
, used to configure sampling in columnstore tables.estimate_ approach See Statistics and Sampling Concepts for more information.
2024-07-23 Version 8. 1. 49
-
Bugfix: Fixed an issue that could occur when replacing JSON expressions with computed columns in
GROUP BY
lists. -
Bugfix: Fixed an issue that could cause scans using non-unique indexes to return wrong results or to crash.
-
Bugfix: Fixed an issue in parsing manifest files that have more than 4096 characters.
-
Bugfix: Fixed an issue where user defined variables could read collation-related variables incorrectly during a
SET @var = .
command.. . -
Enhancement: Enabled
log_
andfile_ size_ partitions log_
engine variables on SingleStore Helios.file_ size_ ref_ dbs
2024-07-08 Version 8. 1. 48
-
Bugfix: Unneeded sort fields will no longer be projected to the aggregator.
-
Bugfix: Fixed an edge case where unlimited storage garbage collection was causing the master aggregator to run out of connections.
-
Bugfix: Fixed an issue to now avoid prematurely assigning column reference to namespace.
2024-06-25 Version 8. 1. 47
-
Bugfix: Fixed incorrect results in an uncommon scenario where hash join operators with an optimization path need to spill.
-
Enhancement: The
memsql_
now collects additional fields from theexporter mv_
information schema view.activities_ extended_ cumulative -
Bugfix: Fixed a crash that occurred when spilling a hash join operation with at least 3 tables.
2024-06-07 Version 8. 1. 46
-
Enhancement: Improved performance related to
PIPELINES_
information schema table.BATCHES
2024-06-05 Version 8. 1. 45
-
Enhancement: Added the
enable_
engine variable which allows the optimizer to use stale stats instead of querying for stats during optimization.use_ of_ stale_ incremental_ stats -
Enhancement: Added the
throttle_
engine variable which controls how far the system allows a child aggregator to lag behind replicating the transaction log of its master aggregator before throttling is applied to the master aggregator.replay_ behind_ tail_ mb
2024-05-21 Version 8. 1. 44
-
Bugfix: Fixed an issue in
ALTER TABLE
when adding a computed column containingJSON_
.BUILD_ OBJECT -
Bugfix: Addressed a crash issue with
REGEX_
.REPLACE
2024-05-15 Version 8. 1. 43
-
Bugfix: Reduced stack usage during compilation for some
CASE
expressions with manyWHEN-THEN
statements. -
Bugfix: Fixed a potential deadlock issue between background garbage collector threads and foreground query execution threads.
2024-04-30 Version 8. 1. 42
-
Enhancement: Upgraded OpenSSL 1.
0. 2u to 1. 0. 2zj -
Bugfix: Improved the hashGroupBy spilling condition to trigger (spill) when appropriate.
-
Enhancement: Improved memory management for Resource Pools.
Added the
QUERY_
option for resource pools, which restricts memory usage in the pool on a per-individual query basis.MEMORY_ PERCENTAGE This in contrast to MEMORY_
which restricts usage based on total memory used within the current pool.PERCENTAGE For example, when creating or altering a resource pool, setting
MEMORY_
toPERCENTAGE 60%
andQUERY_
toMEMORY_ PERCENTAGE 50%
would configure the system so that all queries running within the specified resource pool should together use a maximum of 60% of system memory, and any single query running within the pool should use, at most, 50% of system memory.Example syntax: CREATE RESOURCE POOL rpoolmain WITHMEMORY_PERCENTAGE = 60,QUERY_MEMORY_PERCENTAGE = 50,SOFT_CPU_LIMIT_PERCENTAGE = 65,MAX_CONCURRENCY = 40; -
Enhancement: Allow Kerberos users to skip password validation for users who are authenticated with plugins.
2024-04-23 Version 8. 1. 41
-
Bugfix: Addressed a crash issue occurring while executing queries with vector builtins on clusters running via Docker containers on Mac machines equipped with Apple silicon processors (M1).
-
Bugfix: Fixed an issue that caused rare "Arrangement already exists in namespace" errors in recursive CTE queries.
-
Bugfix: Fixed a case where a killed query could incorrectly return a JSON error rather than query interrupted message.
-
Bugfix:
MV_
queries can no longer block garbage collection.DISK_ USAGE -
Bugfix: Fixed a crash-on-startup issue on RHEL-based operating systems/kernels (CentOS 9, RHEL, etc.
). -
Bugfix: Fixed a crash that could occur when a scalar subselect is passed as an argument to an external TVF.
-
Enhancement: Added checks to properly handle some corner cases of KAFKA JSON messages.
-
Bugfix: Fixed an issue with restoring from public backups.
-
Enhancement: Subprocess and S3 API tracing are now also enabled via the
enable_
engine variable.subprocess_ tracing
2024-04-02 Version 8. 1. 40
-
Bugfix: Fixed an issue where a log entry ("Skip reading connection attributes") was being written too often.
-
Bugfix: Fixed a JSON insertion failure to old utf8 sample tables that contain utf8mb4 characters by encoding it with base64 format beforehand for backward compatibility.
-
Bugfix: The rule based optimization warning message will only be shown when cost based optimization is meaningful.
-
Bugfix: Fixed a very rare deadlock between
ALTER
of a table and aDROP
of a database. -
Bugfix: Fixed an issue with a blob file leak in a rare crash scenario.
-
Bugfix: Fixed a potential deadlock in a scenario involving DDL, a 2PC transaction, and a concurrent failover.
-
Bugfix: Removed an unnecessary metadata copy to improve JSON performance.
2024-03-19 Version 8. 1. 39
-
Bugfix: Fixed an issue where SingleStore would fall back to heuristic estimates instead of histogram estimates when the table is too large to sample.
-
Bugfix: Fixed an issue in background merger that allowed concurrent deletes of empty segments.
-
Enhancement: Updated timezone data, now using IANA's tzdata version 2024a; new timezones Kyiv, Ciudad_
Juarez, and Kanton supported. -
Enhancement: Enabled additional query hint for non-distributed queries so that first run of those queries can be queued.
2024-03-14 Version 8. 1. 38
-
Bugfix: Fixed a regression with sparse JSON when
use_
is disabled.seekable_ json
2024-03-05 Version 8. 1. 37
-
Enhancement: Added
numInferredPaths
andschemaSize
as new columns toJSON_
table.COLUMN_ SCHEMA numInferredPaths
is the number of key paths inferred for the segment.schemaSize
is the size ofschema_
in bytes.json -
Bugfix: Added safety checks around dropping databases without exclusive access to storage.
-
Enhancement: Added spilling metrics for TopSort (
ORDER BY with LIMIT
). -
Bugfix: The existing websocket connection will be closed when variables are updated in global scope.
-
Bugfix: Removed the hardcoded 'collation_
server' from constant. StrictModeParams. -
Enhancement: Added new metrics to
memsql_
based onexporter information_
columns.schema. mv_ sysinfo_ disk -
Bugfix: Fixed a potential data leak in out-of-memory reports.
-
Bugfix: Fixed an issue in backup restore when the backup has a corrupted GV timestamp in the about snapshot record.
-
Bugfix: Fixed an issue with exporter not working with Public-Key Cryptography Standards #8(PKCS#8) pem format.
-
Bugfix: Fixed an issue with
hex()
not handling decimal types correctly. -
Bugfix: Fixed a crash that occurred when trying to grant access to the table with no context database in per-privilege mode.
-
Enhancement: Added logging to heartbeat thread in order to better diagnose process stalls.
This logging is enabled/disabled via the new verbose_
engine variable.time_ heartbeat_ thread The default value is off
, setting this toon
will enable the logging. -
Bugfix: Fixed an issue in backup restore when the backup has a corrupted GV timestamp in the about snapshot record.
-
Bugfix: Addressed a family of issues relating to optimal execution of JSON extracts on schema'd data.
2024-02-14 Version 8. 1. 36
-
Enhancement: The new engine variable
parametrize_
allows JSON keys to be parametrized and plans can be reused.json_ keys -
Bugfix: Fixed the change to aggregator activity queries in
memsql_
not being applied properly.exporter -
Enhancement: Reduced amount of memory used by unlimited storage file listing, including point-in-time recovery (PITR).
-
Enhancement: Added an engine variable,
innodb_
.lock_ wait_ timeout This variable exists for backwards compatibility with MySQL and is non-operational in SingleStore Helios. -
Enhancement: Backups now throttle after the snapshot.
-
BugFix: Fixed an issue where a backup would carry metadata about the retention period of the backed up unlimited storage database.
2024-02-06 Version 8. 1. 35
-
Enhancement: Added ability to
memsql_
to always return all sub-activities of an aggregator activity.exporter -
Enhancement: Improved ability to configure
librdkafka
through credentials. -
Enhancement: Added the column name to the error message when an invalid date/time is inserted into a column.
-
Enhancement: The new engine variable
max_
sets the maximum amount of memory required when creating or attaching a database.table_ memory_ room_ mb Configuring this engine variable allows more control over whether a detached database can be reattached. -
Enhancement: Increased the maximum value to 15 for the
backup_
engine variable.multipart_ upload_ concurrency -
Bugfix: Fixed a segmentation fault (crash) from appearing after terminating a query on the remote node.
-
Bugfix: Fixed the out of memory issue caused by operators generated for wide user tables during the optimization phase.
-
Bugfix: Fixed an issue where the incorrect number of rows would be shown when performing a select into object storage.
-
Bugfix: Fixed an issue with
FROM_
andBASE64 TO_
built-ins when processing large string inputs, preventing potential errors in reading communication packets.BASE64 -
Bugfix: Fixed an issue with
START PIPELINE FOREGROUND
skipping files in some circumstances.
2024-01-24 Version 8. 1. 34
-
Enhancement: Improved error messages when downloading backups.
-
Enhancement: Added the
blob_
andcache_ miss_ b blob_
columns to the following information schema views:cache_ wait_ time_ ms information_
,schema. plancache information_
,schema. MV_ ACTIVITIES information_
,schema. MV_ ACTIVITIES_ CUMULATIVE information_
,schema. MV_ TASKS information_
, andschema. MV_ FINISHED_ TASKS information_
.schema. MV_ QUERY_ ACTIVITIES_ EXTENDED_ CUMULATIVE -
Bugfix: Fixed an issue where
INSERT.
queries with a. . SELECT partition_
filter generating an error.id() -
Bugfix: Fixed an issue with memory crashing when using
REGEXP_
,MATCH JSON_
, orINCLUDE_ MASK JSON_
built-ins.EXCLUDE_ MASK -
Enhancement: Improved performance for
JSON_
built-ins inEXTRACT_ <type> ORDER BY
clauses. -
Enhancement: Added the ability for users to kill queries on a remote node without the user having
PROCESS
privileges. -
Bugfix: Fixed an allocation issue that caused poor performance on high load insertion queries.
-
Bugfix: Fixed an issue with memsql_
exporter working improperly in ANSI_
QUOTES sql_
.mode -
Enhancement:
ALTER PIPELINE
settingmax_
to use a default 0 value is now allowed.partitions_ per_ batch -
Bugfix:
JSON_
escape characters were not working as expected.KEY -
Enhancement: Added the
bottomless_
engine variable, which when enabled, completes additional verification of persisted files immediately after upload.experimental_ blobstore_ mode This mode is experimental and may reduce upload speed. Please use with caution. -
Enhancement: Introduced blob cache profiling metrics for columnstore tables on unlimited storage databases.
Refer to the PROFILE page for more information on what blob cache metrics are available. -
Bugfix: Fixed a bug which corrupts databases whose log size is not a power of two pages.
2024-01-03 Version 8. 1. 32
-
Enhancement: Updated the
information_
view to reflect the account status for locked users.schema. USERS -
Bugfix: Fixed a crash that occurred when user-defined variables are used in the
GROUP BY
andORDER BY
clauses. -
Bugfix: Fixed an issue where filtering with a
JSON_
function performs inconsistently.EXTRACT_ <type> -
Bugfix: Fixed a network communication error that occurred after query rewrites.
-
Bugfix: Fixed an issue where JSON computed column matching incorrectly triggers a
JSON_
function.EXTRACT_ <type> -
Bugfix: Modified computed column matching to accurately evaluate JSON expressions containing equality and non-safe equality comparisons.
-
Bugfix: Fixed an error that occurred when a user attempts to access a view that is based on a table that has no privileges granted on it.
-
Enhancement: Improved the ability to kill queries containing JSON built-in functions.
-
Enhancement: The query optimizer now considers more
LEFT JOIN
elimination cases. -
Enhancement: Introduced a new session engine variable
optimizer_
which disables predicate transitivity on query rewrites.disable_ transitive_ predicates -
Enhancement: Added more log messages for backup sub-process errors.
2023-12-5 Version 8. 1. 31
-
Added support for creating a
DEEP COPY
of tables with computed columns.(8. 1. 31) -
Added additional config and credential option validation while creating pipelines.
(8. 1. 31) -
Fixed an issue where valid
LINK
config and credential parameters were not supported for both reading from and writing to a datasource.
2023-11-28 Version 8. 1. 30
-
Fixed an issue where the number of rows affected with
SELECT INTO
object storage was erroneously reported as 0 rows. -
Fixed an issue where small tables use an inappropriately small sample size by setting a lower bound.
This mostly affects reference tables.
2023-11-21 Version 8. 1. 29
-
Fixed a potential crash that could occur when
LOAD DATA
is used without a database context. -
Pipeline state is now shown consistently across primary and child nodes.
-
Fixed an issue with the
SET
clause of theCREATE PIPELINE
statement: now it is possible to use type options likeNULL/NOT NULL/COLLATE.
with. . :>/!:>
typecast operators. -
Added a new engine variable
pipelines_
to specify the JVM heap size limit for CDC-in pipelines.cdc_ java_ heap_ size
2023-11-13 Version 8. 1. 28
-
Fixed an issue with
JSON_
used in UDFs.SET_ JSON -
Fixed a potential issue related to hash join spilling.
-
Reduced blocking in query compilation after evicting many (10K+) plans in the plancache.
2023-11-07 Version 8. 1. 27
-
Added three new fields to
MV_
:SYSINFO_ DISK -
READ_
: Number of read operations performed by the device since start up.OPERATIONS_ CUMULATIVE_ PER_ DEVICE -
WRITE_
: Number of write operations performed by the device since start up.OPERATIONS_ CUMULATIVE_ PER_ DEVICE -
DEVICE_
: Name of the device to which the values inNAME read_
andoperations_ cumulative_ per_ device write_
are associated.operations_ cumulative_ per_ device
-
-
Disabled
order_
rewrite when an ORDER BY contains an indeterminate function.by_ self_ join -
Disabled group-by on encoded data when there is an aggregate on full-text match.
-
Fixed a potential security issue with users created without a password.
-
Fixed some cases where
APPROX_
erroneously included nulls in the count.COUNT_ DISTINCT_ ACCUMULATE -
Fixed an issue preventing correct ingestion from MongoDB® collections with dot symbols.
-
Fixed an issue in CDC pipelines that could lead to Java Out Of Memory errors.
-
Improved performance during snapshotting for CDC-in pipelines.
-
Changed the SingleStore Helios workspace default and range for the
pipelines_
engine variable.cdc_ row_ emit_ delay_ us Throttling default value is set to 1. The supported range is from 0 to 1000000. -
Addressed some performance issues that occur when performing large sets of security operations (creating a lot of groups/users/roles, etc.
) via the new privilege_
engine variable.caches_ update_ mode This variable can be used to temporarily disable updating privilege caches while performing security operations such as: granting/revoking permissions to/from users, granting/revoking permissions to/from roles, adding/deleting roles to/from groups, adding/deleting users to/from groups, role deletion, group deletion.
This can result in a performance gain. IT IS IMPORTANT that the privilege cache updates be reenabled (value set back to
always
) once the administration work is finished.To use this variable:
-
Set the value to
never
. -
Perform the operations.
-
Set the value back to
always
.
-
-
Fixed a crash caused when
AS WASM/WITH WIT
is used in aCREATE AGGREGATE
statement that (1) doesn't haveHANDLE
as the state type, and (2) doesn't supply theSERIALIZE
andDESERIALIZE
callbacks. -
Fixed an issue where error messages were not generated when corrupt blob was encountered during json encoding read/write.
-
Added additional node metrics to the /cluster-metrics endpoint of the
memsql_
.exporter
2023-10-17 Version 8. 1. 26
-
Reverted the ability to use SSL keys with a password in the HTTP API.
2023-10-11 Version 8. 1. 25
-
Fixed an upgrade issue where some databases could temporarily become unrecoverable if snapshots were skipped during a pre-upgrade on a recently attached unlimited database.
-
Fixed an issue preventing nodes from attaching during upgrade.
-
Added ability to use SSL keys with a password in the HTTP API.
-
Added support for simple multi-column update with sub-query.
2023-10-03 Version 8. 1. 24
Warning
Versions 8.
-
Added resource pool metrics to the /cluster-metrics endpoint of the
memsql_
.exporter -
Added ability to infer CSV data with text boolean values.
-
Fixed background pipelines not respecting max concurrency limit in the resource pool.
Please note that this change will affect previously created pipelines using a constrained resource pool, including the error state if MAX_
is exceeded.QUEUE_ DEPTH -
Fixed an issue with two-phase commit that could lead to loss of atomicity on databases restored from 8.
1 backups. -
Fixed an issue with the transaction log not being downgradable to previous 8.
1 patch releases. -
Fixed an issue where two-phase commit would not work correctly on disaster recovery failovers.
-
Improved the performance of
mv_
for clusters with large DR databases.replication_ status
2023-09-25 Version 8. 1. 23
-
Improved blob cache sync performance when there is no running query.
-
Added support for flipping join order for
FULL OUTER JOIN
operations.
2023-09-19 Version 8. 1. 22
-
Fixed an issue where unlimited storage databases stored on Amazon S3 could run out of connections under intense loads.
2023-09-15 Version 8. 1. 21
-
Fixed a bug where leaf failover and
ATTACH LEAF
would copy extra partitions. -
Fixed an issue where the rebalance done by
ATTACH LEAF
was unstable with respect toREBALANCE ALL DATABASES
. -
Fixed an issue where an incorrect result is produced when the engine variable
query_
is set withparallelism flexible_
.parallelism query_
is deprecated andparallelism query_
should be used instead.parallelism_ per_ leaf_ core -
Removed an unexpected warning related to the engine variable
query_
(which is deprecated) when a query contains anparallelism ORDER BY
clause with anIN
list filter that matches the table's shard key. -
The
START TRANSACTION
command is no longer allowed from Data API unless it is inside a stored procedure. -
Now redirecting the AWS-GO-SDK log to a file instead of writing to
stdout
. -
Fixed a bug where an aggregator result table hits a lockdown when
sql_
is set.select_ limit -
Added two engine variables:
max_
which sets a limit on the number of expressions within an entire query andexpression_ query_ limit max_
which sets a limit on the number of expressions within a query item.expression_ item_ limit Both can be set to a range between 100
and the maximum unsignedINT
value.Setting these engine variables to the maximum unsigned INT
value disables both features. -
Fixed an issue where a crash occurs where the engine improperly rewrites queries with a
UNION
in anEXCEPT
clause.
2023-09-05 Version 8. 1. 20
-
Fixed several issues causing slow compilation for queries over wide tables.
-
Added two engine variables,
jwks_
andusername_ field jwks_
to add flexibility and improve security.require_ audience -
Added support for materializing CTEs without recomputing them when the query contains
UNION
,UNION ALL
, and otherSET
operations.To enable the feature, set the engine variable allow_
tomaterialize_ cte_ with_ union TRUE
.The default value for this engine variable is FALSE
for version 8.1. 19 and earlier. -
Fixed a memory leak issue in the
memsql_
process.exporter -
Enhanced the performance of DDL statements for role manipulation.
2023-08-28 Version 8. 1. 19
-
The
SHOW COLUMNAR MERGE STATUS
command now outputs status for tables with empty sort keys. -
The following commands now respect non-default
columnstore_
values:table_ lock_ threshold INSERT .
,. . SELECT . . . ON DUPLICATE UPDATE REPLACE .
, and. . SELECT REPLACE .
.. . LOAD -
Fixed an issue where
VECTOR_
was returning incorrect results on shard tables.MUL -
Fixed an issue where
memsql_
was generating too much "pipeline_exporter error" data. -
Fixed an issue with the Kerberos cache for HDFS pipelines.
-
Improved memory consumption in json decoding.
-
Fixed an issue where
LIMIT
andOFFSET
after a window function with noPARTITION BY
clause were returning incorrect information. -
The
WARM BLOB CACHE FOR INDEX
command can now accept index names that conflict with reserved identifiers (such as PRIMARY, etc.).
2023-08-23 Version 8. 1. 18
-
Added support for the
REGEXP_
function.MATCH() This function returns a JSON array of matching substring(s) within the first match of a regular expression pattern to a string. -
Improved performance of multi-part GCS backups.
-
Introduced a new global engine variable
json_
which limits the number of JSON key paths inferred within a segment.document_ max_ leaves The default value is 10000
.
2023-08-09 Version 8. 1. 17
-
Fixed an issue where
BACKUP
orRESTORE
of an existing backup from GCS fails on SingleStore versions newer than 8.1. 6. -
Fixed an issue where
BACKUP DATABASE WITH INIT
would fail under out-of-memory conditions. -
Fixed a potential crash in NFS backup when encountering an IO error.
2023-08-08 Version 8. 1. 16
-
Added support for multiple uncorrelated IN-subselects in more query shapes.
-
SKIP PARSER ERRORS
is now supported for Kafka.Additionally, a new related engine variable, pipelines_
, has been added.parse_ errors_ threshold -
Fixed an issue with the incremental restore of an unlimited database that would fail if the restore was larger than the disk.
-
SingleStore automatically rewrites A=B OR (A IS NULL AND B IS NULL) to null safe equal (A<=>B) to enable hash joins.
-
Added support for hash joins on null-accepting expressions in the ON condition of outer joins.
-
Fixed an issue with significant memory reduction from spilling for hash join queries with variable length strings (varchar, text, etc.
) involved.
2023-08-02 Version 8. 1. 15
-
Introduced a new global variable,
dr_
, which allows users to adjust the minimum timeout period in Disaster Recovery (DR) replication.min_ connection_ timeout_ ms
2023-07-27 Version 8. 1. 14
-
Fixed a bug that could cause Amazon S3 pipelines to stop loading data.
2023-07-26 Version 8. 1. 13
-
Added support for Control Group v2 (cgroup v2).
-
Fixed an issue where a large spike in the query memory consumption on a any SingleStore node could cause replicas on the same node to become unrecoverable.
-
Fixed a pipeline wrong state issue caused by an error in a table with a computed column.
-
Fixed a potential issue where
REBALANCE PARTITION
would not stabilize to a partition placement on a read replica's workspace. -
Fixed a potential crash in some edge cases when using Parquet pipelines.
2023-07-18 Version 8. 1. 12
Warning
Version 8.
-
Fixed an issue with upgrade steps not running in some edge cases.
A logging change was required, making the log format incompatible with earlier patch releases. -
Fixed a crash that may occur when using
SELECT … FOR UPDATE … LIMIT <n>
in a multi-statement transaction whentwo_
is ON.phase_ commit -
Fixed a bug where the permissions do not clear for Data Manipulation Language (DML) queries and then leak to subsequent Data Definition Language (DDL) queries.
-
Fixed a bug where the
mv_
table would show incorrect results for the plancache directory.disk_ usage -
Default values for BLOB/TEXT and JSON columns are allowed, as well as NULL and empty strings.
Fixed a bug where utf8mb4 characters were not allowed inside default values for CHAR/VARCHAR columns. CREATE TABLE table_1(col_1 JSON DEFAULT {'amt': 10});CREATE TABLE table_2(col_1 BLOB DEFAULT ('xyz'));CREATE TABLE table_2(col_1 longtext DEFAULT '{...}'); -
Fixed a potential issue where changing a user password would not change the connection pool password in the Data API.
-
Reverted the performance improvements for backups to GCS (Google Cloud Storage).
2023-07-10 Version 8. 1. 11
-
Bugfix: Fixed a crash that may occur when a function calls more than one external function.
In the following example
get_
is an external function:embedding() SELECT DOT_PRODUCT(JSON_ARRAY_PACK(get_embedding('house')),JSON_ARRAY_PACK(get_embedding('car')) -
Added an opt-in optimization to Kerberos for HDFS pipelines to reduce the amount of requests.
-
Added a
LimitNICE
value into the service file.This change affects installations where SingleStore Helios is running as a service. -
Fixed a JSON formatting issue for the
PARTITION_
event inUNRECOVERABLE MV_
details column.EVENTS -
Fixed the dependency on
PIPES_
inside user defined functions.AS_ CONCAT sql_ mode The sql_
state is now stored when a user defined function is created and used whenever the function is executed.mode
2023-07-07 Version 8. 1. 10
-
Fixed a bug in
memsql_
that may cause it to stop accepting HTTP requests.exporter
2023-07-06 Version 8. 1. 9
-
Added support for opaque OAUTHBEARER tokens in Kafka Pipelines.
-
Added support for
ROW_
information function within views.COUNT -
SingleStore does not support using the environment variables to initialize OpenSSL 3.
-
Added two engine variables (
workload_
andmanagement_ enable_ large_ memory_ classification workload_
) to help tune workload management to better support queuing with high memory queries.management_ available_ leaf_ memory_ ratio
2023-06-26 Version 8. 1. 8
-
Fixed a bug where a pipeline would fail with error code 2789.
The error occurred when the pipeline's "cursor offset" was below its "earliest offset". -
Fixed a bug where a
HashJoin
on a materialized CTE gets executed as aNestedLoopJoin
in some query shapes causing slow join performance. -
Fixed the
SPLIT
string function that was not detecting the correct argument type when used inside a table-valued function (TVF) or a user-defined scalar-valued function (UDF). -
Improved the accuracy of the
blob_
statistic in query profiles.fetch_ network_ time -
Added metrics to
memsql_
that show the breakdown of disk usage by SingleStore Helios.exporter Also, added metrics to memsql_
that show unlimited storage utilization statistics.exporter -
Fixed a bug with the
blob_
statistic in query profiles.fetch_ network_ time -
Fixed a performance bug about queue size when flexible parallelism is enabled.
Overall query performance is increased. -
Fixed an issue where, when parsing a table with many secondary keys, an incorrect name was used to refer to table's the primary key.
-
Enhanced the on-disk plancache functionality by shrinking the plancache when disk space gets low and the on-disk plancache is using at least 25% of available disk space.
-
Fixed a bug where unlimited storage garbage collection could occur before a partition could recover from that version.
2023-06-21 Version 8. 1. 7
-
Fixed a vulnerability in
memsql_
by updating Go Prometheus client to 1.exporter 15. 1. -
Added a metric to the
memsql_
that shows whether there are unavailable partitions in any database.exporter -
PAM (Pluggable Authentication Module) users are now allowed to start and configure the
memsql_
process.exporter -
Added support for disk spilling for
LEFT OUTER JOIN
query shapes. -
Added the
max_
engine variable.execution_ time It is unused and setting this variable has no effect. It exists so certain MySQL-compatible apps that have this variable set will not fail when connected to SingleStore Helios. -
Added
mv_
anddisk_ usage mv_
information schema tables that report the breakdown of disk utilization by SingleStore Helios.data_ disk_ usage -
Fixed an issue on sample tables that can be created with different collations on different partitions.
-
Fixed an issue where JSON computed column matching incorrectly triggers a JSON function.
-
Introduced the 8.
1 data_
which provides additional out-of-range checks for theconversion_ compatibility_ level TIMESTAMP
data type. -
Fixed a rare case where the query optimizer re-wrote a query into a non-equivalent query which produced more result rows.
2023-06-12 Version 8. 1. 6
-
Improved the performance of backups to GCS (Google Cloud Storage).
GCS backups are not using multi-part uploads. -
Fixed unlimited storage S3 multipart uploads to properly retry on 200 responses which contain an embedded "SlowDown" error, instead of failing immediately.
-
Fixed an issue where memory accumulates over time if reshuffle or repartition operators are executed for many unique query shapes.
-
Fixed an issue with crashes that occur when SSL is enabled on universal storage databases.
-
The
FLUSH EXTRACTOR POOLS
command now runs on all nodes in a cluster when run on an aggregator. -
Improved the
memsqlctl
management tool'sdescribe-node
property variables command to display global variables instead of session variables.
2023-05-30 Version 8. 1. 5
-
Disabled semi-join operator reduction optimization.
2023-05-28 Version 8. 1. 4
-
Fixed an issue where the query optimizer could choose incorrectly between using the
HashGroupBy
or theStreamingGroupBy
operators. -
Added more information about blob files that need to be downloaded from unlimited storage to the blob cache when running
PROFILE
. -
Fixed rare issue with sync durability and unlimited storage that could cause log file corruption in the blob storage.
-
Fixed an issue with optimizing queries containing no-operation predicates such as 1=1.
-
Improved the performance of a left join of a reference table with a sharded table by pushing the reference table clauses to the leaves.
The engine variable disable_
must be set to "OFF" to enable this operation.reference_ table_ leftjoin_ where_ pushdown -
Now allowing child aggregator root users to be dropped even if the
sync_
engine variable is enabled.permission -
Removed the restrictions on the names of JWT users.
Customers may now create users with names that look like UUIDs and emails.
2023-05-24 Version 8. 1. 3
-
Fixed a bug with error handling that produced spam messages.
-
Backups taken from the 8.
1. 3 release (and subsequent 8. 1 releases) are no longer restorable into the previous 8. 1 releases (8. 1. 1 and 8. 1. 2). -
Removed the
EXECUTE
permission requirements for Kai internal UDFs. -
Changed the system information built-ins to use the utf8_
general_ ci collation for the collation_
value.server
Last modified: August 26, 2024