[
https://issues.jboss.org/browse/TEIID-5739?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-5739.
-----------------------------------
Fix Version/s: 12.2
12.1.2
Resolution: Done
Two changes were needed. First expanded handling of the preceding comment, and adding EOF
as expected for later parsing of a procedure body - this ensures that an exception would
have been thrown in this situation.
Procedure does not get executed (without error) when comment and
variable declaration are present
-------------------------------------------------------------------------------------------------
Key: TEIID-5739
URL:
https://issues.jboss.org/browse/TEIID-5739
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 12.0
Reporter: Dmitrii Pogorelov
Assignee: Steven Hawkins
Priority: Blocker
Fix For: 12.2, 12.1.2
Using the below definition, it should delete the data from the table. It will do it if
you either remove the comment or the variable declaration. Interestingly, it looks like
the proc is executed, but the data is still present in the test table:
{code:sql}
create virtual procedure deleteTableTest (
) AS
--
begin
declare string v;
execute immediate 'DELETE from dwh.testRemove' without return ;
end
{code}
--
This message was sent by Atlassian Jira
(v7.12.1#712002)