2.00.11

Enhanced Configuration Access Security: (2.00.11.17)

• Added configuration parameter enableConfigAccessControl to control whether permission checks are applied when accessing configuration parameters.

• Updated function getConfig/getConfigure to filter returned results based on the security level of each configuration item and the current user’s permissions when enableConfigAccessControl=true.

Added configuration parameter enableInsertStatementForDFSTable to set whether the insert into statement is allowed for DFS tables. (2.00.11.16)

insert into statement now supports inserting multiple rows. (2.00.11.16)

Added configuration parameter resourceSamplingLogDir to set the directory for storing resource tracking logs. (2.00.11.16)

Added configuration parameter batchJobFileRetentionTime to set the retention time for batch and scheduled job results. (2.00.11.16)

Added configuration parameter enableAuditLog to enable audit logs. Added function getAuditLog to query audit logs and auditLogRetentionTime to set audit log retention time. (2.00.11.16)

Replaced the memory manager from tcmalloc_minimal with tcmalloc and added functions startHeapSample, dumpHeapSample, and stopHeapSample for heap sampling. (2.00.11.15)

Added configuration parameter maxJoinTaskRetry to specify the maximum retry attempts for a single SQL JOIN task under memory pressure.. (2.00.11.15)

Added function fromStdJson for parsing standard JSON objects into DolphinDB variables. (2.00.11.6)

Added function sqlTuple to generate metacode with a tuple expression. (2.00.11.3)

Added functions adfuller and coint for cointegration testing. (2.00.11.2)

Added configuration parameter s3Endpoint for accessing AWS S3. (2.00.11.2)

Added function regexFindStr to find substrings that match a regular expression in a given string.(2.00.11.1)

Added functions highLong and lowLong to parse 16-byte data (such as INT128, UUID, IPADDR) to high-order and low-order 8-byte long integer data. (2.00.11.1)

Added configuration parameter enableDFSQueryLog to configure whether to log all DFS queries. (2.00.11.1)

Soft delete can be enabled for TSDB databases with newly added parameter softDelete. A soft delete marks a record as no longer active or valid without actually deleting it from the database. Soft deletes can improve performance, and can allow "deleted" data to be recovered. (2.00.11)

Added support for using the OVER clause with window functions which compute values over a particular window (group of rows) and return a single result for each row, including: sum, avg, std, stdp, var, varp, count, min, max, skew, kurtosis, med, rank, dense_rank, percent_rank, row_number, cume_dist, lead, lag, ntile, first_value, last_value, and nth_value. (2.00.11)

Implemented user-level resource management (2.00.11):

• Added function getUserHardwareUsage to get CPU and memory usage samples.

• Added function getUserTableAccessRecords to get SQL queries on DFS tables.

• Added functions enableResourceTracking and disableResourceTracking to enable and disable resource isolation.

• Added configuration parameters resourceSamplingInterval, resourceSamplingMaxLogSize, and resourceSamplingLogRetentionTime to set the collection interval, log splitting size threshold, and log retention time for usage sampling.

Added configuration parameter jobParallelismHardLimit to limit the maximum number of workers a job can use to the parallelism of that job. (2.00.11)

Added configuration parameter defaultJobParallelism to set the default parallelism for jobs submitted by users. (2.00.11)

Added configuration parameter datanodeRestartLevel to set the triggering condition for the controller to automatically restart the data/compute node. Added function setDatanodeRestartInterval to set the restart interval online and function getDatanodeRestartInterval to obtain the configured datanodeRestartInterval. (2.00.11)

Added configuration parameters thirdPartyCreateUserCallback and thirdPartyDeleteUserCallback to call back specified function views when using the createUser and deleteUser functions. (2.00.11)

Added functions RidgeCV, ElasticNetCV, and LassoCV for cross-validation of machine learning models. (2.00.11)

Added functions iminLast/imaxLast/miminLast/mimaxLast/rowIminLast/rowImaxLast to return the maximum index for multiple extreme values. (2.00.11)

Added financial functions bondDirtyPrice, and bondConvexity to calculate the bond duration, dirty price and convexity. (2.00.11)

Added function signbit to get the sign of ±0.0. (2.00.11)

Added function submitJobEx2 which has similar functionality as submitJobEx but supports passing in a callback function. (2.00.11)

Added functions polyFit and poly1d for polynomial fitting. (2.00.11)

Added function cubicSpline and cubicSplinePredict for cubic spline interpolation and prediction. (2.00.11)

Added function kendall to calculate the Kendall rank correlation coefficients. (2.00.11)

Added functions clip and clip! to truncate data outside a given range. These functions have similar functionality to numpy.clip. (2.00.11)

Added function tableUpsert which has the same functionality as upsert! but returns the number of records that have been updated and inserted. (2.00.11)

Added function brentq to find a root of a function in a bracketing interval using Brent's method. (2.00.11)

Added function snippet to return the results as a STRING scalar. (2.00.11)

Added function socp which minimizes a linear objective function within specified constraints for solving second-order cone programs. (2.00.11)

Added configuration parameter enableLocalDatabaseto enable or disable local database creation. (2.00.11)

Added maintenance function getTSDBDataStat to obtain statistics of the TSDB engine. (2.00.11)

Added function existsStreamTable to check if a stream table exists. (2.00.11)

Added function getStreamTables to get the information of all stream tables. (2.00.11)

Added function createRuleEngine to create a streaming rule engine which validates the inputs with user-defined rule sets. Added functions updateRule and deleteRule to update or delete the rule sets. (2.00.11)

Added function createNarrowReactiveStateEngine to create a reactive state engine that reorganizes the results into a narrow format. Added function addReactiveMetrics to add new metrics to the engine and function getReactiveMetrics to retrieve metrics. (2.00.11)

Added support for defining vectors or tuples across multiple lines. (2.00.11.16)

Added support for using UUID columns as sort columns in distributed tables in TSDB. (2.00.11.16)

Improved error handling in distributed queries when comparing CHAR constants with STRING partitioning columns in the WHERE clause. The system now raises an error message. (2.00.11.16)

Enhanced the DELETE statement performance. (2.00.11.16)

Enhanced the stability of batch job execution under high-load and high-concurrency scenarios. (2.00.11.15)

Enhanced the stability for concurrent SQL queries. (2.00.11.15)

Enhanced the system security. (2.00.11.15)

Added the “updateTime” field to the backup log file. (2.00.11.15)

Added the recording of operations on the persisted MVCC table to the log. (2.00.11.15)

Improved memory efficiency when processing speed was slow. (2.00.11.14)

The parseJsonTable function now accepts tables containing BLOB columns. (2.00.11.12)

Enhanced the security of the login system by implementing IP-specific lockouts. Multiple failed login attempts occur from a particular IP address will temporarily block further login attempts only from that specific IP. (2.00.11.12)

Optimized the checkpoint mechanism to reduce the checkpoint frequency for massive metadata on the controller. (2.00.11.12)

Optimized the loading speed of persisted stream tables. (2.00.11.12)

When using the upsert! function to update tables (keepDuplicates=ALL) in TSDB databases, the keyColNames parameter can include only certain columns specified by sortColumns. (2.00.11.11)

Enahanced user access control for function views and module functions. (2.00.11.9)

Added support for creating a matrix of STRING type. (2.00.11.4)

When invoking getCurrentSessionAndUser within the handler parameter of subscribeTable, it will return the "sessionID" of the session from which the subscribeTable operation was executed. (2.00.11.3)

When invoking getCurrentSessionAndUser within the filter parameter of streamFilter, it will return the "sessionID" of the session from which the stream filter engine was created. (2.00.11.3)

When parameter triggeringPattern of function createCrossSectionalEngine is set to "dataInterval", the calculation will now be triggered only for intervals where new data has been received, instead of for all intervals. (2.00.11.3)

The args parameter of function makeUnifiedCall now supports input of metacode with a tuple expression. (2.00.11.3)

Function hex now can convert floating numbers to hexadecimal. (2.00.11.3)

Trading calendar now can specify weekends as trading days. (2.00.11.3)

Function backup supports backup of cold data. (2.00.11.3)

Partial application now supports using object methods. (2.00.11.3)

Function replayDS supports input of DECIMAL type. (2.00.11.2)

Non-key columns of a keyed stream table can be array vectors. (2.00.11.2)

Lambda expression supports object.method(...) usage. (2.00.11.2)

Specific elements in array vectors and columnar tuples can be modified by referring to their row and column indices. (2.00.11.2)

Optimized the performance of select, update, and delete when using makeKey. (2.00.11.2)

Optimized the precision of results returned by function format. (2.00.11.2)

The JIT version does not support chained operation with append!. (2.00.11.2)

A new column "owner" that displays the object creator is added to the table returned by function objs when querying shared variables. (2.00.11.1)

The following functions support specifying trading calendars when taking arguments of DURATION type: interval, wj, twindow, temporalAdd, duration, move, tmove, moving, tmovingWindowData and time-based moving functions. (2.00.11.1)

Added parameter method to function ols to allow users to construct coefficient matrices and inverse matrices or use singular value decomposition for ordinary least squares. (2.00.11.1)

Optimized the performance of temporalAdd when adding trading days to a temporal vector. (2.00.11.1)

Empty objects are allowed in the following higher-order functions: each, eachPre, eachPost, eachLeft, eachRight, cross, reduce, accumulate, any, all, loop, and ploop. (2.00.11.1)

The values in the dictionary passed to the transpose function can be specified as scalars. (2.00.11.1)

Added support for Copy-On-Write (COW) of dictionaries and tuples. (2.00.11.1)

Line breaks are supported before the member(.) operator in scripts. (2.00.11.1)

Integrated modules and function view functionality (2.00.11):

• Enabled namespace (module) for function view to prevent name conflicts. Any addition or deletion operations on function views will be synchronized and persisted to all nodes in a cluster.

• Modified VIEW_EXEC privilege to enable operations on all function views within the specified modules.

Enhanced access control on job cancellation. (2.00.11)

The value of a dictionary can take the DECIMAL type. (2.00.11)

window join supports special windows (= 0:0). The windows over the right table are determined by the current timestamp in the left table and its previous timestamp. (2.00.11)

Added return values for function schema (2.00.11):

• the database and table creator;

• compression algorithm for each column;

• whether soft delete is enabled.

The loadPlugin function allows directly loading the plugin by specifying the filePath parameter as the plugin name. (2.00.11)

The backup function now supports setting backupDir to a directory on AWS S3. (2.00.11)

Functions rowlmax and rowlmin now support passing array vectors as inputs. (2.00.11)

Enhanced functions transFreq, asFreq, and resample (2.00.11):

• The closed and label parameters have been relaxed to allow more flexible specification when the time precision of rule is larger than day.

• Added support for multiple trading days frequency for operations.

Function moving now supports passing a matrix as input (2.00.11).

Added support for online update for licenses with trial authorization. (2.00.11)

Function rowAt now supports taking columnar tuples as input. (2.00.11)

Function unpack now supports taking BLOB data as input. (2.00.11)

Enhanced higher-order functions byRow and byColumn: (2.00.11)

• Added support for symbols :H and :V which can be composed together.

• Added support for taking array vectors and columnar tuples as inputs.

Function transpose now supports taking array vectors and columnar tuples as inputs. (2.00.11)

Functions toJson and toStdJson support escape characters when converting BLOB types. (2.00.11)

Optimized the performance of functions scs and quadprog. (2.00.11)

The unionAll function supports null values for the first element when the input is a tuple. (2.00.11)

The memory taken up by the dimension table now will be released automatically. (2.00.11)

Function replaceColumns! supports replacing multiple columns of an in-memory table. (2.00.11)

Optimized query performance for the case when the TSDB table has more than two sortColumns and sort key hashing is enabled. (2.00.11)

For value-partitioned tables with partitioning columns of STRING or SYMBOL type, configuration parameter ignoreSpecialCharacterInPartitionId is added to specify whether to ignore ':' and '.' in partitioning columns when creating partition directories. (2.00.11)

Optimized the performance of function createAsofJoinEngine. (2.00.11)

Added parameter outputElapsedMicroseconds for the asof join engine and lookup join engine to output the elapsed time of each calculation. (2.00.11)

Functions createAsofJoinEngine, createSessionWindowEngine, and createLeftSemiJoinEngine now support passing array vectors as inputs. (2.00.11)

The calculation of time series engine now can be triggered by each incoming record with updateTime = 0. (2.00.11)

Added parameterskeyCapacity and parallelism for the reactive state engine to address the performance issue when calculating within a large number of groups. (2.00.11)

The state function defined in metrics of a reactive state engine now supports using for loops. (2.00.11)

Added parameter keepDuplicates for the lookup join engine to specify whether to keep all matching records in the right table. (2.00.11)

Added parameter subWindow for the time series engine to enable calculations in a subset time range within the window. (2.00.11)

Enhanced the streaming monitoring with function getStreamingStat for the status of workers of subscriber nodes. (2.00.11)

Function tmsum2 can be used as a state function in a reactive state engine. (2.00.11)

The cumTopN functions can be used as state functions in a reactive state engine. (2.00.11)

Added parameter closed for special windows of the reactive state engine to enable windows to be left-open and right-closed. (2.00.11)

Added option "dataInterval" for parameter triggeringPattern of function createCrossSectionalEngine to calculate at intervals based on timestamps in the data. (2.00.11)

Added option "saltedHash" for parameter dispatchType of function createStreamDispatchEngine to apply a salted hash algorithm on keyColumn and distribute records based on the hash result. (2.00.11)

Added parameter preciseRate of function replay to specify whether to replay at replayRate times the time difference between two adjacent records. (2.00.11)

Data of DECIMAL type now can be calculated in streaming engines. (2.00.11)

Enhanced job execution logs to include detailed tracking for UPDATE and DELETE statements. (2.00.11)

Optimized the query performance on partitioned tables which contain over 100000 rows or over 1000 partitions. (2.00.11)

• The GROUP BY is followed by a non-partitioned column and the SELECT clause uses a function that cannot be distributed, such as a UDF.

• The CONTEXT BY is followed by a non-partitioned column and the [HINT_KEEPORDER] keyword is not used.

For filtering conditions in a distributed query, DATE type can be compared with higher precision temporal types. (2.00.11)

Added size constraints for STRING, BLOB, and SYMBOL data written to distributed databases. (2.00.11)

Updated the exchange calendars for Year 2024. (2.00.11)

Fixed the getUserHardwareUsage function returning unexpected results when provided with dates. (2.00.11.16)

Fixed an error of the backup function on a compo-partitioned database if the filter condition matched the first-level partition and some second-level sub-partitions were empty. (2.00.11.16)

Fixed occasional failures in stream subscription due to data corruption. (2.00.11.16)

In the time-series engine, the nunique, ifirstNot, and ilastNot functions specificed in the metrics argument now support expressions and nested functions as arguments. (2.00.11.16)

Fixed the precision errors of DECIMALs when OLAPCacheEngineSize=0 was configured. (2.00.11.16)

Fixed server crashes caused by using UPDATE/DELETE with WHERE EXISTS. Now it raises an error instead. (2.00.11.16)

Fixed server crashes when the dummyTable specified in createRuleEngine contained a SYMBOL column. (2.00.11.16)

Fixed incorrect JSON serialization of DECIMAL32 values in the toStdJson function. (2.00.11.16)

Fixed occasional hangs on the web client when executing code if the response data size is between 4050 and 4060 bytes. (2.00.11.16)

Fixed the issue where the server entered an infinite loop when executing decimalFormat(0, '0.00E0'). (2.00.11.16)

Fixed the issue where the “lastUpdated” field in the controller metadata could be null after restoring from a backup that was created immediately after a restart without any data updates. (2.00.11.16)

Fixed occasional server crashes when executing SQL queries containing the DISTINCT statement. (2.00.11.16)

Fixed memory leaks caused by transactions with excessively large transaction IDs (greater than 2³¹ – 1) that could not be properly reclaimed. (2.00.11.16)

Fixed an issue where fromStdJson failed to parse JSON strings containing empty objects with closing braces on a new line. (2.00.11.16)

Fixed potential server crashes when the stream dispatch engine writes data to an asynchronously persisted stream table with stacked threads. (2.00.11.15)

Fixed an issue in heterogeneous replay where data sources (generated by replayDS with timeRepartitionSchema specified) were replayed in a disordered manner. (2.00.11.15)

Fixed server crashes when querying a keyed or indexed table with multiple primary key columns, where the filter condition contained an empty SYMBOL vector. (2.00.11.15)

Fixed an issue in high-availability clusters where an existing table handle could not access data from newly added partitions without obtaining a new handle (reloading table via loadTable). (2.00.11.15)

Fixed server crashes when incorrect parameters were passed to the makeKey function within a WHERE clause. (2.00.11.15)

Fixed a data loss issue in N-to-N replay that occurred when the data being replayed included empty partitions. (2.00.11.15)

Fixed a "unrecognized column name" error that occurred when executing a multi-table JOIN query, if some partitions were offline due to node failures in the cluster. (2.00.11.15)

Fixed an issue where calculating maximum (via max) of a STRING column (with the first row being null) by group could result in incorrect results. (2.00.11.15)

Fixed a memory leak when calling a user-defined recursive function. (2.00.11.15)

Fixed server crashes that occurred when queries with lead/lag analytic functions were executed in MySQL syntax mode. (2.00.11.15)

Fixed an error when deleting column(s) from a keyed table if any column name contains uppercase letters. (2.00.11.15)

Fixed server crashes caused by appending a partitioned DFS table to another. The system now reports an error for such case. (2.00.11.15)

Fixed server crashes caused by concurrent writes to an in-memory keyed table. (2.00.11.15)

Fixed server crashes caused by concurrent disk reads in the TSDB engine due to missing filter conditions in pivot by after partition pruning. (2.00.11.15)

Fixed misleading error messages returned when table joins encountered more than 2,097,152 unique values in a SYMBOL column. (2.00.11.15)

Fixed occasional server crashes when the X and Y of the corr function were tables with different numbers of columns. (2.00.11.15)

Fixed crashes in lower-version servers that occurred when remoteRunCompatible sent unsupported scripts from a higher version (>=3.00). (2.00.11.15)

Fixed server crashes caused by updating a SYMBOL column with a CHAR value in the distributed table of the TSDB database. (2.00.11.15)

Fixed incorrect results returned by each when it took a function with multiple return values as the input. (2.00.11.14)

Modified the function flatten to be compatible with previous versions. (2.00.11.14)

Fixed occasional duplicate query results for TSDB databases with keepDuplicates=FIRST during concurrent reads or writes. (2.00.11.14)

Fixed occasional server crashes and errors of missing column references during table joins caused by modifications to variable names in subqueries. (2.00.11.14)

Fixed occasional server crashes caused by concurrent writes to a shared table when its alias was specified as the output table of a streaming engine. (2.00.11.14)

Fixed unexpected partition data after restoring replicas. (2.00.11.14)

Fixed incorrect query results when the filter condition included a non-sort key column, and that condition was executed first but could not be pushed down in the TSDB engine. (2.00.11.13)

Fixed an issue of constant string parsing, e.g. string("\\\"messageCoVSONGJUNZHENG1\\\""). (2.00.11.13)

Fixed a server startup failure when function views included insert into statements. (2.00.11.13)

Fixed a potential metadata loss issue when using renameTable to rename a table that has been deleted by dropTable and the renaming operation occurred concurrently with a checkpoint operation. (2.00.11.13)

Fixed invalid online configuration modifications in a high availability cluster after a leader switch. (2.00.11.13)

Fixed potential server crashes when concurrently executing tasks generated by sqlDS through submitJob. (2.00.11.13)

Fixed occasional server crashes caused by concurrent logins when enhancedSecurityVerification=true was configured. This issue was introduced in version 2.00.11. (2.00.11.13)

Fixed occasional chunk version mismatch issues between controller and data nodes during transaction execution, which occurred after data nodes reported replica status. (2.00.11.13)

Fixed potential server crashes caused by resource tracking. (2.00.11.12)

Fixed an issue where queries failed during ej operation if the table name was not specified in the where condition. (2.00.11.12)

Fixed server crashes occurring when array vector elements exceeded the length limit during table joins. (2.00.11.12)

Fixed data loss caused by concurrent moveHotDataToColdVolume operations on the same partition. (2.00.11.12)

Fixed an issue where the batch job logs failed to record the job start times when disk space was fully occupied during job initiation. (2.00.11.12)

Fixed potential metadata loss in HA clusters due to checkpoint failures during a controller restart. (2.00.11.12)

Fixed an occasional issue where a chunk path corresponded to multiple chunk IDs. (2.00.11.12)

Fixed server crashes that occurred when executing background jobs containing lambda expressions, submitted via submitJob or scheduleJob, if the session that originally submitted the job had closed. (2.00.11.12)

Fixed an error of parseJsonTable when parsing JSON objects containing \\\". (2.00.11.12)

Fixed incorrect results returned by aggregate functions such as wsum and wavg with a scalar and an empty array as inputs. (2.00.11.12)

Fixed the lag in data nodes on rare occasions. (2.00.11.11)

Fixed the lag when submitting batch jobs on rare occasions. (2.00.11.11)

Fixed an issue where nested calls to functions move and transpose on a matrix, such as move(m.transpose(),1), output incorrect results. (2.00.11.11)

Fixed an issue where performing asof join on two partitioned in-memory tables output incorrect results. (2.00.11.11)

Fixed server crashes when using the undef function to undefine a shared table that is currently being written to. (2.00.11.11)

Fixed occasional errors when the in operator is followed by a STRING scalar in a SQL statement. (2.00.11.11)

Fixed an error when querying data where the total number of records in the involved partitions approached the maximum value for INT (2,147,483,647). (2.00.11.11)

Fixed incorrect equi join (ej) results of keyed tables. (2.00.11.9)

Fixed occasional redo log replay failures that occurred when function views were being added or deleted concurrently during a checkpoint operation. (2.00.11.9)

Fixed an issue where queries on a dimension table occasionally failed when dimension table cache was being released concurrently. (2.00.11.9)

Fixed an issue where asynchronous replication would get stuck in the slave cluster when multiple tables in a database were truncated concurrently. (2.00.11.9)

Fixed deadlocks occurring when using rpc to run a script containing a recursive function on a remote node. (2.00.11.7)

Fixed server crashes caused by SQL queries if a database path was not a string. (2.00.11.6)

Fixed an issue where replay tasks got stuck if the number of workers was significantly smaller than the number of partitions. (2.00.11.6)

Fixed an error in SQL queries with pivot by clause when the select/exec clause contained expressions. (2.00.11.6)

Fixed an error when restoring manual backup files from Amazon S3. (2.00.11.6)

Fixed server crashes when passing a tuple with no vector elements to nunique. (2.00.11.5)

Fixed an issue where data with a sort key was not properly split, leading to an excessively large block in a TSDB database when keepDuplicates = ALL. (2.00.11.5)

Fixed an issue where asynchronous replication occasionally got stuck. (2.00.11.5)

Fixed server crashes when passing a dictionary to at:R or at:L. (2.00.11.5)

Fixed occasional execution failures for tasks scheduled at around 24:00. (2.00.11.4)

Fixed occasional crashes when tracking resources were enabled. (2.00.11.4)

Fixed server crashes caused by stack overflow when using function mrank with excessively large data. (2.00.11.3)

Fixed a parsing issue for binary operator with function patterns, e.g. +:A(1, 2 3 4). (2.00.11.3)

Fixed the error when using function eval to evaluate a lambda expression parsed by parseExpr. (2.00.11.3)

Fixed an issue where the value of CODE type returned from a user-defined function was incorrectly interpreted as of STRING type. (2.00.11.3)

Fixed the deserialization failure when calling a module function with the rpc function. (2.00.11.3)

Fixed the issue where data being asynchronously replicated was removed when the controller failed to commit the transaction. This issue was introduced since version 2.00.11. (2.00.11.3)

Fixed server crashes that occurred when executing a SQL statement with vectorization applied to grouping columns and SELECT columns using the last() function without any arguments. (2.00.11.3)

Fixed a parsing issue that occurred when attempting to sort a non-existent column within a SQL statement. A validation check for the sorted column has been added, and an error will now be reported in such cases. (2.00.11.3)

Fixed data inconsistency during online recovery of replicas with large amount of different data. (2.00.11.2)

Fixed occasional server crashes caused by OOM. (2.00.11.2)

Fixed server crashes due to concurrent race conditions during remote streaming subscriptions. (2.00.11.2)

Fixed the issue where batch job queue got stuck due to job creation failures. (2.00.11.2)

Fixed a server startup failure due to deserialization error when a function view involved the update operations on shared tables. (2.00.11.1)

Fixed an issue where a transaction was stuck in a resolution state due to frequent resolution requests. (2.00.11.1)

Fixed an issue where the login or shutdown operations on a cluster via the web interface may get stuck under heavy load. (2.00.11.1)

Fixed a bug where the query scripts returned by function getUserTableAccessRecords were truncated by commas. (2.00.11.1)

Fixed occasional metadata errors arising from frequent OOM rollbacks across multiple transactions. (2.00.11.1)

Fixed incorrect results of each when the input was a partially-applied function (such as makeCall and binaryExpr). (2.00.11.1)

Fixed server crashes when the obj of upsert! was a keyed table with the original key column of STRING type and the corresponding newData column of SYMBOL type, and ignoreNull was set to true. (2.00.11.1)

Fixed incorrect results of rowImax, rowImin, rowImaxLast and rowIminLast when taking columnar tuples. (2.00.11.1)

Fixed incorrect results of add when taking BLOB vectors. (2.00.11.1)

Fixed incorrect results of update on DFS tables when aggregate functions, order-sensitive functions or user-defined functions were applied across partitions. (2.00.11.1)

Fixed incorrect query results when the where condition of a SQL query was specified as null. (2.00.11.1)

Fixed incorrect query results when a SQL query involved order by clause, and the where conditions used AND to specify multiple conditions containing aggregations. (2.00.11.1)

Fixed an error when a SQL order by clause specified variable names. This issue was introduced in versions 2.00.10 / 1.30.22. (2.00.11.1)

Fixed server crashes when using case when to evaluate an empty table in a SQL query. (2.00.11.1)

Fixed an error when using the find function in the order by clause. This issue was introduced in version 2.00.11. (2.00.11.1)

Fixed occasional server crashes during streaming subscription. (2.00.11.1)

Fixed an issue where multiple identical topics were generated after repeated streaming subscription and unsubscription. (2.00.11.1)

Fixed an error for createReactiveStateEngine when the parallelism parameter was set and metrics contained constant expressions. (2.00.11.1)

Fixed an error when sliceByKey accepted a shared keyed table as input. (2.00.11.1)

Fixed restore failures when attempting recovery for TSDB tables created without a specified sortKeyMappingFunction parameter or with sortKeyMappingFunction set to the asis function. (2.00.11.1)

Fixed an issue where users failed to delete redundant abnormal replicas through deleteReplicas. (2.00.11.1)

Fixed access denial errors when using nested function views. (2.00.11)

Fixed server crashes when appending null values to array vector columns in a window join engine. (2.00.11)

Fixed "No such file or directory" errors when reading empty dimension tables which were restored from backups after server restart. (2.00.11)

Fixed sporadic type mismatch errors during query execution for a TSDB table created with sortKeyMappingFunction when data was being flushed from cache engine to disk. (2.00.11)

Fixed server crashes when using ols on TSDB table columns without where conditions. (2.00.11)

Fixed occasional errors when renaming columns using rename!. (2.00.11)

Fixed startup failures when dataSync=1 was configured on the controller but chunkCacheEngineMemSize was not set on the compute nodes. (2.00.11)

Fixed server restart failure due to replay issues after writing strings over 64 KB to distributed tables. (2.00.11)

Fixed incorrect nunique results calculated over multiple fields. (2.00.11)

Fixed server crashes when using each on array vector columns in TSDB tables without where conditions. (2.00.11)

Fixed server crashes when the symbol :R (of high-order function eachRight) took an incorrect number of arguments. (2.00.11)

Fixed errors when querying the table imported with loadText from a non UTF-8 formatted CSV file. (2.00.11)

Fixed incorrect results when applying the string function with byRow on a matrix. (2.00.11)

Fixed incorrect align results on series with non-increasing labels that contain duplicates. (2.00.11)

Fixed incorrect results of the parallel computation of peach for ignoring null values. (2.00.11)

Fixed memory leaks when calling resample. (2.00.11)

Fixed a bug where the corrMatrix function modified values of input arguments. (2.00.11)

Fixed the following issues with fromJson (2.00.11):

• Server crashes caused by dictionary value being an empty JSON tuple.

• Incorrect results caused by dictionary value being nested JSON tuples.

Fixed occasional row count mismatch errors when specifying both partition and byColName for function unionAll. (2.00.11)

Fixed an issue where streamEngineParserfailed to create streaming engines due to parsing errors if row-based metrics invoked functions with multiple return values. (2.00.11)

Fixed an issue where the subscriber consuming messages at a slower pace compared with other subscribers failed to read data. (2.00.11)

Fixed server crashes caused by ingesting an empty table into the left table of a lookup join engine. (2.00.11)

Fixed deadlocks when two nodes simultaneously call unsubscribeTable to cancel subscriptions to the same table on a remote node. (2.00.11)

Fixed incorrect results of createTimeSeriesEngine when specifying multiple columns for timeColumn and calculating on one of the time columns. (2.00.11)

Fixed incomplete results when using the map keyword with context by clause. (2.00.11)

Fixed an issue where calculations were not conducted after sorting within groups when order-sensitive functions were used in the select clause with context by and csort. (2.00.11)

Fixed errors when using aggregate functions on vector slices in the select clause with group by. (2.00.11)

Fixed an issue where a variable with the same name as a function view was incorrectly parsed in a SQL where clause if the and operator was used. (2.00.11)

Fixed server crashes when the variable after drop table did not exist. (2.00.11)

Fixed incorrect results when using the zigzag function in the select clause with context by. (2.00.11)

Fixed server crashes on Windows when applying group by to long strings. (2.00.11)

Fixed an issue with sqlDS data sources whereby specified partitions from the right table were absent in the generated output when joining two distributed tables. (2.00.11)