[ https://issues.apache.org/jira/browse/HIVE-17452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16178736#comment-16178736 ]
Dmitry Tolpeko commented on HIVE-17452: --------------------------------------- Committed. > HPL/SQL function variable block is not initialized > -------------------------------------------------- > > Key: HIVE-17452 > URL: https://issues.apache.org/jira/browse/HIVE-17452 > Project: Hive > Issue Type: Bug > Components: hpl/sql > Reporter: Dmitry Tolpeko > Assignee: Dmitry Tolpeko > Priority: Critical > Attachments: HIVE-17452.1.patch > > > Variable inside declaration block are not initialized: > {code} > CREATE FUNCTION test1() > RETURNS STRING > AS > ret string DEFAULT 'Initial value'; > BEGIN > print(ret); > ret := 'VALUE IS SET'; > print(ret); > END; > test1(); > {code} > Output: > {code} > ret > VALUE IS SET > {code} > Should be: > {code} > Initial value > VALUE IS SET > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)