2.1.1

05/22/2020
Highlights
CORE-1007 Added the ability to perform SQL INSERT & UPDATE with function calls & expressions on values.
CORE-1023 Fixed minor bug in final SQL step incorrectly trying to translate ordinals to alias in ORDER BY statement.
CORE-1020 Fixed bug allowing 'null' and 'undefined' string values to be passed in as valid hash values.
CORE-1006 Added SQL functionality that enables JOIN statements across different schemas.
CORE-1005 Implemented JSONata library to handle our JSON document search functionality in SQL, creating the SEARCH_JSON function.
CORE-1009 Updated schema validation to allow all printable ASCII characters to be used in schema/table/attribute names, except, forward slashes and backticks. Same rules apply now for hash attribute values.
CORE-1003 Fixed handling of ORDER BY statements with function aliases.
CORE-1004 Fixed bug related to SELECT* on JOIN queries with table columns with the same name.
CORE-996 Fixed an issue where the transact_to_cluster flag is lost for CSV URL loads, fixed an issue where new attributes created in CSV bulk load do not sync to the cluster.
CORE-994 Added new operation system_information. This operation returns info & metrics for the OS, time, memory, cpu, disk, network.
CORE-993 Added new custom date functions for AlaSQL & UTC updates.
CORE-991 Changed jobs to spawn a new process which will run the intended job without impacting a main HarperDB process.
CORE-992 HTTPS enabled by default.
CORE-990 Updated describe_table to add the record count for the table for LMDB data storage.
CORE-989 Killed the socket cluster processes prior to HarperDB processes to eliminate a false uptime.
CORE-975 Updated time values set by SQL Date Functions to be in epoch format.
CORE-974 Added date functions to SQL SELECT column alias functionality.
2.2.0
HarperDB Alby (Version 1)
Last modified 3mo ago