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)