[
https://issues.apache.org/jira/browse/HIVE-17630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16183687#comment-16183687
]
ZhangBing Lin edited comment on HIVE-17630 at 9/28/17 5:32 AM:
---------------------------------------------------------------
At this page [http://www.hplsql.org/resignal],Example 1 and Example 2, actual
results and sample results are inconsistent.
was (Author: linzhangbing):
At this page [http://www.hplsql.org/resignal],Example 1 and Example, actual
results and sample results are inconsistent.
> 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)
