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

[Steven Hawkins (Jira)]

     [ https://issues.jboss.org/browse/TEIID-5739?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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)