Add support for Exasol 8
Closed this issue · 0 comments
https://github.com/exasol/virtual-schema-common-document/releases/tag/10.1.0 adds support for Exasol 8. We need to upgrade to this version to allow virtual schemas to work with Exasol 8.
Release notes for virtual-schema-common-document
Support ALTER VIRTUAL SCHEMA SET
This release adds support for ALTER VIRTUAL SCHEMA SET
. This will allow changing properties like MAPPING
of document based virtual schemas without dropping and re-creating the virtual schema:
-- Update EDML mapping of the virtual schema
ALTER VIRTUAL SCHEMA MY_VIRTUAL_SCHEMA SET MAPPING = '...'
-- Enable remote logging or change the log level
ALTER VIRTUAL SCHEMA MY_VIRTUAL_SCHEMA SET DEBUG_ADDRESS = 'host:3000' LOG_LEVEL = 'FINEST'
ALTER VIRTUAL SCHEMA MY_VIRTUAL_SCHEMA SET LOG_LEVEL = 'INFO'
Remove support for TIMESTAMP WITH LOCAL TIME ZONE
This release adds support for Exasol 8 by removing support for data type TIMESTAMP WITH LOCAL TIME ZONE
. This type caused problems with the stricter type checks enabled by default in Exasol, causing pushdown queries for document based virtual schemas to fail with the following error:
Data type mismatch in column number 5 (1-indexed).Expected TIMESTAMP(3) WITH LOCAL TIME ZONE, but got TIMESTAMP(3).
We fixed this error by removing support TIMESTAMP WITH LOCAL TIME ZONE
completely. This is a breaking change, so we updated the version to 10.0.0.