[HIVE-17452] HPL/SQL function variable block is not initialized

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 3.0.0
• Component/s: hpl/sql
• Assignee: Dmitry Tolpeko Assign to me
• Reporter: Dmitry Tolpeko
• Created: 05/Sep/17 09:09
• Updated: 22/May/18 23:13
• Resolved: 25/Sep/17 08:41

Description

Variable inside declaration block are not initialized:

CREATE FUNCTION test1()
  RETURNS STRING
AS
  ret string DEFAULT 'Initial value';
BEGIN
  print(ret);
  ret := 'VALUE IS SET';
  print(ret);
END;

test1();

Output:

ret      
VALUE IS SET

Should be:

Initial value     
VALUE IS SET