[
https://issues.jboss.org/browse/TEIID-5739?page=com.atlassian.jira.plugin...
]
Dmitrii Pogorelov edited comment on TEIID-5739 at 5/9/19 9:39 AM:
------------------------------------------------------------------
[~shawkins] thx a lot for the quick fix. I've already checked, these changes worked
for us.
was (Author: dalex005):
[~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}
--
This message was sent by Atlassian Jira
(v7.12.1#712002)