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

Steven Hawkins (Jira) issues at jboss.org
Wed May 8 12:44:00 EDT 2019


     [ 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)


More information about the teiid-issues mailing list