Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Did you know our release names are dedicated to employee pups? For our second release, Penny was the star.
Here is a bit about Penny:
Hi I am Penny! My dad is Kyle Bernhardy, the CTO of HarperDB. I am a nine-year-old Whippet who lives for running hard and fast while exploring the beautiful terrain of Colorado. My favorite activity is chasing birds along with afternoon snoozes in a sunny spot in my backyard.
1/29/2021
Bug Fixes
CORE-1218 A bug in HarperDB 2.3.0 was identified related to manually calling the create_attribute
operation. This bug caused secondary indexes to be overwritten by the most recently inserted or updated value for the index, thereby causing a search operation filtered with that index to only return the most recently inserted/updated row. Note, this issue does not affect attributes that are reflexively/automatically created. It only affects attributes created using create_attribute
. To resolve this issue in 2.3.0 or earlier, drop and recreate your table using reflexive attribute creation. In 2.3.1, drop and recreate your table and use either reflexive attribute creation or create_attribute
.
CORE-1219 Increased maximum table attributes from 1000 to 10000
12/03/2020
Features/Updates
CORE-1191, CORE-1190, CORE-1125, CORE-1157, CORE-1126, CORE-1140, CORE-1134, CORE-1123, CORE-1124, CORE-1122 Added JWT Authentication option (See documentation for more information)
CORE-1128, CORE-1143, CORE-1140, CORE-1129 Added upsert
operation
CORE-1187 Added get_configuration
operation which allows admins to view their configuration settings.
CORE-1175 Added new internal LMDB function to copy an environment for use in future features.
CORE-1166 Updated packages to address security vulnerabilities.
Bug Fixes
CORE-1195 Modified drop_attribute
to drop after data cleanse completes.
CORE-1149 Fix SQL bug regarding self joins and updates alasql to 0.6.5 release.
CORE-1168 Fix inconsistent invalid schema/table errors.
CORE-1162 Fix bug which caused delete_files_before
to cause tables to grow in size due to an open cursor issue.
08/24/2020
Features/Updates
CORE-997 Updated the data format for CSV data loads being sync'd across a cluster to take up less resources
CORE-1018 Adds SQL functionality for BETWEEN
statements
CORE-1032 Updates permissions to allow regular users (i.e. non-super users) to call the get_job
operation
CORE-1036 On create/drop table we auto create/drop the related transactions environments for the schema.table
CORE-1042 Built raw functions to write to a tables transaction log for insert/update/delete operations
CORE-1057 Implemented write transaction into lmdb create/update/delete functions
CORE-1048 Adds SEARCH
wildcard handling for role permissions standards
CORE-1059 Added config setting to disable transaction logging for an instance
CORE-1076 Adds permissions filter to describe operations
CORE-1043 Change clustering catchup to use the new transaction log
CORE-1052 Removed word "master" from source
CORE-1061 Added new operation called delete_transactions_before
this will tail a transaction log for a specific schema / table
CORE-1040 On HarperDB startup make sure all tables have a transaction environment
CORE-1055 Added 2 new setting to change the server headersTimeout & keepAliveTimeout from the config file
CORE-1044 Created new operation read_transaction_log
which will allow a user to get transactions for a table by timestamp
, username
, or hash_value
CORE-1043 Change clustering catchup to use the new transaction log
CORE-1089 Added new attribute to system_information
for table/transaction log data size in bytes & transaction log record count
CORE-1101 Fix to store empty strings rather than considering them null & fix to be able to search on empty strings in SQL/NoSQL.
CORE-1054 Updates permissions object to remove delete attribute permission and update table attribute permission key to attribute_permissions
CORE-1092 Do not allow the __createdtime__
to be updated
CORE-1085 Updates create schema/table & drop schema/table/attribute operations permissions to require super user role and adds integration tests to validate
CORE-1071 Updates response messages and status codes from describe_schema
and describe_table
operations to provide standard language/status code when a schema item is not found
CORE-1049 Updates response message for SQL update op with no matching rows
CORE-1096 Added tracking of the origin in the transaction log. This origin object stores the node name, timestamp of the transaction from the originating node & the user.
Bug Fixes
CORE-1028 Fixes bug for simple SQL SELECT
queries not returning aliases and incorrectly returning hash values when not requested in query
CORE-1037 Fixed an issue where numbers with leading zero i.e. 00123 are converted to numbers rather than being honored as strings.
CORE-1063 Updates permission error response shape to consolidate issues into individual objects per schema/table combo
CORE-1098 Fixed an issue where transaction environments were remaining in the global cache after being dropped.
CORE-1086 Fixed issue where responses from insert/update were incorrect with skipped records.
CORE-1079 Fixes SQL bugs around invalid schema/table and special characters in WHERE
clause
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.
10/27/2020
CORE-1154 Allowed transaction logging to be disabled even if clustering is enabled.
CORE-1153 Fixed issue where delete_files_before
was writing to transaction log.
CORE-1152 Fixed issue where no more than 4 HarperDB forks would be created.
CORE-1112 Adds handling for system timestamp attributes in permissions.
CORE-1131 Adds better handling for checking perms on operations with action value in JSON.
CORE-1113 Fixes validation bug checking for super user/cluster user permissions and other permissions.
CORE-1135 Adds validation for valid keys in role API operations.
CORE-1073 Adds new import_from_s3
operation to API.
11/16/2020
CORE-1158 Performance improvements to core delete function and configuration of delete_files_before
to run in batches with a pause into between.