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*
onJOIN
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.
Last modified 9mo ago