[teiid-issues] [JBoss JIRA] (TEIID-5739) Procedure does not get executed (without error) when comment and variable declaration are present

[Dmitrii Pogorelov (Jira)]

Dmitrii Pogorelov created TEIID-5739:
----------------------------------------

             Summary: 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


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)