[ https://issues.apache.org/jira/browse/TRAFODION-2611?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hans Zeller updated TRAFODION-2611: ----------------------------------- 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: {noformat} control query shape esp_exchange(cut,4); select * from udf(echo(table(select current_timestamp from tsrc <<+cardinality 1e9>>))); execute s; {noformat} This query could return different timestamps, which is wrong, all rows should have the same timestamp. A similar issue could happen with input parameters. was: 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: {noformat} control query shape esp_exchange(cut,4); select * from udf(echo(table(select current_timestamp from tsrc <<+cardinality 1e9>>))); execute s; {noformat} This query could return different timestamps, which is wrong, all rows should have the same timestamp. > Input parameters and current functions in input tables of TMUDFs > ---------------------------------------------------------------- > > Key: TRAFODION-2611 > URL: https://issues.apache.org/jira/browse/TRAFODION-2611 > Project: Apache Trafodion > Issue Type: Bug > Affects Versions: 2.0-incubating > Environment: any > Reporter: Hans Zeller > Assignee: Hans Zeller > Fix For: 2.2-incubating > > Attachments: EchoUdf.cpp > > > 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: > {noformat} > control query shape esp_exchange(cut,4); > select * from udf(echo(table(select current_timestamp from tsrc > <<+cardinality 1e9>>))); > execute s; > {noformat} > This query could return different timestamps, which is wrong, all rows should > have the same timestamp. A similar issue could happen with input parameters. -- This message was sent by Atlassian JIRA (v6.3.15#6346)