[teiid-issues] [JBoss JIRA] (TEIID-5445) Atomic block is ignored when working with execute immediate command
dalex dalex (JIRA)
issues at jboss.org
Wed Aug 15 12:58:00 EDT 2018
dalex dalex created TEIID-5445:
----------------------------------
Summary: Atomic block is ignored when working with execute immediate command
Key: TEIID-5445
URL: https://issues.jboss.org/browse/TEIID-5445
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 10.2
Environment: teiid-10.2.0 on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final)
Reporter: dalex dalex
Assignee: Steven Hawkins
Priority: Blocker
When calling in atomic block a proc which is throwing an exception after updating some rows these changed rows won't be rolled back. That is running the following query:
{code:sql}
begin atomic
call test_upd.upd();
end ;;
{code}
all changes done in the test_upd.upd virtual procedure won't be rolled back in case of a thrown exception there. If I'm not mistaken such behavior was introduced in scope of TEIID-4504 issue (after introducing the Program.instructionsRequireTransaction method).
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
More information about the teiid-issues
mailing list