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

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}