Wrong error message for IMPORT/EXPORT with script instead UDF
Details
| Detail name | Value |
|---|---|
| Changelog Number | 9408 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 6.1.0, Exasol 6.2.0 |
| Fix Versions | Exasol 7.0.0 |
| Resolution Date | 2020-09-11 |
Background
Exasol only supports 'IMPORT/EXPORT FROM SCRIPT' in combination with UDF scriprts.
Problem
If an IMPORT/EXPORT uses a (LUA) procedure script instead of a UDF, Exasol throws an internal server error.
Example:
CREATE SCHEMA test; --/ CREATE OR REPLACE SCRIPT TEST_SCRIPT RETURNS TABLE AS return "" / IMPORT INTO (c1 VARCHAR(2000)) FROM SCRIPT TEST_SCRIPT;
Starting with version 7.0.0, Exasol properly throws a 'Feature not supported' error.