exasol/virtual-schema-common-document-files

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.