[HIVE-21120] Bug while executing control structure with subquery

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Target Version/s: 3.1.1
• Assignee: Unassigned
• Reporter: Dennis
• Created: 12/Jan/19 10:10
• Updated: 12/Jan/19 10:10

Description

I found a bug in HPL/SQL 0.3.31 integrated in Hive Service.
When I execute following Stored Procedure, the Print inside the IF Statement is not reached:
 
CREATE PROCEDURE EVALUATION
BEGIN 
DECLARE Result DOUBLE;
SELECT Result = MAX(LISTPRICE) FROM PRODUCT_ORC;
PRINT Result;
    IF CAST(Result AS DOUBLE) > 500.00 THEN
     PRINT 'IF wird aufgerufen';
    END IF;
END
 
You can reproduce the bug, when you run following SQL Statements in hive, before you start the HPL/SQL stored procedure
CREATE TABLE adventureworks.PRODUCT_ORC
(
  productid int,
  listprice double
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS ORC
TBLPROPERTIES("transactional"="true");

INSERT INTO PRODUCT_ORC VALUES (1, 250.358);
INSERT INTO PRODUCT_ORC VALUES (2, 358.485);
INSERT INTO PRODUCT_ORC VALUES (3, 501.525);