Creating views may trigger execution of referenced UDFs
Details
| Detail name | Value |
|---|---|
| Changelog Number | 10753 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 6.1.0, Exasol 6.2.0, Exasol 7.0.0 |
| Fix Versions | Exasol 7.0.3, Exasol 6.2.11 |
| Resolution Date | 2020-10-05 |
Description
UDFs should only be executed during query execution. However, a UDF might be executed during view creation if:
- the view definition contains a function with at least one parameter
- all parameters are constant values
- this function must call a UDF
Workaround
Add a dummy parameter to the function that is not used within the body of the function, but is called with a non-constant value (e.g. random()).
Fix
Creating a view does not trigger UDF execution
