[HIVE-17630] RESIGNAL:actual results are inconsistent with expectations at hplsql

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 2.2.0, 3.0.0
• Component/s: hpl/sql
• Assignee: Dmitry Tolpeko
• Reporter: ZhangBing Lin
• Created: 28/Sep/17 02:06
• Updated: 21/Dec/17 07:52

Description

when I execute example 3 at http://www.hplsql.org/resignal:

BEGIN
DECLARE EXIT HANDLER FOR SQLEXCEPTION
BEGIN
GET DIAGNOSTICS EXCEPTION 1 text = MESSAGE_TEXT;
PRINT 'SQLSTATE: ' || SQLSTATE;
PRINT 'Text: ' || text;
END;

BEGIN
DECLARE EXIT HANDLER FOR SQLEXCEPTION
RESIGNAL SQLSTATE '02031' SET MESSAGE_TEXT = 'Some error';

SELECT * FROM abc.abc; – Table does not exist, raise an exception
END;
END;

Actual results:
SQLSTATE: 42S02
Text: Error while compiling statement: FAILED: SemanticException [Error 10001]: Line 1:14 Table not found 'abc'

The official result is：
SQLSTATE: 02031
Text: Some error