[jira] [Commented] (HIVE-17630) RESIGNAL:actual results are inconsistent with expectations at hplsql

["ZhangBing Lin (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-17630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16201293#comment-16201293 ] 

ZhangBing Lin commented on HIVE-17630:
--------------------------------------

[~dmtolpeko],Where do you find a problem? Or what parameters I need special settings?

> RESIGNAL:actual results are inconsistent with expectations at hplsql
> --------------------------------------------------------------------
>
>                 Key: HIVE-17630
>                 URL: https://issues.apache.org/jira/browse/HIVE-17630
>             Project: Hive
>          Issue Type: Bug
>          Components: hpl/sql
>    Affects Versions: 2.2.0, 3.0.0
>            Reporter: ZhangBing Lin
>            Assignee: Dmitry Tolpeko
>            Priority: Minor
>
> 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



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)