[ASTERIXDB-3515] Incorrect result when non-pure function passed as udf argument

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: COMP - Compiler
• Labels: triaged
• Assignee: Unassigned
• Reporter: Peeyush Gupta
• Created: 10/Oct/24 16:00
• Updated: 11/Oct/24 17:05

Description

Create the following UDF

CREATE FUNCTION check(x)  {    
   select case when x=x then 10 else 0 end
}

The following query returns 0 instead of 10

select check(random()) 

We should not inline non-pure functions in UDF body.