[ https://issues.jboss.org/browse/TEIID-1386?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-1386: ---------------------------------- Fix Version/s: 8.0 Priority: Critical (was: Major) Affects: [Documentation (Ref Guide, User Guide, etc.), Release Notes] The general steps for this: - Allow the error statement to specify a sqlstate and chain exceptions - add exception handling to compound statements, this could be pl/sql like using an exception clause or like ANSI sql using handler declarations - ensure that all Teiid processing exceptions have proper state codes Nice to have features: - add the ability to emit warnings - add the ability to check for warnings procedure logic - mnemonics for common state codes -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1386?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-1386: ---------------------------------- Fix Version/s: 8.2 (was: 8.1) Pushing to 8.2 -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1386?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1386: --------------------------------------- we now support a raise statement: {code}RAISE e;{code} where e can be a variable reference to an exception or an exception expression: {code}(SQLEXCEPTION|SQLWARNING) msg [SQLSTATE state [, errCode]] EXCEPTION e{code} where msg is a string expression of the message, state is a string expression of the SQLState, errCode is an integer expression of the error/vendor code, and e is a variable reference to an exception or an exception expression of the parent/nested exception. i.e. {code}RAISE SQLEXCEPTION 'error' SQLSTATE 'abc'{code} The error statement {code}ERROR 'blah';{code} is still accepted, but is parsed as {code}RAISE SQLEXCEPTION 'blah'{code} When a warning is raised, it will be attached to the CommandContext and returned to the client, but it will not cause the current block to exit. There were also corrections made to the handling of sqlstate/error code in the TeiidSQLException to ensure proper values are reported to clients. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1386?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-1386. --------------------------------- -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira