hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ZhangBing Lin (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-17630) RESIGNAL:actual results are inconsistent with expectations at hplsql
Date Thu, 28 Sep 2017 05:32:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-17630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

ZhangBing Lin updated HIVE-17630:
---------------------------------
    Affects Version/s: 3.0.0
                       2.2.0

> 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)

Mime
View raw message