]
Dmitrii Pogorelov commented on TEIID-5739:
------------------------------------------
[~shawkins] thx a lot for the quick fix. I've already checked, these changed worked
for us.
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}