Calling an emitting script without arguments followed by another column in the SELECT list causes internal server error

Detail name	Value
Changelog Number	5035
Type	Bug
Status	Resolved
Affected Versions	EXASOL 6.0.0, Exasol 6.1.0, Exasol 6.2.0, Exasol 7.0.alpha1
Fix Versions	Exasol 7.0.0, Exasol 6.2.5
Resolution Date	2020-03-11

Bug

If an emitting UDF without arguments is called in the SELECT list and there is at least one column behind the script call, then an internal server error is caused.

Example

SELECT emit_something(), 'column behind script call'
FROM dual;

Workaround

Move the script call to the end of the SELECT list:

SELECT 'column before script call', emit_something()
FROM dual;

If this is not possible, add a dummy parameter to the emitting function:

SELECT emit_something('dummy parameter'), 'column behind script call'
FROM dual;