Data Virtuality Platform 3.7: caching improvements and bug fixes

This small release brings an important improvement for the Server and several bug fixes - four for the Server, one for the Exasol connector.

On the Server side, we've implemented a new stored procedure for cleaning the ResultSet cache.

As for the bug fixes, most importantly, we've resolved the issue with "AssertionError: Batch not found in storage" thrown by the replication jobs when local temporary tables are used; now all is well. We've also fixed the LEFT JOIN of system tables related to modular connectors which yielded incorrect result due to incorrect primary keys set. Also, the SYSADMIN.writeConnProp procedure now validates the property name correctly, and the connect-dv-role now has all the permissions required by the new Web Interface.

Another bug fix relates to the Exasol connector: previously, casting of DOUBLE to VARCHAR caused zero after the decimal point to disappear, and now everything works properly.

Here are all issues in this release:

Server:

• DVCORE-7955 (Improvement): Implement a stored procedure for cleaning the ResultSet cache
• DVCORE-7978 (Bug Fix): "AssertionError: Batch not found in storage" is thrown by the replication jobs when local temporary tables are used
• DVCORE-7933 (Bug Fix): LEFT JOIN of system tables related to modular connectors yields incorrect result due to incorrect primary keys set
• DVCORE-7927 (Bug Fix): SYSADMIN.writeConnProp procedure does not validate the property name
• DVCORE-7921 (Bug Fix): The "connect-dv-role" lacks some permissions required by the new web UI

Connectors:

• DVCORE-7876 (Bug Fix): Exasol: casting of DOUBLE to VARCHAR causes zero after the decimal point to disappear