[TRAFODION-2611] Input parameters and current functions in input tables of TMUDFs

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0-incubating
• Fix Version/s: 2.2.0
• Component/s: sql-cmp
• Environment: any
• Assignee: Hans Zeller
• Reporter: Hans Zeller
• Created: 10/May/17 20:53
• Updated: 26/Mar/18 16:52
• Resolved: 17/May/17 16:11

Description

When the input of a table-mapping UDF (TMUDF) contains a parameter or a function that should be evaluated only once, such as current_timestamp, we do not always set up the correct data flow. This is visible, for example, when using a parallel UDF query that has "current_timestamp" as an input:

control query shape esp_exchange(cut,4);
select * from udf(echo(table(select current_timestamp from tsrc <<+cardinality 1e9>>)));
execute s;

This query could return different timestamps, which is wrong, all rows should have the same timestamp. A similar issue could happen with input parameters.

Issue Links

• links to: GitHub Pull Request #1092