Dayakar M created HIVE-29576:
--------------------------------

             Summary: RESIGNAL Statement is not working as expected.
                 Key: HIVE-29576
                 URL: https://issues.apache.org/jira/browse/HIVE-29576
             Project: Hive
          Issue Type: Bug
          Components: hpl/sql
            Reporter: Dayakar M
            Assignee: Dayakar M


RESIGNAL Statement is not working as expected. Consider the below example from 
[http://hplsql.org/resignal]
{noformat}
BEGIN
  DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
  BEGIN
    PRINT 'Error raised';
    RESIGNAL;
  END;
  PRINT 'Before executing SQL';
  SELECT * FROM abc.abc;      -- Table does not exist, error will be raised
  PRINT 'After executing SQL - will not be printed in case of error';
END;{noformat}
The above HPLSQL statements should result-in printing below statements
{noformat}
Before executing SQL
Error raised{noformat}
But it is printing the below statement also which is not expected here.
{noformat}
After executing SQL - will not be printed in case of error{noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to