Native cloud deployment on Azure is not available for this version of Exasol, but you can install Exasol as a Linux application on Azure instances. For more information, see Installation.

Native cloud deployment on Google Cloud is not available for this version of Exasol, but you can install Exasol as a Linux application on Google Cloud instances. For more information, see Installation.

Quoted identifiers can contain dot

Details

Detail name	Value
Changelog Number	11858
Type	Improvement
Status	Resolved
Fix Versions	Exasol 8.0.0
Resolution Date	2022-04-20

Improvement

Following the SQL Standard, quoted identifiers can now contain dots. This also applies to identifiers quoted with square brackets.

Example

SELECT * FROM "S.1"."T.1";
select C as [C.C] from [T.T];

Error messages

Error messages are improved to show qualified identifiers with correct quoting.

Changed Behavior

The following system tables for virtual schemas are changed in 8.0:

EXA_DBA_VIRTUAL_SCHEMAS
EXA_USER_VIRTUAL_SCHEMAS
EXA_ALL_VIRTUAL_SCHEMAS
EXA_VIRTUAL_SCHEMAS.

In each of these tables, the adapter is now identified by the new columns ADAPTER_SCRIPT_SCHEMA and ADAPTER_SCRIPT_NAME. The column ADAPTER_SCRIPT, which identified the adapter by a qualified name such as "MY_SCHEMA.MY_SCRIPT", has been removed.

Changed behavior

Quoted identifiers can now contain dots. Error messages are improved to fully-qualify identifiers and use correct quoting. Adapter script schema and name are now separate columns in system tables for virtual schemas.