[FLINK-21284] Non-deterministic functions return different values

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Component/s: Table SQL / Planner
• Assignee: Unassigned
• Reporter: hehuiyuan
• Created: 05/Feb/21 02:06
• Updated: 01/Apr/21 15:34
• Resolved: 01/Apr/21 15:34

Description

Non-deterministic UDF functions is used mutiple times , the result is different.

 

Table tm = tableEnv.sqlQuery("select name, RAND_INTEGER(10) as sample , sex from myhive_staff");
tableEnv.registerTable("tmp", tm);


tableEnv.sqlUpdate("insert into sinktable select * from tmp  where sample >= 8");


}

 

RAND_INTEGER()  function is used for `RAND_INTEGER(10) as sample`  when sink,

which lead  to  inconsistent result.

 

 

 

Issue Links

• is duplicated by: FLINK-20887 Non-deterministic functions return different values even if it is referred with the same column name