[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-3034) Importing Virtual Procedure DDL containing a simple RETURNS type add a Result Set to procedure

Importing Virtual Procedure DDL containing a simple RETURNS type add a Result Set to procedure ---------------------------------------------------------------------------------------------- Key: TEIIDDES-3034 URL: https://issues.jboss.org/browse/TEIIDDES-3034 Project: Teiid Designer Issue Type: Enhancement Reporter: Barry LaFond Assignee: Barry LaFond Fix For: 11.1.2 Attachments: viewModelFromComment.png, viewModelFromDescription.png testing and debugging for TEIIDDES-2783 exposed an issue when importing a procedure containing a RETURNS data type and no result set. The transformation resolving framework contains logic that will auto-create a result set containing a generated column. We need to catch this use-case and prevent the result set from being created using this simple DDL input {code} CREATE VIRTUAL PROCEDURE ProcedureWithRS ( stringIN string(4000) OPTIONS(ANNOTATION 'parameter 1 description') ) RETURNS string(255) OPTIONS(ANNOTATION 'Example') AS BEGIN SELECT stringIN AS result; END {code}