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.